Search
Active

1
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Type: Bug
ID: 508747
Opened: 11/6/2009 6:24:35 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Hello,

When I try to run the Setup for SQL 2008 R2 Aug CTP it takes me to the SQL Server Installation Center. I then select the "Installation" page and click the "New SQL Server stand-alone installation or add features to an existing installation" link, I get an error saying I need to reboot. After rebooting and trying again, it still gives me the same error.

I search Microsoft Connect and found the following previously closed bug at:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=484307

that said to go to:

http://blogs.msdn.com/petersad/archive/2009/08/03/sql-server-2008-continually-asking-you-to-reboot-even-after-you-just-rebooted.aspx

This said to add the following command line to the Setup:

    /SKIPRULES=RebootRequiredCheck

When I try to do that, it opens the SQL Server Installation Center as before, and when I click the same link, it still gives me the error.

Thanks
Details (expand)
Product Language
English

Version

SQL Server 2008 R2 August CTP

Category

Setup

Operating System

Windows XP Professional
Operating System Language
US English
Steps to Reproduce
1. Reboot computer where installation is to be done
2. Unzip the en_sql_server_2008_r2_enterprise_eval_august_ctp_x86_408153.exe file to c:\download
3. Unpack this into c:\download\SQL2008R2
4. From a command line, run "c:\download\setup.exe /SKIPRULES=RebootRequiredCheck
5. Select the "Installation" page
6. Click the "New SQL Server stand-alone installation or add features to an existing installation" link
Actual Results
During the Setup Support Rules step, it passes on:

Minimum operating system version
Setup administrator
Windows Management Instrumentation (WMI) service
Consistency validation for SQL Server registry keys
Long path names to files on SQL Server installation media

and fails on:

Restart Computer
Expected Results
It should not fail on the "Restart Computer" check.
Platform
32
File Attachments
1 attachments
20091106_105901.zip
Sign in to post a comment.
Posted by Coop_98 on 11/6/2009 at 8:06 AM
This is my command that I ran:

C:\Download\SQL2008R2Try2>Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQL2008R2 /SQLSVCACCOUNT="<domain\user>" /SQLSVCPASSWORD="<password>" /SQLSYSADMINACCOUNTS="<domain\user>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SKIPRULES=RebootRequiredCheck /IACCEPTSQLSERVERLICENSETERMS=TRUE

and it gives me the following:

Microsoft (R) SQL Server 2008 R2 Setup 10.50.1092.20
Copyright (c) Microsoft Corporation. All rights reserved.

One or more affected files have operations pending.
You should restart your computer to complete this process.

Thanks
Posted by Microsoft on 11/13/2009 at 4:27 PM
The command line installation should have worked. Could you attach the setup logs from %programfiles%\microsoft sql server\100\setup bootstrap\log folder?

Thanks,
Max Verun
SQL Server
Posted by Coop_98 on 11/16/2009 at 5:50 AM
What file(s) would you like. The subfolder for the most recent attempt (called 20091106_105901) has 291 files with 19.9 MB of data.

Thanks
Posted by Microsoft on 11/18/2009 at 11:44 AM
We need the entire sub-folder compressed and attached to this issue.

Thanks,
Max
Posted by Coop_98 on 11/19/2009 at 5:30 AM
Done. Thanks!
Posted by Microsoft on 11/19/2009 at 6:33 PM
Upon checking the log files, this is expected and by design. Here is what we found.

Before the (last) install on the machine these were already present :

Product             Instance             Instance ID                    Feature                                 Language             Edition             Version         Clustered
Sql Server 2005     SQLEXPRESS         MSSQL.1                        Database Engine Services                 1033                 Express Edition     9.2.3310        No        
Sql Server 2005     SQLEXPRESS         MSSQL.1                        SQL Server Replication                 1033                 Express Edition     9.2.3310        No        
Sql Server 2005     SQLEXPRESS         MSSQL.1                        SharedTools                             1033                 Express Edition     9.2.3310        No        
Sql Server 2005                                                         Tools                                    1033                 Express Edition     9.2.3310        No        
Sql Server 2005                                                         ToolsClient                             1033                 Express Edition     9.2.3310        No        
Sql Server 2005                                                         ToolsClient\Connectivity                 1033                 Express Edition     9.2.3310        No        
Sql Server 2008     SQL2008             MSSQL10.SQL2008                Database Engine Services                 1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008     SQL2008             MSSQL10.SQL2008                SQL Server Replication                 1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008     SQL2008             MSAS10.SQL2008                 Analysis Services                        1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008     SQL2008             MSRS10.SQL2008                 Reporting Services                     1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Management Tools - Basic                 1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Management Tools - Complete             1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Client Tools Connectivity                1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Client Tools Backwards Compatibility     1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Client Tools SDK                         1033                 Standard Edition     10.0.1600.22    No        
Sql Server 2008                                                         Integration Services                     1033                 Standard Edition     10.0.1600.22    No        


The install done by you using the skiprule parameter correctly skipped the reboot required rule as below :

2009-11-06 10:59:15 Slp: Initializing rule     : Restart computer
2009-11-06 10:59:15 Slp: Rule applied features : ALL
2009-11-06 10:59:15 Slp: Rule is not applicable to the specified features.
2009-11-06 10:59:15 Slp: Rule is will be executed : False
2009-11-06 10:59:15 Slp: Rule evaluation done : Skipped


During the install a reboot required was generated and reported in the end due to a file in use:


[11:00:49:453]: 1 application(s) had been reported to have files in use.
Info 1603. The file C:\Program Files\Microsoft SQL Server\100\COM\Resources\1033\AXSCPHST.RLL is being held in use by the following process: Name: SQLAGENT, Id: 2952, Window Title: '(not determined yet)'. Close that application and retry.
MSI (c) (74:C4) [11:00:49:453]: File In Use: -SQLAGENT- Window could not be found. Process ID: 2952


So the message is correct:

One or more affected files have operations pending.
You should restart your computer to complete this process.


With this, we are resolving this issue as "by design".

Thanks,
Max Verun
SQL Server
Posted by Coop_98 on 11/20/2009 at 5:37 AM
I am opening this ticket back up. The resolution of "by design" is not correct.

Please read the last sentence of my first paragraph. It states:

"...After rebooting and trying again, it still gives me the same error."

I've even rebooted three times in a row before trying to re-install.

I do have an R1 installation on this machine, but I'm trying to get R2 installed as a new instance.

Thanks,

Marcus

© 2009 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement