HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

SQL Server 2005 database engine login failed error?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
engineerrorsqllogindatabase2005failedserver

Problem

I installed SQL Server 2005 Enterprise Edition on Windows xp.

This account exists in administrators role.But I can't login to SQL Server database engine using Windows authentication method or sql server authentication method and I receive this error message:

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 setttings 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:53).


But im trying to connect to a local instance in my computer. Also i checked SQL SERVER 2005 surface area>> surface area configuration for services and connections >>which shows error >>No sql server 2005 componenets were found on the specified computer. Anyone can give clues on this issue. Do i need to install any components to make this work? I had selected all the options while installing.

please help me on this..
I am attaching the summary log of setup herewtih.


Microsoft SQL Server 2005 9.00.1399.06
============================== OS Version : Microsoft Windows XP
Professional Service Pack 3 (Build 2600) Time : Wed Oct 05
09:49:21 2011 CHANGEME1 : The current system does not meet the
minimum hardware requirements for this SQL Server release. For system
requirements, see Hardware and Software Requirements, in the readme
file or in SQL Server Books Online. Machine : CHANGEME1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06 Install : Successful Log File
: C:\Program Files\Microsoft SQL Server\90\Setup

Bootstrap\LOG\Files\SQLSetup0002_CHANGEME1_SQLSupport_1.log


Machine : CHANGEME1 Product : Microsoft SQL Server
Native Client Product Version : 9.00.1399.06 Install :
Successful Log File : C:\Program Files\Mic

Solution

As per MSDN you can't install SQL Server 2005 Enterprise Edition on Windows XP. It's not supported. It seems that you can install client tools, BOL and some legacy tools, but not the database server engine itself.

So to answer your question: the SQL Server engine has very likely not been installed when you run setup, so neither you can connect to it, nor you can start any SQL Server service.

Context

StackExchange Database Administrators Q#6518, answer score: 3

Revisions (0)

No revisions yet.