Problem: Login Failed for user 'sa '. Reason: not associated with a trusted SQL server connection.
You can connect to the database on the local SQL Server, but there is a problem with the connection to the server, the reason is as above. Search for help in Baidu and Google is because the hybrid login mode of SQL Server and windows is not used. In fact, this mode is set on the server, so this is not the reason.
Finally, you can find a solution through Google. It turns out that the sqlserver2000 version on the server is too low. After downloading SP4 on the Microsoft homepage, it will be normal. To view the sqlserver version, enterSelect @ version
The webpage link for help is as follows :):
Http://blog.benday.com/archive/2005/06/16/637.aspx
Google, love you a little more every day ~
Hope your ownArticleIt can also help others solve some problems :)