Prompt for SQL Login if no Windows Auth available

[Rob Farley]

Hi,

I apologise if this is a question that's been answered everywhere else.

This week I'm helping out the employer of a friend (Kelvin Wilson) who died
recently. Kelvin has a nice .adp which connects using Windows Auth to a SQL
box.

I'm tasked with providing access (via SQL Login) to users who don't have
Windows accounts. The SQL box is set up to allow both authentication
methods.

What I would like is to be able attempt a Windows Login, but then prompt for
SQL Login details if that fails. Is this possible? And if so, how do I go
about it?

TIA,

Rob

 

[aaron.kempf]

check out the code in NorthwindCS.adp it has some crazy logic similar
to this
so when the windows authentication fails; then you prompt them for sql
authentication.

if worst comes to worse; then it might need an inputBox and then you
build the username and logon

-Aaron