Link to home
Start Free TrialLog in
Avatar of csimmons1324
csimmons1324Flag for United States of America

asked on

Help with Creating ODBC Connector using SQL Server Authentication

I am trying to setup an ODBC connection.  The server is Windows Server 2012 running SQL 2014.  The client machine is a Windows 8 64-bit PC.  

On the client, I go into the SysWOW64 folder and run the odbcad32.exe as an administrator.  When selecting the authentication method, if I choose WIndows NT authentication I have no option of typing a username or password.  Therefore, I am under the impression that it is using the Administrator account that I used when I launched odbcad32.exe.  Using the Windows NT authentication mode, I am able to connect to the database.  

If I select, SQL Server authentication using the same Administrator credentials that I used to launch odbcad32.exe then the connection fails.  I receive  the following error:

Connection Failed:
SQLState: '28000'
SQL Server Error: 18456

I would like to use this method as I want to connect with a user that has limited rights to a database.  I double checked my SQL server and it is configured as "SQL Server and Windows Authentication Mode."

Any help is appreciated!
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
csimmons1324, do you still need help with this question?