Unable to connect to the Report Server
Win/7 Professional SQL Server 2008 R2 Express Report Services Configuration Manager When I launch it, shows correct Server Name, but report server instance is blank. When I press FIND I get: "Unable to connect to the Report Server <machine name>" This is my development workstation, so no IIS installed. Seems to work fine on XP. SSMS works fine - no issues. I tried uninstalling SQL Server completely, rebooting, reinstalling a fresh download. Same result. I've googled every article I can find - nothing. Can anyone point me in the right direction? Thanks.
February 19th, 2011 10:25pm

Hi , Did you check if TCP/IP is enabled for the SQL Server service. If Disable you may need to enable it. To resolve this error, you can either modify the connection string to use the server name or you can enable TCP/IP for the service. Follow these steps to enable TCP/IP: 1) Start SQL Server Configuration Manager. 2) Expand SQL Server Network Configuration. 3) Select Protocols for MSSQLSERVER. 4) Right-click TCP/IP, and select Enable. 5) Select SQL Server Services. 6) Right-click SQL Server (MSSQLSERVER), and select Restart. Also Check the below link. Hi , Did you check if TCP/IP is enabled for the SQL Server service. If Disable you may need to enable it. To resolve this error, you can either modify the connection string to use the server name or you can enable TCP/IP for the service. Follow these steps to enable TCP/IP: 1) Start SQL Server Configuration Manager. 2) Expand SQL Server Network Configuration. 3) Select Protocols for MSSQLSERVER. 4) Right-click TCP/IP, and select Enable. 5) Select SQL Server Services. 6) Right-click SQL Server (MSSQLSERVER), and select Restart. Also Check the below link if doesn't work from above. http://msdn.microsoft.com/en-us/library/ms365170.aspx Regards, PS
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2011 1:23am

Thanks for the reply! Turns out if you do not install SQL Server Express with "Advanced Services", the Reporting Services Configuration Manager is still available on the start menu, but doesn't work. Solution is to find the additional installation options on the express download page and get the version with advanced services. Then everything works exactly as it should. If you look in SSMS under database and do not see the reporting services databases, then you know that you do not have reporting services installed.
February 21st, 2011 2:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics