Win 7 Network Libraries SQL Server Express 2005


  1. doofenshmirtz
    Posts : 13
    win 7
       New #1

    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 Computer
    Quote Quote

  3. Capt.Jack Sparrow
    Posts : 4,772
    Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
       New #2

    Hello !!

    I guess it might be the SQL Server itself the issue.
    "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 Computer
    Quote Quote

 

  Related Discussions
Both of our Win 7 desktop computers (stats for mine are shown, but the other is very similar) came with Microsoft SQL Server 2005 Compact Edition version 3.1.000 installed. The program has never updated via Windows Update, and I don't believe we've ever had any use for it. This morning, however,...
Sql server 2005
in Installation & Setup

When install sql server 2005 work and alomost finished error whit a service.What to do?
Okay this is driving me batty and any help y'all could offer would be most appreciated!! I have an old (2002-era) proprietary program I use for work that ran FINE on 32-bit XP without any special tweaking. It also runs fine on 32-bit W7 on my laptop. I couldn't get it to install normally in...
SQL Server 2005
in Software

Hi all, Is there any person who has installed SQL Server 2005 on Win7. I'm having much trouble with this OS. A lot of compatibilities issues... :cry: Thanks for help
We have a test computer that we are using to test out various software applications. This one in particular uses SQL Express 2005. The test computer is Windows 7 Pro, 32-bit OS - 2 GB RAM - 2.40 GHz processor. Is there any known issues relating to the speed of an insert/read from SQL 2005 with...
Our Sites
Site Links
About 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 11:13.
Find Us