Reporting Services Sql Server 2008 installation fails due to a service starting failure

Sun, 26 Apr 2009 15:44:28 Z

I installed Sql Server 2008 Express with Advanced Service Italian Language, but I didn't install Reporting Services.

Afterwards I installed Reporting Services too but during the installation I received the message that you can see here http://img140.imageshack.us/img140/7519/erroresqlserver2008inst.png . It's in Italian language and means "Service didn't start in the requested time", then I clicked on the "?" button on the bottom left and this window was shown http://img22.imageshack.us/img22/7519/erroresqlserver2008inst.png.

My operating system is Windows XP Professional ITA SP3.

I tried to uninstall Sql Server 2008 and reinstalled it adn Reporting Services but unsuccesfully.

Reporting Services Sql Server 2008 installation fails due to a service starting failure

Tue, 28 Apr 2009 03:55:12 Z

Hi fradelpo,

From the log you provided, we find out the exception 0x5D9A8C61.

As we research, the exception means that access is denied. It is a call failure to the OpenProcess function.

We can see from the following link that this function needs the SedebugPrivilege privilege to be enabled for the user.

http://msdn.microsoft.com/en-us/library/ms684320(VS.85).aspx

To enable the SedebugPrivilege for the account we use to install SQL Server 2008 we can do the following on Windows XP:

1. In the run box type: secpol.msc then click ok

2. Expand "Local Policies"

3. Click the "User Rights Assignments" folder

4. On the right hand screen double click "Debug Programs"

5. Click the "Add User or Group" button

6. Click the "Advanced" button

7. Click the "find now" button

8. Select your "user logon name" and then click the "ok" button

9. Click the "ok" button 2 more times

If the above solution does not help, please post the setup log here to do future research.

You can get the log from: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\summary.txt

For more information about this issue, please see:

1. SQL Server 2008 installation aborts due an access denied: http://blogs.msdn.com/joaol/archive/2008/12/02/sql-server-2008-installation-aborts-due-an-access-denied.aspx

2. How to enable debug privileges for a user account: http://forum.sysinternals.com/printer_friendly_posts.asp?TID=1264

If you have any more questions, please feel free to ask.

Thanks,

Jin

Jin Chen - MSFT