R
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
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