Error: server: msg 18452, level 16, state 1 [microsoft][odbc sql server driver][sql server]login failed for user 'user_name'. Reason: not associated with a trusted sql server connection
Solution: Open Sql Server Enterprise Manager, go to SQL Server Group -> Choose the server -> right-click, Properties -> choose tab Security -> Choose Sql Server and Windows for Authentication, then click OK, and don't forget to restart the service to make sure the new settings work.
Friday, August 21, 2009
You may be intersted in
Related Posts
Updating Table Containing Xml Column via LinkedServer
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...
0 comments:
Post a Comment