ODBC connection failure from Linux to SQL Server

Hello,

I have a client attempting to connect to SQL Server 2008 from Access 2010 on a Linux machine. The connection string is the standard ODBC connection string;

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

but the connection always prompts for the username and password.

What changes to the connection string do I need to make in order for this to connect without the login credentials prompt appearing.

Thank you.

August 22nd, 2015 7:47pm

check sql error log.
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 9:25pm

YOu are already passing the userid and Password to the connection string. so you no need to pass again from SQL server point of view.

Every time you try to connect you need to enter again that is network level authentication.

You need to provide. This is not required id machines are in the same domain and in the same active directory. 

August 24th, 2015 12:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics