How to Stop asking SQL Server Login dialog box

[#1]

Hello,

I want to stop the SQL Server Login dialog box when i reload the application. How can i stop this?

[#2 · Accepted solution]

check the box  'Allow saving password' when create the connection string.

[#3]

Where can i check "Allow Saving Password". When i check Use Trusted Connection it is not connecting to server.

[Anonymous]

If you are connecting using ODBC or OLEDB then try to save the password as mentioned by hangwong or provide it as part of Connect statement.

I hope this helps

Regards
MultiView

[#5]

In the loading script, click 'Connect' button. After choosing the connector/ provider, under 'Connection' tab, there should have a checkbox for 'allow saving password'

[SunilChauhan]

Create a dsn  for same and then connect using dsn .

it will ask once password at the time of creating dsn .

hope this help

[#7]

Thanks a lot.