By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

How to use MS Access to connect to a SQL server using "Windows Authentication"?

anoble1
100+
P: 223
Hi,

I am having a slight problem connecting to my SQL Server using MS Access. My SQL server does not use a Username adn Password like all the other ones I have seen. They use the "windows authentication". How do you let access use "windows authentication"? Are you supposed to use the UID? And PASS? Is their a workaround?

Expand|Select|Wrap|Line Numbers
  1. Public Function PingTRIPSDatabaseITUAServer()
  2.  
  3.      Dim connectString As String
  4.       'connectString = "ODBC;Driver={SQL Server};Server=GAXGPSQ05UA;Database=TRIPS;UID=trimsuser;pwd=trimsdata"
  5.       connectString = "ODBC;Driver={SQL Server};Server=ALBHM01CGSERVER;Database=Core;UID=????;pwd=????"
  6.       Set db = DBEngine.OpenDatabase("", False, True, connectString)
  7.   End Function
May 7 '12 #1

✓ answered by Rabbit

Use a trusted connection
Trusted_Connection=yes

Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,357
Use a trusted connection
Trusted_Connection=yes
May 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.