[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL Server 2005 Setup could not connect to the database service for server configuration.

Posted on 2010-03-23
19
Medium Priority
?
413 Views
Last Modified: 2012-06-22
Hi,

I am trying to install SQL Express 2005 (SP3 included in MSI). This is a clean install and no previous versions of SQL have ever been installed. The error I am getting is:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

I have tried Windows mode, mixed mode with and without a passsword for the sa account but still the same error.

Please can anyone help - thanks.

Here is the rror log:

2010-03-23 16:00:32.71 Server      Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
      Nov 24 2008 13:01:59
      Copyright (c) 1988-2005 Microsoft Corporation
      Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-03-23 16:00:32.74 Server      (c) 2005 Microsoft Corporation.
2010-03-23 16:00:32.74 Server      All rights reserved.
2010-03-23 16:00:32.74 Server      Server process ID is 32312.
2010-03-23 16:00:32.74 Server      Authentication mode is MIXED.
2010-03-23 16:00:32.74 Server      Logging SQL Server messages in file 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-03-23 16:00:32.75 Server      Registry startup parameters:
2010-03-23 16:00:32.77 Server             -d c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-23 16:00:32.77 Server             -e c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-23 16:00:32.77 Server             -l c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-23 16:00:32.77 Server      Command Line Startup Parameters:
2010-03-23 16:00:32.77 Server             -m SqlSetup
2010-03-23 16:00:32.77 Server             SqlSetup
2010-03-23 16:00:32.77 Server             -Q
2010-03-23 16:00:32.77 Server             -q SQL_Latin1_General_CP1_CI_AS
2010-03-23 16:00:32.77 Server             -T 4022
2010-03-23 16:00:32.77 Server             -T 3659
2010-03-23 16:00:32.77 Server             -T 3610
2010-03-23 16:00:32.77 Server             -T 4010
2010-03-23 16:00:32.79 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-23 16:00:32.79 Server      Detected 8 CPUs. This is an informational message; no user action is required.
2010-03-23 16:00:33.11 Server      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.
2010-03-23 16:00:33.60 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-23 16:00:33.65 spid5s      Warning ******************
2010-03-23 16:00:33.67 spid5s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2010-03-23 16:00:33.73 spid5s      Starting up database 'master'.
2010-03-23 16:00:34.10 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-03-23 16:00:34.31 spid5s      SQL Trace ID 1 was started by login "sa".
2010-03-23 16:00:34.40 spid5s      Starting up database 'mssqlsystemresource'.
2010-03-23 16:00:34.44 spid5s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-03-23 16:00:34.89 spid5s      Password policy update was successful.
2010-03-23 16:00:34.92 spid7s      Starting up database 'model'.
2010-03-23 16:00:34.92 spid5s      Server name is '109-104-81-154\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-03-23 16:00:34.92 spid5s      Starting up database 'msdb'.
2010-03-23 16:00:35.30 Server      A self-generated certificate was successfully loaded for encryption.
2010-03-23 16:00:35.30 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2010-03-23 16:00:35.31 Server      Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2010-03-23 16:00:35.36 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-03-23 16:00:35.71 spid7s      Clearing tempdb database.
2010-03-23 16:00:35.95 spid7s      Starting up database 'tempdb'.
2010-03-23 16:00:36.00 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2010-03-23 16:00:36.14 Logon       Error: 18456, Severity: 14, State: 10.
2010-03-23 16:00:36.14 Logon       Login failed for user 'sa'. [CLIENT: <local machine>]
2010-03-23 16:00:38.80 spid5s      SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2010-03-23 16:00:38.80 spid5s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
0
Comment
Question by:tedporter
19 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28360734
>>  Login failed for user 'sa'.

So you don't have SQL Server installed in your machine right..
If you have partial or incomplete installation, then uninstall it and then provide strong password for sa and try it out once..
0
 

Author Comment

by:tedporter
ID: 28361999
Hi,

I have done as you suggested but still the same issue. I have attached a screen shot of the actual error and the point at which it goes wrong.
SQL-Error.jpg
0
 
LVL 8

Expert Comment

by:Chris Wong
ID: 28362028
what OS? turn on windws firewall?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:tedporter
ID: 28362316
Hi,

Server 2003 Enterprise SP2 64-bit. No firewall.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28362651
Do you have the pre-requisites installed in your machine..
And are you trying to install 32 or 64 version of SQL server 2005..
0
 

Author Comment

by:tedporter
ID: 28363395
Hi,

I have all the pre-requisites installed.

I downloaded the 64-bit installation MSI package.
0
 
LVL 32

Expert Comment

by:Brendt Hess
ID: 28381271
What other applications do you have installed?  Just because you didn't install SQL Server express does not mean that some other application didn't install it first.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28413607
Heard similar issue before with the installation package from someone.
Can you try installing the one in the link below:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en
0
 

Author Comment

by:tedporter
ID: 28430685
Hi,

bhess1: The server is a clean build with nothing but Server 2003 SP2 installed and the .NET Framework versions 2 & 3.5 + SP's.


rrjegan17: Downloaded what you suggested but still same issue. BTW - I did uninstall everything, removed any residule directories and cleaned the registy. Plus rebooted the server before re-installing.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28461807
Is there any pre-existing issues or any configuration issues existing in your server..
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28468496
Have you tried installing Evaluation edition of SQL Server once and find whether you are obtaining the same error or not..
0
 

Author Comment

by:tedporter
ID: 28663830
Hi,

Sorry for the delay in replying but I got the server completly reimaged. Unfortunatlely I am still unable to install SQL 2005. I also tried SQL 2008 and this also failed.

There is obviously something very wrong with the server image. We rent this server and I have no control over the image, so all I can do is ask the ISP to provide a different image and try again.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28758479
Suspect something with the image..
Try installing SQL Server 2005 or 2008 in some other machine installed through some other image or Installation Disk  and check it out once..
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 28758602
0
 

Author Comment

by:tedporter
ID: 28765443
Hi,

I went back to the ISP with reference to the MSDN article you pointed me to and asked the question was it failing because our server is a VPS in a server farm. The ISP then offered to install SQL 2008 Express x64 for us and it now works.

I have asked them for details of what they did, as they said that they had to install it using command line switches. I think it would be nice to put this information in to this log for those that have the same problem. Hopefully, they will pass on that information.
0
 

Author Closing Comment

by:tedporter
ID: 31706128
Thank you for sticking with it. I will update this log if I ever get an answer back from the ISP.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28765981
Welcome.. And I usually try to stay till the question is closed..

If command line installation worked, then this should be the appropriate article for that:

http://msdn.microsoft.com/en-us/library/ms144259%28SQL.90%29.aspx

If you get any additional info from your ISP, then post that here..
0
 

Author Comment

by:tedporter
ID: 28990907
Hi,

Here is how the ISP installed SQL on the VPS

setup.exe /action=Install /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server (x86)" /INSTALLSHAREDDIR="C:\Program Files (x86)\Microsoft SQL Server"
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28992293
Thanks for sharing it out here..
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question