Friday, March 9, 2012

Reporting service not starting in SQL Express 2005 Advanced

I've installed SQL 2005 Express Advanced edition on an XP SP2 machine which
already had SQL 2005 Express SP1 installed. I followed the instructions on
deleting (moving) all files in the Template Data directory before attempting
the install - in the only instance I had on the computer (MSSQL.1).
After the install, I noticed that there was another instance (MSSQL.2) which
had the Reporting services folders in it. It didn't have any of the folders
found under MSSQL.1 in it. And of course when checking which instance the
reporting services are using under the SQL Server Config Manager, it says
Instance ID 2.
Also under either the SQL Server Config Manager or the Reporting Services
Config Manager it says that the Service Status is stopped and it won't start
using either manager. It gives a timeout error.
Anyone have an idea why? Is it because of the 2 instances? What else can I
check?
Thanks in advance.I think I may have found the problem. I didn't have a local group ASPNET
established. Once I created this local group, the service fired right up.
"Wade" <wnederveld@.preinnewhofdonotreply.com> wrote in message
news:%23YSklEIaGHA.4548@.TK2MSFTNGP04.phx.gbl...
> I've installed SQL 2005 Express Advanced edition on an XP SP2 machine
> which already had SQL 2005 Express SP1 installed. I followed the
> instructions on deleting (moving) all files in the Template Data directory
> before attempting the install - in the only instance I had on the computer
> (MSSQL.1).
> After the install, I noticed that there was another instance (MSSQL.2)
> which had the Reporting services folders in it. It didn't have any of the
> folders found under MSSQL.1 in it. And of course when checking which
> instance the reporting services are using under the SQL Server Config
> Manager, it says Instance ID 2.
> Also under either the SQL Server Config Manager or the Reporting Services
> Config Manager it says that the Service Status is stopped and it won't
> start using either manager. It gives a timeout error.
> Anyone have an idea why? Is it because of the 2 instances? What else can
> I check?
> Thanks in advance.
>

No comments:

Post a Comment