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

Question

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.

Answer 1

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

Answer 2

Jin,

I am receiving the same error on a Server 2008 SP1 x64 box, performing a full install of SQL 2008 EE.  The problem is that the Reporting Service is failing to start.  The account being used is a member of the local Administrators group, and has full debug privileges.

 I have checked the account being used for the service, it is fine, as other services are using this account on the same server without any problem.  The install is still pending, waiting on the service to start, so I am hesitent to restart, or cancel.

I checked the logs for symptoms mentioned above, and found none, any help is appreciated.

---

Thanks! -Josh