We help IT Professionals succeed at work.

ODBC Trusted Connection Property

Medium Priority
1,374 Views
Last Modified: 2012-05-04
Hi,

I have an MS Access 2000 application - with a fixed link to tables on an SQL server.  I have set up a File DSN and choosen the "With SQL Server authorisation using a login ID and password supplied by the user" option.

However every time I want to use the application I get a " Connection failed;SQLm State '28000' SQL Server Error: 18456 login failed message - bacause the Login ID defaults to my network login ID.  I can press ok at that stage and then remove tick from the trusted connection box and enter my SQL password but I don't want the user to have to do this every time they use the application.

Can someone tell me how I can get this to default to no trusted connection?

Thanks,

Andrew
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.