Link to home
Start Free TrialLog in
Avatar of FehlSafe
FehlSafe

asked on

SQL server Reporting services not starting

I am trying to install Microsoft Visual Studio Team Foundation Server 2010 on a box running Windows Server 2003 and I am having trouble with the SQL server reporting services not working correctly.  I have tried uninstalling the SQL 2008 and reinstalling it, but the reporting services will not remove or re-add themselves.  Now, if I try to add features, it shows that reporting services is already added as a feature, but it does not show up anywhere on the box (i.e. in the programs, or even in the services).  When I try to remove just that feature, it cannot complete.  Any help would be appreciated.  Thanks
Avatar of Paulo Pimenta
Paulo Pimenta
Flag of Portugal image

Try executing this command on the command prompt:
RSKeyMgmt -l

Open in new window

Do you get any output?
NOTE: If your SQL Server instance name is not default (MSSQLSERVER) you will have to execute
 
RSKeyMgmt -l -i <SQL_SERVER_INSTANCE>

Open in new window

Try running resetsrs.exe to reset Reporting Services.
Avatar of FehlSafe
FehlSafe

ASKER

I ran the RSKeyMgmt -l and it said The report server windows service is not responding to RPC request. The service may not be running.  I would try to turn the service on as I tried yesterday, but the service is not listed anymore.  

Toxacon:  I tried the resetsrs.exe but windows did not find it.  Do you know the direct path I can look for this without doing a search?
Hmmm... You could try to manually uninstall SQL Server Reporting Services:
 
setup.exe /ACTION=uninstall /FEATURES=RS /INSTANCENAME=<Instance_Name>

Open in new window

Try to also delete Reporting Services folder under Program Files.
If this works, I would then completely unisntall SQL Server and try a fresh installation.
Good luck!
eLN
Ok, I am in the process now of uninstalling the whole SQL server again, and it gets to a point where it has an error and says...The following error has occurred...input string was not in a correct format.
The report server will still not uninstall correctly
Can you post the sql server log?

Stored in a path like this: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log

Post the SQL Server Log and SSRS Log
Here is a nice post with instructions for uninstalling SSRS:
http://www.sqlfingers.com/2011/02/how-to-uninstall-sql-server-reporting.html

Is this the method you used for your attempt to remove it?  (and then reinstall)
ASKER CERTIFIED SOLUTION
Avatar of VENKAT KOKULLA
VENKAT KOKULLA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial