How to connect SQL Server to Server error 233? sql233
I have been using SQL Server2005 normally, but I encountered an error yesterday ,.
After going online, I tried many methods on the Internet and did not solve this problem. After several explorations, I finally got it done. The answer is simple. It is a question about the logon password of the "sa" account for SQL authentication.
But the premise is that you must ensure that your SQL server's SQL identity authentication can be used, so here we will show you how to enable SQL authentication (skip this step if SQL server authentication can be used ).
First, use windows authentication to log on. If windows authentication is not allowed to log on, see setting in "solve SQL Server connection Server Error 2" in my previous blog. I will not talk about it here.
Right-click on the server and choose Properties to go to the properties page. Set Server Authentication in security.
Next, right-click "sa" under the login name under security and set the password.
Here we can use SQL authentication.
After SQL authentication is available, we can reset the "sa" password so that your SQL server's SQL identity can be used. The answer is this simple: reset the password.
SQL server 2008 login error 233 kneeling solution all tried, or not,
Open 'program '-'All projects'-'Microsoft SQL Server 123456'-'configuration tool'-' SQL Server Configuration Manager'. In the displayed form, find 'SQL Server 2008 network configuration', start "Named Pipes" and "TCP/IP" under the 'mssqlserver Protocol', and then restart Microsoft SQL Server 2008.
SQL server 2008 error 233 how to solve
I. Error 233
1. Open "Microsoft SQL Server 2008 -- Configuration tool -- SQL Server Configuration Manager"
2. "SQL Server 2008 network configuration" -- "MSSQLSERVER protocol" -- enable "TCP/IP" and "Named Pipes ". after starting the TCP/IP protocol, you must change the TCP port number in its properties to 1433 (dynamic port) or the desired port number.
3. Restart "SQL Server"
After installing Microsoft SQL Server 2008 yesterday, we found that when connecting to the Server from Microsoft SQL Server Management Studio, if the Server name is not the machine name, but the IP address, the connection always prompts "failed", as shown in:
Solution: Open 'project'-'All projects'-'Microsoft SQL Server 100'-'configuration tool'-'SQL Server Configuration Manager'. In the displayed form, find 'SQL Server 2008 network configuration', start "Named Pipes" and "TCP/IP" under the 'mssqlserver Protocol', and then restart Microsoft SQL Server 2008.
Other error code reference