Web Development

Ask something
Discussion Locked

SQL Server connection

0 helpful
2 replies

by charansree

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am trying to connect to the sqlserver, i'm working on windows2000, i created a dsn and i've chosen SQL server authentication,
now when i try to connect to the SQLServer im receiving this error,

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

please help me as soon as possible,

thanks,
charan

2 replies

by matherg

You will have to enter in the correct SQL user credentials to access whatever database on the SQL Server that you are trying to connect to. The error message you are receiving is basically telling you that you do not have rights to login to that particular DB.

by sriram_hoysala

hi!
which version of the sql server r u using?if u use sql 7 u will have a default username to be given while opening the sql server. give that username in the connection parameter.also check while giving the system dsn have you specified the authentication type to use sql server user and password.

hope this should solve ur problem

This discussion is closed to new replies.