Re: New install, Small Business Server 2003

Take a look at this KB:
http://support.microsoft.com/kb/925744

--
Ekrem Önsoy



"Matt Fuerst" <fuerstma@xxxxxxxxx> wrote in message news:05397392-6a4e-4e55-b597-63a708c21953@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Greetings all,

I am attempting to get SQL Server 2005 Express running on a freshly
installed Windows Server 2003 Small Business Server machine.

I wiped this machine and installed 2003 Small Business Server. After
installing the .NET 2.0 Framework I uninstalled most of the 2003 SBS
programs and servers. We really only need this machine as a Web Server
for a handful of sites that use an SQL Server back end.

I have since tried to install 2005 Express (Service Pack 2) about a
dozen times. No matter what I do the errors are the same. During the
"Configuring Database Services" stage of the install I get an error
complaining:

SQL Server failed during server configuration. Login failed, user
'sa'.

The entire ERRORLOG of my latest installation is as follows:

2008-08-19 16:27:32.50 Server Microsoft SQL Server 2005 -
9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2008-08-19 16:27:32.61 Server (c) 2005 Microsoft Corporation.
2008-08-19 16:27:32.61 Server All rights reserved.
2008-08-19 16:27:32.61 Server Server process ID is 1724.
2008-08-19 16:27:32.62 Server Authentication mode is MIXED.
2008-08-19 16:27:32.62 Server Logging SQL Server messages in file
'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2008-08-19 16:27:32.64 Server Registry startup parameters:
2008-08-19 16:27:32.65 Server -d c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2008-08-19 16:27:32.65 Server -e c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2008-08-19 16:27:32.65 Server -l c:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2008-08-19 16:27:32.65 Server Command Line Startup Parameters:
2008-08-19 16:27:32.65 Server -m SqlSetup
2008-08-19 16:27:32.65 Server SqlSetup
2008-08-19 16:27:32.65 Server -Q
2008-08-19 16:27:32.65 Server -q SQL_Latin1_General_CP1_CI_AS
2008-08-19 16:27:32.65 Server -T 4022
2008-08-19 16:27:32.65 Server -T 3659
2008-08-19 16:27:32.65 Server -T 3610
2008-08-19 16:27:32.65 Server -T 4010
2008-08-19 16:27:32.68 Server SQL Server is starting at normal
priority base (=7). This is an informational message only. No user
action is required.
2008-08-19 16:27:32.68 Server Detected 2 CPUs. This is an
informational message; no user action is required.
2008-08-19 16:27:33.50 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.
2008-08-19 16:27:34.28 Server Database Mirroring Transport is
disabled in the endpoint configuration.
2008-08-19 16:27:34.32 spid5s Warning ******************
2008-08-19 16:27:34.32 spid5s SQL Server started in single-user
mode. This an informational message only. No user action is required.
2008-08-19 16:27:34.46 spid5s Starting up database 'master'.
2008-08-19 16:27:34.92 spid5s Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user
action is required.
2008-08-19 16:27:35.39 spid5s SQL Trace ID 1 was started by login
"sa".
2008-08-19 16:27:35.48 spid5s Starting up database
'mssqlsystemresource'.
2008-08-19 16:27:35.51 spid5s The resource database build version
is 9.00.3042. This is an informational message only. No user action is
required.
2008-08-19 16:27:37.29 spid5s Password policy update was
successful.
2008-08-19 16:27:37.35 spid7s Starting up database 'model'.
2008-08-19 16:27:37.54 spid5s Server name is 'WEBSRVR
\SQLEXPRESS'. This is an informational message only. No user action is
required.
2008-08-19 16:27:37.54 spid5s Starting up database 'msdb'.
2008-08-19 16:27:38.06 Server A self-generated certificate was
successfully loaded for encryption.
2008-08-19 16:27:38.07 Server Server local connection provider is
ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2008-08-19 16:27:38.07 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.
2008-08-19 16:27:38.14 Server SQL Server is now ready for client
connections. This is an informational message; no user action is
required.
2008-08-19 16:27:38.20 spid7s Clearing tempdb database.
2008-08-19 16:27:41.59 spid7s Starting up database 'tempdb'.
2008-08-19 16:27:41.90 spid5s Recovery is complete. This is an
informational message only. No user action is required.
2008-08-19 16:27:42.35 Logon Error: 18456, Severity: 14, State:
10.
2008-08-19 16:27:42.35 Logon Login failed for user 'sa'.
[CLIENT: <local machine>]
2008-08-19 16:41:01.45 Logon Error: 18456, Severity: 14, State:
10.
2008-08-19 16:41:01.45 Logon Login failed for user 'sa'.
[CLIENT: <local machine>]
2008-08-19 16:41:03.56 Logon Error: 18456, Severity: 14, State:
10.
2008-08-19 16:41:03.56 Logon Login failed for user 'sa'.
[CLIENT: <local machine>]
2008-08-19 16:41:05.71 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.
2008-08-19 16:41:05.71 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no
user action is required.

I get this same error telling the installer application to allow only
Windows Authentication or Mixed Mode Authentication.

I don't know if there are any vestigial left overs from the SharePoint
install (that I believe was using MSDE?). There is nothing SharePoint
or MSDE related in Add/Remove programs.

After failing, I have been removing all SQL Server references via Add/
Remove Programs. I have been going into the registry and removing the
SQL Server entries under HKLM\Software\Microsoft. I have cleared out
the contents of \Program Files\Microsoft SQL Server\.

I can do anything on this machine including re-installing SBS 2003 if
necessary.

Recommendations?

Thanks so much!

Matt

.

Relevant Pages

  • Re: Starting SQL Server Resource Group failed
    ... It looks like the Cluster Service cannot connect to the SQL Service to determine whether it is responsive or not. ... MS has not documented a process to fix this without uninstalling and reinstalling SQL Server. ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.clustering)
  • New install, Small Business Server 2003
    ... I am attempting to get SQL Server 2005 Express running on a freshly ... "Configuring Database Services" stage of the install I get an error ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • Re: New install, Small Business Server 2003
    ... I am attempting to get SQL Server 2005 Express running on a freshly ... "Configuring Database Services" stage of the install I get an error ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... Now I removed the account from local Administrators group. ... The SQL Server Log File reports an error 15209, ... Note that I use a specific account named SQLServerServices to install ... This is an informational message only. ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005 Logon Issues
    ... an ASP.NET 2.0 application to connect to a SQL Server 2005 database... ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ... This is an informational message only; no user action is required. ...
    (microsoft.public.dotnet.framework.aspnet)