locked
Error Connecting SQL 2005 RRS feed

  • Question

  • I installed SQL Server 2005 on my Windows Xp mechine.During the installation of some components of SQL 2005  i got some errors.


    Machine         : USER-F26A737E73
    Product         : SQL Server Database Services
    Error           : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
    --------------------------------------------------------------------------------
    Machine         : USER-F26A737E73
    Product         : Microsoft SQL Server 2005
    Product Version : 9.00.1399.06
    Install         : Failed
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_USER-F26A737E73_SQL.log
    Last Action     : DetectInstanceClash
    Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
    Error Number    : 28086
    --------------------------------------------------------------------------------
    Machine         : USER-F26A737E73
    Product         : Analysis Services
    Error           : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
    --------------------------------------------------------------------------------
    Machine         : USER-F26A737E73
    Product         : Microsoft SQL Server 2005 Analysis Services
    Product Version : 9.00.1399.06
    Install         : Failed
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_USER-F26A737E73_AS.log
    Last Action     : DetectInstanceClash
    Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
    Error Number    : 28086
    --------------------------------------------------------------------------------
       AND
    SQL Server Management Studio shows following Registered Servers  :
    Database Engine
    Analysis Services
    Reporting Sevices
    SQL Server Mobile
    Integration services

    When i try to connect above servers error msg  saying :

    "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)"

     

    Thursday, April 23, 2009 4:04 PM

Answers

All replies