Problem description:
When you log on to MSSQLServer, if you enter an IP address and cannot log on to the database, you can follow the steps below to log on to the database using the IP address after the settings are complete.
Step 1:
Step 2:
Step 3:
Step 4:
Step 5:
Solve the problem that the IP address cannot be connected when MSSQLServer connects to the server.
Problem description: [sqlexception (0x80131904): A connection has been established with the server, but an error occurs during logon. (Provider: Shared MemoryProgramError: 0-No process exists on the other end of the MPs queue.)] [A connection has been established with the server but error 233 is sent during logon]
Solution:
First, select the server (right-click)> Properties> Security> Server Authentication To "SQL Server and Windows Authentication mode"
Next, expand "security"-> login name-> select the sa Login Account (right-click)-> Status-> login to enable
Third, enable SQL Server Configuration Manager. In "MSSQLServer protocol", set "TCP/IP" to "enabled ",
Then restart the MSSQLServer service to complete the settings.