Traditional Culture Encyclopedia - Hotel franchise - There is an error in the hotel system. SQLSTATE0800 1 What's wrong?

There is an error in the hotel system. SQLSTATE0800 1 What's wrong?

This should be because your SQL Server 2005 is not enabled for remote connection. Please refer to the following methods to enable remote connection.

First, enable remote connection for SQL Server 2005.

1. Click Start, select Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Application Configurator.

2. On the SQL Server Surface Area Configurator page, click Surface Area Configurator for Services and Connections.

3. On the Surface Area Configurator for Services and Connections page, expand Database Engine.

Click Remote Connection, select the local connection and remote connection check boxes, select the appropriate protocol for your environment (I use TCP/IP here), and then click Apply.

Note: Click OK when you receive the following message.

Changes to connection settings will not take effect until the database engine service is restarted.

Second, enable the SQL Server browser service.

1. Click Start, select Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Application Configurator.

2. On the SQL Server Surface Area Configurator page, click Surface Area Configurator for Services and Connections.

3. On the Surface Area Configurator for Services and Connections page, click SQL Server Browser, click Automatic in Startup Type, and then click Apply.

4. Click Start, and then click OK.

I hope it works for you.