when i access the database from different DB server getting the following error
Msg 18452, Sev 14, State 1, Line 1 : Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
Thanks,
Ravinder
Your SQL Server is set to Windows Authentication only. You need to logon with a user which has granted access to the server. You can′t provide a userId and passwort in the connecting string because this will be ognored in the case of Windows Auth. only. Another option would be, if feasable for your to switch the authentication mode to mixed.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment