Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Win 7 Network Libraries SQL Server Express 2005


11 May 2010   #1

win 7
 
 
Win 7 Network Libraries SQL Server Express 2005

Hi all,

Mod from SQLTeam.com/forum suggests that I am unable to start SQL Server Express 2005 due to problem with Win 7 Network Libraries SQL Server Forums - SQL Server 2005 Express Login

Here is the output of the event log from the last time I tried to start SQL Server

Thanks
-winston

Level Date and Time Source Event ID Task Category
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17663 (2) Server name is 'GOSSLAPTOPFX\SQLEXPRESS'. This is an informational message only. No user action is required.
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17120 (2) SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17826 (2) Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17182 (2) TDSSNIClient initialization failed with error 0x5, status code 0x1.
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17182 (2) TDSSNIClient initialization failed with error 0x5, status code 0x51.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17137 (2) Starting up database 'model'.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 3404 (2) Failed to check for new installation or a renamed server at startup. The logic for this check has failed unexpectedly. Run setup again, or fix the problematic registry key.
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 15466 (2) An error occurred during decryption.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 958 (2) The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17137 (2) Starting up database 'mssqlsystemresource'.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 19030 (2) "SQL Trace ID 1 was started by login ""sa""."
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17137 (2) Starting up database 'master'.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 1485 (2) Database mirroring has been enabled on this instance of SQL Server.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17125 (2) Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17164 (2) Detected 2 CPUs. This is an informational message; no user action is required.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17162 (2) SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17110 (2) Registry startup parameters:
Error 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17053 (2) UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17111 (2) Logging SQL Server messages in file 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 15268 (2) Authentication mode is MIXED.
Information 5/11/2010 3:30:33 PM MSSQL$SQLEXPRESS 17104 (2) Server process ID is 4536.

My System SpecsSystem Spec
.

11 May 2010   #2

Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
 
 

Hello !!

I guess it might be the SQL Server itself the issue.
Quote:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections"
By some reason the SQL is not allowing remote connection which SQL Protocols are responsible. Make sure TCP/IP, Named Pipes and VIA Protocols are enabled.

Start | Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager

There expand SQL Server 2005 Network Configuration highlight on Protocols for <instance name> and on right side Panel you can find them right click on it and enable it. Then try to start the Service.

If that didn't work change the Build-in account to "Network Service"

Start | Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager

There Highlight on SQL Server 2005 Service there find your instance right click on it then go to Properties then under Build-in account if it's "Local System" change it to "Network Service" then Start the service and see if that works.

Also Disable your Firewall / Antivirus because it vey common that it used to block SQL files.

If you know how to add expections then make sure you add

SQL TCP Port: 1433
SQL UDP Port: 1434

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn and add sqlservr.exe

and

C:\Program Files\Microsoft SQL Server\90\Shared and add sqlbrowser.exe

Hope this helps,
Captain
My System SpecsSystem Spec
Reply

 Win 7 Network Libraries SQL Server Express 2005




Thread Tools



Similar help and support threads for2: Win 7 Network Libraries SQL Server Express 2005
Thread Forum
installing sql server 2005 Software
SQL server 2005 and Windows 7 Software
Sql server 2005 Installation & Setup
Sql server express 2005 Software
SQL Server 2005 Software
Help with guides for Visual C# 2005 Express Edition . . Software
Windows 7 with SQL Express 2005 Software

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 05:34 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33