446 User

Hello
I try to run a page in asp.net (C #) that is connected to a database on a server (LAN), it ran normally, but when I installed the SQL Server service pack 3 the server, I get this error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
i tryed to uninstall Service Pack 3 or Service Pack 4 installed, I checked all the security, everything is correct but does not work, can any body help me plzzzzzzzzzzzz

This is an authentication problem and not a question of the service pack. To resolve this problem, you must understand how SQL Server authenticates users.

SQL Server can authenticate users in one of two ways:
1 - Windows Authentication Mode: Allows a user to connect through a Microsoft Windows user account
2 - Mixed Mode: allows users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication. Users who connect through a Windows NT 4.0 or Windows 2000 user account can use trusted connections in Windows Authentication Mode or Mixed Mode.

You must configure your server to authenticate users in the appropriate method.

To allow SQL Server to authenticate users in mixed mode, go in Enterprise Manager>> Right click on your server>> Properties>> Select the Security tab>> Click on SQL Server and Windows under security / authentication

Hope this helps.

incomplete response in my astonishment, I knowledge.Still how did he write an issue resolved and gave him such a ranking? Flag