471,073 Members | 1,134 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn

1
hi,

there are two win2003 servers in the same workgroup. one has mssql 2000 server and other one has asp.net 2.0 web application connecting that mssql server. mssql server Authentication is SQL Server and Windows but when i try to connect using sql authentication with uid and pwd, i get the error;
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

searched a lot about it but couldnt find any solutions. the win2003 server which hosts mssql server has active directory. is this could be the problem? thanks in advance.

amet


edit :
here is my connection string;
"data source=192.168.16.1;initial catalog=SOLAR4;Trusted_Connection=yes;UID=Sql_user ;PWD=123;"

sql_user is dbowner of Solar4 database.
Apr 3 '08 #1
1 1398
ck9663
2,878 Expert 2GB
hi,

there are two win2003 servers in the same workgroup. one has mssql 2000 server and other one has asp.net 2.0 web application connecting that mssql server. mssql server Authentication is SQL Server and Windows but when i try to connect using sql authentication with uid and pwd, i get the error;
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

searched a lot about it but couldnt find any solutions. the win2003 server which hosts mssql server has active directory. is this could be the problem? thanks in advance.

amet


edit :
here is my connection string;
"data source=192.168.16.1;initial catalog=SOLAR4;Trusted_Connection=yes;UID=Sql_user ;PWD=123;"

sql_user is dbowner of Solar4 database.
When you use Trusted_Connection=yes, that would mean your LAN/Domain credentials will be used so you don't need to pass UID and PWD. Try not passing it.

-- CK
Apr 3 '08 #2

Post your reply

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

Similar topics

3 posts views Thread by Nicola Marchiori | last post: by
4 posts views Thread by Brett | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.