SQL server 2005 in VC++ using CLI

Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection. SQLSTATE: 28000

This error is occurred in SQLDriverConnect method

connString= "DRIVER={SQL Server Native Client 10.0};SERVER=IPofServer\SQLEXPRESS;DATABASE=DBName;Trusted_Connection=yes;";

SQLDriverConnect (sqlconnectionhandle , NULL , (SQLCHAR*)connString , SQL_NTS , retconstring , 1024 , NULL , SQL_DRIVER_NOPROMPT ));

I m Using Remote Database means Database is on server and client is on another host(Machine)

Please help

Thanxs in Advance

asked Apr 07 '12 at 05:04 AM in Default

sanj_love89
0 ● 1 ● 1 ● 1

(comments are locked)

2 answers:

Thanxs Thomas Rushton

But how to granted access to the SQL Server to which Client trying to connect

answered Apr 09 '12 at 05:07 AM

sanj_love89
0 ● 1 ● 1 ● 1

(comments are locked)

This is probably down to your user ID (or the user ID under which the application is running) hasn't been granted access to the SQL Server to which you are trying to connect. "Trusted_Connection" means that the SQL Server is using your Active Directory credentials to connect, rather than using a SQL Server user name / password.

answered Apr 07 '12 at 09:22 PM