Geeks With Blogs

News
Jay Kinker
www.mundrisoft.com
www.societyhive.com


Follow me at Twitter My LinkedIn Profile Facebook

Microsoft MVP Logo


Jay Kinker - Entrepreneur, Strategist, Technologist

Error: Unable to connect to the specified SQL Server Reporting Services on <MachineName>

I got this error while creating new team project

There can be multiple reasons for this error. Here is what I did. One of them may resolve your problem

My resolution:

1. Report Server was not configured on my box. So.... I configured it with "Reporting Serivces Configuration Manager". It has self explanatory UI for the configuration. You can find this utility under Start è Programs è Microsoft SQL Server 2005 è Configuration tools

2. Ensure that http://<ServerName>/Reports is working. In my case I was getting "Service Unavailable" error because respective (ReportServer) "Application Pool" was not running. I assigned proper credentials for the App pool and restarted.

Above resolved my problem. Other potential reason could be "You do not have enough access rights". You must ensure that the credentials you are using while creating project is added into relevant TFS Groups.

Posted on Wednesday, September 17, 2008 4:06 PM Microsoft Technologies | Back to top


Comments on this post: VSTS - Unable to connect to the specified SQL Server Reporting Services on ...

# re: VSTS - Unable to connect to the specified SQL Server Reporting Services on ...
Requesting Gravatar...
Hi, I've got same problem (error message) but different resolution.

In my case, there's different account used by Reporting Services Configuration (which I set as "Administrator") and by TFS Report Manager Credential (which I set as "TFSREPORTS"). Then I gave TFSREPORTS in Reporting Services Configuration. It works.
Left by bsrd on Mar 11, 2009 9:57 PM

# re: VSTS - Unable to connect to the specified SQL Server Reporting Services on ...
Requesting Gravatar...
Excellent!
Thanks for sharing this.
Left by Jay Kinker on Mar 11, 2009 10:36 PM

Your comment:
 (will show your gravatar)


Copyright © Jay Kinker | Powered by: GeeksWithBlogs.net