Home » Access Tips And Tricks » SQL Server Connection Strings

I recently encountered a situation where I was attempting to create a link to a SQL Server table using a UserID and Password, on a SQL Server with Mixed Mode Authentication turned on.  The connection string I was using looked like:
ODBC;Driver=SQL Server Native Client 10.0:Server=<myServerName>;Database=<myDatabaseName>;UID=<myWindowsUserID>;PWD=<myWindowsPassword>
and I kept getting an error with that string:
Login failed for user ‘myWindowsUserID’
Reason: Could not find a login matching the name provided
I then tried a connection string which replaced:
<myWindowsUserID> with <domain\myWindowsUserID>
but this returned another error.
Login failed for user ‘domain\myWindowsUserID’

Reason: Attempting to use an NT account name with SQL Server Authentication
I found this strange because I was able to link the table using “Trusted_Connection=Yes”.  But it turns out that you cannot use your Windows UserID and password as login critieria for SQL Authentication.  Who knew?

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *