Post reply

Sql Server 2005 doesn't connect for windows xp SP3

  • December 17, 2012 at 8:53 pm

    #271707

    I have installed sql server 2005 in Windows XP SP3. Installed successfully but

    a) server didn't connect gave error message ;

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to localhost.

    ------------------------------

    ADDITIONAL INFORMATION:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    again tried with computer name gave same message.

    b) Service is not listed in the windows service list (should have service name mssqlserver)

    c) Version information Sql Server 2005 :

    Microsoft SQL Server Management Studio 9.00.1399.00

    Microsoft Analysis Services Client Tools2005.090.1399.00

    Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

    Microsoft MSXML 2.6 3.0 5.0 6.0

    Microsoft Internet Explorer 6.0.2900.5512

    Microsoft .NET Framework 2.0.50727.42

    Operating System 5.1.2600

    Can anyone help me to run sql Server 2005 in windows xp sp3?

  • December 19, 2012 at 11:09 pm

    #1570399

    Have you encountered any issues during the installation? try to uninstall and install the application

  • December 19, 2012 at 11:41 pm

    #1570404

    When you say windows service list, are you referring to the Services control panel?

    In the Services Control panel you will want to look for SQL Server as the name and not mssqlserver.

    When you installed SQL Server, did you install as default instance or as a named instance?

    Do you have the SQL Browser running?

    Do you have windows (or any other) firewall running?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 20, 2012 at 7:39 pm

    #1570690

    Thanks.

  • December 20, 2012 at 9:29 pm

    #1570709

    Does that mean it is working now?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 22, 2012 at 8:22 pm

    #1571159

    Thanks It is working now.

  • December 22, 2012 at 8:38 pm

    #1571161

    Mind sharing what you did to get it working?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 26, 2012 at 10:56 pm

    #1571743

    Actually downloaded express edition and installed.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply