Answered by:
Error Connecting SQL 2005

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 servicesWhen 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
-
You must be selecting default instance when installing SQL Server.
As default instance may be already configured. Try to select another name on the screen when instance has to be selected.
GO To :
http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
and see the 12th image where it suggest how to select instance.
Kind Regards,
Pinal
Pinal Dave
Founder - http://blog.sqlauthority.com
Search SQL Solutions- Proposed as answer by Pinal Dave Thursday, April 23, 2009 4:30 PM
- Marked as answer by Xiao-Min Tan – MSFT Thursday, April 30, 2009 9:56 AM
Thursday, April 23, 2009 4:29 PM
All replies
-
Setup Failed because a new instance has the same name with existing instance, an instance name must be unique. because setup failed u cannot connect to database engine.
Thursday, April 23, 2009 4:21 PM -
You must be selecting default instance when installing SQL Server.
As default instance may be already configured. Try to select another name on the screen when instance has to be selected.
GO To :
http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
and see the 12th image where it suggest how to select instance.
Kind Regards,
Pinal
Pinal Dave
Founder - http://blog.sqlauthority.com
Search SQL Solutions- Proposed as answer by Pinal Dave Thursday, April 23, 2009 4:30 PM
- Marked as answer by Xiao-Min Tan – MSFT Thursday, April 30, 2009 9:56 AM
Thursday, April 23, 2009 4:29 PM