SQL Server Request failure Solution

SQL2005 fails to start SQLServer request or the service does not respond in time to disable VIA protocol. Method for disabling the VIA Protocol: Start-Program-MicrosoftSQLServer2005-Configuration tool-SQLServerConfigurationManager-open and find the Protocol attribute on the Right of SQLServer2005 network configuration-MSSQLSERVER

SQL2005 fails to start the SQL Server request or the service does not respond promptly to the disabled VIA protocol issue. Method for disabling the VIA Protocol: Start-Program-Microsoft SQL Server 2005-Configuration tool-SQL Server Configuration Manager-open and find the Protocol attribute on the Right of SQL Server 2005 network Configuration-MSSQLSERVER attribute

SQL2005 failed to start SQL Server Request or service failed to respond in time

Disable the VIA protocol to solve the problem. "VIA protocol" Deactivation method: start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server Configuration Manager-> open and find "SQL Server 2005 network Configuration"-> protocol of MSSQLSERVER attribute on the right in the properties box, disable the "VIA protocol!

Why does the request fail or the service does not respond in time when the SQL server Configuration Manager is started?

Solution:

Disable the VIA protocol to solve the problem. "VIA protocol" Deactivation method: start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server Configuration Manager-> open and find "SQL Server 2005 network Configuration"-> protocol of MSSQLSERVER attribute on the right in the properties box, disable the "VIA protocol!

You can check its log to see if such a similar sentence exists in the middle,

The file "C: Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog. ldf" has been compressed, but does not reside in a read-only database or file group. The file must be decompressed.

If yes, right-click the SQL folder and select "advanced". On the displayed page, click the "compress content to save disk space" option. OK.

Solve the problem that SQL Server does not allow remote connection.

For the database system that has just been installed, if it is installed by default, it is likely that an error is reported during remote connection. The common error is: "When you connect to SQL Server 2005, this failure may occur if SQL Server does not allow remote connection by default. (Provider: named pipeline provider, error: 40-unable to open the connection to SQL Server) ", the problem is summarized as follows:

I understand that SQL Server is a network database and can be easily solved. It is simply divided into the following situations.

◆ 1. The database engine is not started. There are two startup methods:

(1) Start-> Program-> Microsoft SQL Server 2005-> SQL Server 2005 peripheral application configurator. On the displayed page, click "peripheral application configurator for service connection ", on the displayed page, find the Database Engine and click "service". Check whether the service is started on the right side. If not, click "start" and make sure "Start type" is automatic, do not manually start the instance. Otherwise, the instance must be manually started the next time it is started;

(2) You can choose Start> program> Microsoft SQL Server 2005> Configuration tool> SQL Server Configuration Manager, and select SQL Server (MSSQLSERVER) in SQL Server 2005 ), click "Start Service" in the toolbar to change the service status to start;

When using the above two methods, sometimes an error may occur during startup, and cannot be started, in this case, check whether the VIA in SQL Server 2005 network configuration> MSSQLSERVER protocol is enabled in "SQL Server 2005 Configuration Manager". If yes, disable it. then, execute the preceding operation.

◆ 2. whether remote connection is allowed. This part can be simply divided into four aspects, enable remote connection on SQL Server, enable SQL Server browsing service, create exceptions for SQL Server 2005 in Windows Firewall, and create exceptions for "SQLBrowser" in Windows Firewall. The following are some specific operations:

Enable remote connection on an SQLServer instance

◆ 1. Point to "start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server peripheral application configurator"

◆ 2. On the "SQL Server 2005 peripheral application configurator" page, click "service and connected peripheral application configurator"

◆ 3. Click expand "Database Engine", select "remote connection", and select "local connection and remote connection" on the right ",

Select the Protocol to use (TCP/IP and named pipe service should be enabled here !) Click "application" and you will see the following message:

"The changes made to the connection settings will not take effect until the Database Engine service is restarted .", Click OK to return

◆ 4. Expand "Database Engine", select "service", click "stop" on the right side, and wait until the MSSQLSERVER service is stopped,

Click Start to restart the MSSQLSERVER service.

Enable SQLServer Browser Service

◆ 1. Point to "start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server peripheral application configurator"

◆ 2. On the "SQL Server 2005 peripheral application configurator" page, click "service and connected peripheral application configurator"

◆ 3. Click to expand "SQL Server Browser", select "service", and select "automatic" in "Startup Type" on the right ",

Click Start and then click OK to return

Create an exception for "SQL Server 2005" in Windows Firewall

◆ 1. on the Windows Firewall settings page, select the "exceptions" tab and click "add program"

◆ 2. In the "add program window", click "Browse"

◆ 3. Then find "C: ProgramFilesMicrosoft FilesMicrosoft SQL Server MSSQL.1 MSSQLBinnsqlservr.exe ",

Click OK to return

Note: the path may vary depending on SQL Server 2005 installation. MSSQL.1 is a placeholder that corresponds to the database instance ID.

◆ 4. Repeat steps 1 to 3 for each SQL Server 2005 instance that requires remote access.

Create an exception for "SQLBrowser" in Windows Firewall

◆ 1. on the Windows Firewall settings page, select the "exceptions" tab and click "add program"

◆ 2. In the "add program window", click "Browse"

◆ 3. Then find "C: ProgramFilesMicrosoft FilesMicrosoft SQL Server90Sharedsqlbrowser.exe ",

Click OK to return