Installing SQL Server 2005 SP1 fails

Hi,

Trying to install SQL Server 2005 SP1 on a windows 2003 box and it fails for database services and reporting services patch. It installs successfully other components of the patch.
Following errors are logged in the event log.
1) Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINNT\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log

2) Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user birendraa. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
3) Product: Microsoft SQL Server 2005 Reporting Services -- Error 29561. SQL Server Setup failed to retrieve the SSL Certificate Name.
4) Product: Microsoft SQL Server 2005 Reporting Services - Update 'Service Pack 1 for SQL Server Reporting Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINNT\Hotfix\RS9\Logs\RS9_Hotfix_KB913090_sqlrun_rs.msp.log.

The account running SQL server setup has admin privileges on that box.
Kindly help me in this regard.

Thanks.

Birendra

I'll take a shot at these...

1 & 4) These 1603 errors are tough to debug without the logs (and often even with the logs). These may go away after fixing the other two issues. Aaron's blog has a good explanation of them.

http://blogs.msdn.com/astebner/archive/2005/08/01/446328.aspx

2) The problem is that there exists a file in this Data directory that the user running SP1 does not have permissions to modify. The workaround is to figure out which file this is (typically a user created DB or some backup program files) and to temporarily assign permission to that file(s). You can revert back to the intended permissions after running SP1.

3) This one has come up a few times in the forum. Here is a good thread on it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125628&SiteID=1

Thanks,
Sam Lester (MSFT)

Installing SQL Server 2005 fails

I have been trying to install Visual Web Developer 2005 Express Edition and SQL Server 2005. The Web Developer installs ok but the SQL Server installation fails. I can't figure out why. I have (I think...) uninstalled my previous beta intallations. The must be something else that prevents the installation. Can anyone point me to some FAQ or something that can give me some ideas on how to handle the installation.
/andersI would first try a fresh install with no other SQL Sever productsinstalled. Also log the installation and post the log file.
|||

summary.txt looks like this:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Nov 25 22:42:40 2005

P2 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : P2
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\SQLSetup0011_P2_SQLSupport_1.log
------------------------
Machine : P2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_1.log
------------------------
Machine : P2
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SqlWriter_1.log
------------------------
Machine : P2
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_1.log
------------------------
Machine : P2
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\SQLSetup0011_P2_SQLSupport_2.log
------------------------
Machine : P2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_2.log
------------------------
Machine : P2
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_2.log
------------------------
Machine : P2
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 : P2
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 : P2
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_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 : P2
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Tools.log
------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Fri Nov 25 22:47:40 2005

List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Core(Local).log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQL.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Tools.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SCC.log

This is "SQLSetup0011_P2-Core.log":
Microsoft SQL Server 2005 Setup beginning at Fri Nov 25 22:41:49 2005
Process ID : 3500
f:\22644329947aca3bcc8446\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/10/25 22:41:49
Complete: LoadResourcesAction at: 2005/10/25 22:41:49, returned true
...
And then a number of actions that end with "returned true"
...
Running: DetectLocalBootstrapAction at: 2005/10/25 22:42:37
Complete: DetectLocalBootstrapAction at: 2005/10/25 22:42:37, returned true
Running: LaunchLocalBootstrapAction at: 2005/10/25 22:42:37
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 28086
Aborting queue processing as nested installer has completed
Message pump returning: 28086

Something goes wrong, but I'm not able to analyse what.
"SQLSetup0011_P2_Core(Local).log" looks like this:
Microsoft SQL Server 2005 Setup beginning at Fri Nov 25 22:42:40 2005
Process ID : 1424
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/10/25 22:42:40
Complete: LoadResourcesAction at: 2005/10/25 22:42:40, returned true
...
Then there is a number of actions that end with various errors.
...
One or more packages failed to install. Refer to logs for error details. : 28086
Error Code: 0x80076db6 (28086)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

-- Context ---------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0011.cab" Error Code : 2
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 28086

/anders

Installing SQL server 2005 express

Hello,

I have a problem installing SQL express from a CD, it installs fine but the installation wizard does not load automatically, so I have tried to setup manually through Add and Remove programs.

But when I get pass System configuration check menu, i do not get the Registration info menu, it goes straight to SQL server express setup and then to another server express setup menu (it skips 3 menu pages) it should have MSML5 components such as SQL setup files, SQL native client, SQL VSS writer etc but it is completely empty. Then I get the finish screen.

However, when I uninstall SQL express, I see the MSML screen with all the components listed before it uninstalls.

I hope this makes sense and I hope someone can help.

Thanks.

Before you installing SQL Server Express, is your machine is a clean machine? If MSXML6 and SQLWriter are already installed, then they should not be installed again. So you can uninstall call components from Add/Remove Programs and reintall.

Installing SQL 2005 after Visual Studio 2005

WinXP Pro

Installed Visual Studio Team Suite

Installed Team Explorer

Installed SQL 2005 with all the features turned on (so everything installs)

Result: None of the SQL Management Studio tools show up.

I checked ARP and see all the entries for Microsoft SQL Server 2005.

I also checked the Services and see SQL Server (MSSQLSERVER).

I also see SQL Server (SQLEXPRESS) but don't see an ARP entry for it.

Any ideas on how to install the SQL 2005 Studio tools?

Thanks!

1. Have you try the setup.exe under ...\tools\setup.exe?

2. There will be only one entry for all SQL Server 2005 editions/instances. Go to ARP, and open SQL Server 2005 entry, select change, you can see all SQL Server 2005 editions/instances.

|||Thanks. I was able to see the sql express instance and uninstall it.