Shulou(Shulou.com)05/31 Report--

Editor to share with you the solution to the failure of sql connection to the server, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

What if sql fails to connect to the server?

For the following reasons:

1. The database engine did not start

There are two ways to start:

(1) start-> Program-> Microsoft SQL Server 2008-> SQL Server 2008 Peripheral Application Configurator, click "Service connected Peripheral Application Configurator" in the open interface, find Database Engine in the open interface, click "Service", check whether it has been started on the right, click "start" if not, and make sure that the Startup Type is automatic, not manual, otherwise you will start it manually next time you boot.

(2) Open: start-> programs-> Microsoft SQL Server 2008-> configuration tools-> SQL Server Configuration Manager, select SQL Server (MSSQLSERVER) in the SQL Server 2008 service, and click the "start Service" button in the toolbar to change the service status to start.

When using the above two methods, sometimes there may be an error [/ b] at startup and cannot be started. At this time, it is necessary to check the SQL Server 2008 network configuration in the SQL Server 2008 configuration Manager-> whether VIA in the MSSQLSERVER protocol is enabled, and if so, disable it. Then perform one of the above operations on it.

two。 Whether a remote connection is allowed when making a remote connection.

SQL Server 2008 is limited to local connections by default. We can manually enable remote connections. In the first method above, find Database Engine, click remote connection, change "Local connection only (L)" to "Local connection and remote connection (R)" on the right, and select "use both TCP/IP and named pipes (B)".

3. If it is a remote connection, also check whether the statement to connect to the database is correct, the login account is correct, the password is correct, and so on.

When I connect to the database in the local area network, because there is something wrong with the connection string, when one machine in the local area network connects to the database on another machine, the Data Source= is installed with the IP of the other machine in the database. I always have the above error when connecting to the database, checked for a long time, and later found that the IP is not correct to pass to the connection string, the original connection, I used the local, that is, 127.0.0.1, the input IP did not pass to the connection string.

The above is all the contents of this article entitled "the solution to the failure of sql connecting to the server". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.