Problem installing SQL Server 2005 Express with Advance Services CTP

Hi,

I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message:

TITLE: Microsoft SQL Server 2005 Setup

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.

However, I was able to install and run the standard CTP version of SS Express Edition SP1 without any problems, even though the above error message indicated I may have login problem. First let me confess that my computer does not have IIS installed, which as I understand is only needed for running the Report Services. Is it necessary for IIS to be up and running while installing SSEE with Advance Services?

The main reason I want to install SSEE with Advance Services is to use the full text search capability. I do not need the Report Services, and was hoping there is an option to turn it off and not require IIS. Is this possible?

Mike

Hi Mike,

You do not need to have IIS installed or running to install Express Advanced as long as you don't need Reporting Services. As far as the error you're getting, we'd really need to check for additional informaiton in the setup log. Could you check that out and get back to the thread with the info from the log?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

I am glad to hear that IIS is not required for SQLExpress Advanced installation. The error I got is as follows taken from the summary log file.

Machine : WS2
Product : Microsoft SQL Server 2005
Product Version : 9.1.2040.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_WS2_SQL.log
Last Action : InstallFinalize
Error String : 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.
Error Number : 29515

Background information: (OS: Windows XP SP2)

1. Logged in as user with local administrative priviliges.

2. Installed SQL Express RTM a while back, and was able to login to instance and use databases.

3. Attempted to install SQLExpress Advanced CTP without uninstalling SQLExpress RTM. This process is suppose to upgrade the existing installation.

4. *** Installation fails and the sql server setup installation rolls back. *** The previous installation (SQLExpress RTM) is automatically restored, and I am able to login to the sql server.

5. l then try to install SQLExpress CTP. This works perfectly. Note I did not make any changes between steps 4 and 5 (e.g. no reboot, etc.).

Looking through the log files it looks like the SQLExpress Advanced is trying to make an ODBC connection and failing. Why is it trying to use ODBC?

Anyway there is a lot of information in the logs that I do not understand, so it would be better if I could send them to you. (All the log files are in a 1.3M cab file) Please advise.

Thanks,

Mike

|||I am having the same error message also. I previously installed Visual Studio 2005 (not express). Could this have changed the sa password?|||

Hi, I've got the same problem - any ideas?

TITLE: Microsoft SQL Server 2005 Setup

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.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x4818

BUTTONS:

&Retry
Cancel

|||I have the same error during setup. I was upgrading a named instance of SSEE 2005 to SSEE w/ Advanced Services.

I used Windows Auth for the install; my windows account is a local admin on the server in question (Win2k Server) and my account has the sysadmin role in SQL Server.

I also tried it using SQL Server Auth with the SA account. That immediately showed the message:

"SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade."

So, I find it strange that the setup fails with the message:

"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."
(The Error Number in the log summary is 29515)

It says the login failed for user 'sa' even though I used Windows Authentication.

Btw, I used the download posted here: http://msdn.microsoft.com/vstudio/express/sql/download/ Is that still a CTP?
|||More info from the error log:

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Oct 26 16:37:41 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr

Error Code: 18456
MSI (s) (34!D4) [16:38:57:313]: Product: Microsoft SQL Server 2005 -- Error 29515. 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.

Error 29515. 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.
<Failure Type='Fatal' Error='18456'>
<EndFunc Name='LaunchFunction' Return='18456' GetLastError='203'>
MSI (s) (34:C8) [16:38:57:360]: User policy value 'DisableRollback' is 0
MSI (s) (34:C8) [16:38:57:360]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:57: InstallFinalize. Return value 3.
|||

Seems to be an issue that happens during upgrade.

In order to correctly upgrade from Express Edition to Express Edition with Advanced Services, follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/UpgradeToAdvanced.aspx

If you've already tried to upgrade and received the error "Login failed for user 'sa'" then you will need to follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/580312.aspx

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||Brilliant!
I ran into the same problem yesterday. Will try to use the blog posts to solve my problem. :)

Kaisa
|||The new version of SQLEXP_ADV worked just fine, I was using an earlier version saved on my CD's from Apr, but I just don't understand why these things just get so hard to fine. Great Job!!!! Keep up the hard work....