none
"Access is denied" error while installing SQL Server developer edition on XP SP2 system/Vista

    Question

  • Hi,

     

    I am facing a typical issue while installing SQL Server 2008 developer edition on OS - XP SP2 Professional edition. It just gives an error "Access is denied" and leaves it there and shows an error saying that the installation incomplete. Database engine services are running. Issue is that I am unable to have database installed on my local system and also the reporting server not getting installed.

     

    I had searched across google, there are many people asking the questions on the same issue but no answers. It would be really great and helpful if someone provides me a solution for the same.

     

    Regards,

    Phani Subnivis

    Tuesday, November 18, 2008 3:12 PM

Answers

  • Hi Richard,

    Though it is a delayed reply, I thought to mention that with the help of microsoft support team, this issue got resolved. It is something to do with providing permissions to the user on specific accounts before installing the product.

    It is very important to delete all the folders that are created by the unsuccessful installation to ensure that the installation goes smooth.

    Below are the details of the issue and the resolution:

    Problem Description:
    =======================================================================

    You were facing issues while installing SQL Server 2008 on your machine.

    The installation proceeded fine, however, during the configuration stage, it failed with the message "System.ComponentModel.Win32Exception: Access is denied"

    The service was registered, and was even started, however, no one was able to connect to it.

     

    Cause:
    =======================================================================

    The domain account chosen as the SQL Server service account was missing some priviledges, hence setup could not proceed further. The Setting Up Windows Service Accounts provides a list of permission that are required to be given to the SQL Server Service Account. Also, Security Considerations for a SQL Server Installation lists all the security considerations that need to taken care of for the SQL Server Service Account.

     

    Resolution:
    =======================================================================

    We followed the following steps to provide the following permissions to the ITLINFOSYS\Phaneendra_subnivis account on the Local Security Policy:

    1.     Go to Start -> Run. Type in secpol.msc and press Enter.

    2.     Now, under Security Settings, expand Local Policies and then click on User Rights Assignment.

    3.     Make sure that the SQL Server Service Account has the following rights:

    a.     Act as part of the operating system

    b.    Allow log on locally

    c.     Bypass traverse checking

    d.    Debug programs

    e.     Log on as a batch job

    f.     Log on as a service

    g.    Replace a process level token

    4.     Now, we need to check the registry. Hence, go to Start -> Run, and type in Regedit and press Enter.

    5.     Now, navigate to HKey_Local_Machine\System\CurrentControlSet\Services\WinHttpAutoProxySvc.

    6.     Right-click on WinHttpAutoProxySvc and choose Permissions.

    7.     Make sure that the SQL Server Service Account has FULL CONTROL over this key.

    8.     Now, restart the machine.

     

    Once we granted the required permissions by following the steps above, SQL Server could be installed successfully.


    Thanks for all your help.

    Regards,
    Phani
    Phani
    Tuesday, March 31, 2009 6:36 AM

