Many new users will encounter this problem when installing the sqlserver database. The database is already installed, but the connection fails. the pop-up dialog box is displayed: network-related or instance-specific errors occur when you establish a connection with SQLServer. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQLS
Many new users will encounter this problem when installing the SQL server database. The database is already installed, but the connection fails. A dialog box is displayed: network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL S
Many new users will encounter this problem when installing the SQL server database. The database is already installed, but the connection fails. A dialog box is displayed: network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL Server is configured to allow remote connection. (Provider: named pipeline provider, error: 40-unable to open the connection to SQL Server );
Previously, I re-installed it once. I think it was because the database was not installed yet, and a component or configuration error at a certain step was missing. It was always successful to install it twice. But today I am determined to solve this problem. Baidu finally found the solution.
1. Check your configuration file: Start-> SQL server 2008-> Configuration tool-> SQL Server Configuration Manager: Find the SQL Server service and see if this is Enabled: SQL server Express. If this item is disabled, right-click it and start it.
2. log on to the SQL server again. Some students, after the database is installed, the default login server is directed to another computer. For example, in our school's data center, the default address is the teacher's server. So, here, change the address. Change the server name to your computer name. Generally, your computer name is too long to be remembered, so you can use ". or directly write the local IP address 127.0.0.1 (this is the local loopback address, and everyone who has learned about the computer network knows ).
The average student has basically solved this problem. However, my computer is not over yet. Next, see:
3. Click MSSQLSERVER protocol and select TCP/IP protocol on the right-side page.
Right-click and select properties. The configuration from ip1 to ip10 appears. Here, we need to change the ip address and port number of the server.
Change the IP address of ip3 to 127.0.0.1 or your public IP address. Port: 1433. This is the port number in the SQL general administration. Change the port number of ip all to 1433, and save it.
Restart service: Do not restart your SQL server Client. Instead, start the service:
Right-click to restart.
If you log on again, you should have no problem.