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

[tleper]

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.

[ck9663]

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