All replies

  • Can you post your setup logs from /%program files%/microsoft sql server/100/setup bootstrap/log?

     

    Tuesday, November 18, 2008 6:33 PM
    Moderator
  • Hi,

     

    Thank you for the quick response. Please find the log details attached below. I have picked the content around the problematic part.

     

    Let me know if you need any furter details.

     

    Regards,

    Phani.

     

    2008-11-08 11:17:38 Slp: Sco: Service  stopped in less than 1 seconds
    2008-11-08 11:17:38 SQLEngine: : Checking Engine checkpoint 'ClearAllPools'
    2008-11-08 11:17:38 SQLEngine: --SqlServerServiceSCM: Waiting for SQL Server Process exit
    2008-11-08 11:17:38 SQLEngine: : Checking Engine checkpoint 'WaitForSqlServerProcessExit'
    2008-11-08 11:17:38 SQLEngine: --SqlServerServiceSCM: Starting SQL Server in order to shutdown all RANU instances.
    2008-11-08 11:17:38 SQLEngine: : Checking Engine checkpoint 'StartEngineService'
    2008-11-08 11:17:38 SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup -T4022 -T4010 -T1905)...
    2008-11-08 11:17:38 Slp: Sco: Attempting to start service
    2008-11-08 11:17:38 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:38 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:39 Slp: Sco: Service  started
    2008-11-08 11:17:39 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:39 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:39 Slp: Sco: Attempting to get service process id for service
    2008-11-08 11:17:39 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:39 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:39 Slp: Invoking QueryServiceStatusEx Win32 API
    2008-11-08 11:17:39 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:39 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:39 Slp: Sco: Returning service process id 2588
    2008-11-08 11:17:39 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle_1'
    2008-11-08 11:17:39 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$' to be created
    2008-11-08 11:17:40 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$' or sql process handle to be signaled
    2008-11-08 11:17:40 SQLEngine: --SqlServerServiceSCM: Failed to shutdown all RANU instances. Error: Access is denied
    2008-11-08 11:17:40 SQLEngine: Copying 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' to 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt' ...
    2008-11-08 11:17:40 Slp: Sco: Attempting to set file full path to 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG'
    2008-11-08 11:17:40 Slp: Sco: Attempting to normalize directory path 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG'
    2008-11-08 11:17:40 Slp: Sco: Attempting to check if file 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' exists
    2008-11-08 11:17:40 Slp: Sco: Attempting to copy file 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' to file 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to check if file 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' exists
    2008-11-08 11:17:40 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to set file full path to 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to check if directory path 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' is equal to path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to check if directory path 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' is equal to path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to normalize directory path 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG'
    2008-11-08 11:17:40 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081108_111437\SQLServer_ERRORLOG_2008-11-08T11.17.40.txt'
    2008-11-08 11:17:40 Slp: Sco: Attempting to get security descriptor for file 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG'
    2008-11-08 11:17:40 Slp: Sco: Attempting to check if file 'E:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Log\ERRORLOG' exists
    2008-11-08 11:17:40 Slp: Sco: Returning security descriptor O:NSG:NSD:AI(A;ID;FA;;;NS)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;FA;;;S-1-5-21-1343024091-1606980848-682003330-1047)(A;ID;0x1201ff;;;S-1-5-21-1343024091-1606980848-682003330-1048)
    2008-11-08 11:17:40 SQLEngine: --SqlServerServiceSCM: Stopping SQL Server Service and dependents
    2008-11-08 11:17:40 Slp: Sco: Attempting to get service process id for service
    2008-11-08 11:17:40 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:40 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:40 Slp: Invoking QueryServiceStatusEx Win32 API
    2008-11-08 11:17:40 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:40 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:40 Slp: Sco: Returning service process id 2588
    2008-11-08 11:17:40 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle_2'
    2008-11-08 11:17:40 Slp: Sco: Attempting to stop service with wait , timeout 600, stop dependents True
    2008-11-08 11:17:40 Slp: Sco: Attempting to stop service with wait , timeout 600, stop dependents True
    2008-11-08 11:17:40 Slp: Sco: Attempting to stop service , stop dependents False
    2008-11-08 11:17:40 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:40 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:40 Slp: Invoking ControlService Win32 API
    2008-11-08 11:17:40 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:40 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:40 Slp: Sco: Service  aleady at stop state
    2008-11-08 11:17:40 Slp: Sco: Service  stop request issued... Sleeping 1 second before next status check
    2008-11-08 11:17:41 Slp: Sco: Attempting to get service status for service
    2008-11-08 11:17:41 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:41 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:41 Slp: Invoking QueryServiceStatus Win32 API
    2008-11-08 11:17:41 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:41 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:41 Slp: Sco: Returning service status Stopped
    2008-11-08 11:17:41 Slp: Sco: Service  stopped in less than 1 seconds
    2008-11-08 11:17:41 Slp: Sco: Attempting to stop service , stop dependents False
    2008-11-08 11:17:41 Slp: Sco: Attempting to open SC Manager
    2008-11-08 11:17:41 Slp: Sco: Attempting to open service handle for service
    2008-11-08 11:17:41 Slp: Invoking ControlService Win32 API
    2008-11-08 11:17:41 Slp: Sco: Attempting to close service handle for service
    2008-11-08 11:17:41 Slp: Sco: Attempting to close SC Manager
    2008-11-08 11:17:41 Slp: Sco: Service  stopped

    Wednesday, November 19, 2008 12:25 PM
  • Hi Richard,

     

    I was just wondering if you got chance to look at the log files that I had included in the thread. It would be great if some one could look and advice on this.

     

    Regards,

    Phani Subnivis

     

    Friday, November 21, 2008 2:42 AM
  • Yes, I'm not sure that was the part of the log that had the failure - but is this a machine that has other users logged in at the same time?  Do you have other services running on the machine that might be using SQL Express?

     

    If you email me the full setup log at richard.waymire @  microsoft.com I can take a look at the log files.

     

    Friday, November 21, 2008 9:38 PM
    Moderator
  • Hi Richard,

    Though it is a delayed reply, I thought to mention that with the help of microsoft support team, this issue got resolved. It is something to do with providing permissions to the user on specific accounts before installing the product.

    It is very important to delete all the folders that are created by the unsuccessful installation to ensure that the installation goes smooth.

    Below are the details of the issue and the resolution:

    Problem Description:
    =======================================================================

    You were facing issues while installing SQL Server 2008 on your machine.

    The installation proceeded fine, however, during the configuration stage, it failed with the message "System.ComponentModel.Win32Exception: Access is denied"

    The service was registered, and was even started, however, no one was able to connect to it.

     

    Cause:
    =======================================================================

    The domain account chosen as the SQL Server service account was missing some priviledges, hence setup could not proceed further. The Setting Up Windows Service Accounts provides a list of permission that are required to be given to the SQL Server Service Account. Also, Security Considerations for a SQL Server Installation lists all the security considerations that need to taken care of for the SQL Server Service Account.

     

    Resolution:
    =======================================================================

    We followed the following steps to provide the following permissions to the ITLINFOSYS\Phaneendra_subnivis account on the Local Security Policy:

    1.     Go to Start -> Run. Type in secpol.msc and press Enter.

    2.     Now, under Security Settings, expand Local Policies and then click on User Rights Assignment.

    3.     Make sure that the SQL Server Service Account has the following rights:

    a.     Act as part of the operating system

    b.    Allow log on locally

    c.     Bypass traverse checking

    d.    Debug programs

    e.     Log on as a batch job

    f.     Log on as a service

    g.    Replace a process level token

    4.     Now, we need to check the registry. Hence, go to Start -> Run, and type in Regedit and press Enter.

    5.     Now, navigate to HKey_Local_Machine\System\CurrentControlSet\Services\WinHttpAutoProxySvc.

    6.     Right-click on WinHttpAutoProxySvc and choose Permissions.

    7.     Make sure that the SQL Server Service Account has FULL CONTROL over this key.

    8.     Now, restart the machine.

     

    Once we granted the required permissions by following the steps above, SQL Server could be installed successfully.


    Thanks for all your help.

    Regards,
    Phani
    Phani
    Tuesday, March 31, 2009 6:36 AM