Prompt user for sql server login details

[Meltdown]

Hi all,

How do i prompt user for their sql server login details?

I've been asked to create a 'default' account, so it's not tied to windows authentication. I've set up the sql server login.

I relinked my tables as follows:
I created a new DSN and chose the option to use Sql server login, supplied my login details and made the connection to the db, can see the tables.
However, the connection seems to be permanent, when I shut down and go back in, I'm not prompted for any login details?

Regards
Melt

 

[georgedwilkinson]

I think I was able to do this by NOT including a user/password in the DSN along with not using Windows authentication. You may have to experiment to validate that.

Unfortunately, I don't have a test environment right now.