SQL Server 2008 related error grooming (win7 system)

1. A network-related or instance-specific error occurred while establishing a connection to SQL Server. Service not found or inaccessibleservice. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections.

Step1: Start Menu--Find SQL Server Configuration Manager

Step2: Open Configuration Manager,

Step3: Right-click Property

There are a lot of TCP/IP ports, locate, change the IP address for your computer's IP address (or 127.0.0.1) on the TCP port to add 1433, enabled, change to: Yes, and then click Apply, OK.

STEP4: Restart the service.

2.Windows cannot start the SQL Server Service error code on the local computer 126

When you use SQL Server 2008, you may encounter an error prompt:

"Windows cannot start SQL Server on the local computer.

For more information, consult the system event log. If this is a non-Microsoft service, please contact the service vendor and refer to the specific service error code 126 "

Step1: Start Menu--Find SQL Server Configuration Manager

Step2: Open the Configuration Manager-->sql Server network configuration, set via to disabled, then restart the service, and the service can start normally.

3.SQL Server Service Remote procedure call failed to resolve

：

① Generally, before installing vs2012 (vs2013), install SQL Server 2008 first.

If you install vs2012 (vs2013) before installing SQL Server 2008, you may receive an error.

Open the Control Panel--programs and features--and uninstall Microsoft SQL Server Express LocalDB.

Then open SQL Server Configuration Manager and the normal usage will be displayed.

② Upgrade Database

Use a later version of the database, or upgrade SqlServer2008 to SP1 or SP2.

③ Restart Service

。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。 Not to be continued ....... ..................

Blog Desire Blog Source: http://www.cnblogs.com/D-E-S-I-R-E/ This article copyright belongs to the author and the blog Garden altogether, welcome reprint, but must retain this paragraph statement, and gives the original link, thanks cooperation!

SQL Server 2008 related error grooming (win7 system)