SQL Server Related issues

Solution Solutions

User ' sa ' login failed. The user is not associated with a trusted SQL Server connection

issue One, forgot login password for the SA that logged on to Microsoft SQL Server 2005

Workaround: log in with Windows Authentication first, then ' security '-' login '-right-click ' sa '-' Properties ', Change password (sa password can not be too simple, it is best to have numbers, letters, underscore characters, and the length is preferably greater than 10 characters); Click OK.

problem two, the connection to the server has been successfully established, but a mistake occurred during the logon process. (Provider: Shared Memory provider, no process on the other end of the error:0-pipeline.) ) (Microsoft SQL Server, error: 233)

Workaround: open ' programs '-' All Programs '-' Microsoft SQL Server 2005 '-' Configuration Tools '-' SQL Server Configuration Manager ', in the popup form, locate ' SQL Server 2005 Network configuration ', put ' MSSQLServer the protocol ' Named Pipes ' and ' TCP/IP ' start, and then restart Microsoft SQL Server 2005.

problem three, unable to open user default database. Login failed. User ' sa ' login failed. (Microsoft SQL Server, error: 4064)

Workaround: first log in with Windows Authentication, then in ' security '-' login '-right-click ' sa '-' properties ', set the default database to master, click OK.

issue four,SQL Server 2005 Error 18452

Unable to connect to server

Server: Msg 18452, Level 16, State 1

[Microsoft] [ODBC SQL Server Driver] [SQL Server] user ' sa ' failed to log on. Cause: not associated with a trusted SQL Server connection

This error occurs because SQL Server uses Windows-only authentication so that users cannot connect using SQL Server's login account (for example, SA), as follows

Set Allow SQL Server login (basically this is useful)

Operation Steps:

1. In Enterprise Manager, expand SQL Server Group, right-click the name of your SQL Server server

2. Select "Properties"

3. Then select the Security tab

4. Under Authentication, select SQL Server and Windows

5. OK, and restart the SQL Server service

issue five, user ' sa ' login failed. The user is not associated with a trusted SQL Server connection.

Workaround: Check the authentication mode of your database, Windows and mixed mode, please select mixed mode for SA login.

Check the computer 1433 connection port, 1434 data port is open

For SQL 2005 Access Manager "Security" = = "user" = = "Double-click User (Pop-up properties dialog) = =" status "change state to enable, exit Manager re-login (user authentication mode)

That is: Right-click the Database Properties dialog box, select the Security tab, Server Authentication mode select SQL Server and Windows Authentication mode. Then reconfigure the sa login information.

SQL Server 2005 failed to log on using SA-indicates that the user is not associated with a trusted SQL Server connection

Error message:

SA login failed, prompting the user to connect to a trusted SQL Server connection is not associated

Workaround:

Open SQL Server Management Studio Express,

Right click on the server, select Properties, click Security in the Pop-up window to switch to the security panel,

Authenticating server authentication servers from Windows Authentication mode (Windows user authentication mode)

Modify the SQL Server and Windows Authentication mode (SQL Server and Windows Authentication modes), OK.

Open Security (security)--logins (login), right-click the SA, select Properties, tap Status to switch to the status panel and set login (login) to Enabled.

Remember: Be sure to restart the SQL2005 service before it takes effect.