sql server connect: SQL Server management studio - A connection to the report server failed (remote server) -- sql server connect

SQL Server management studio - A connection to the report server failed (remote server)

davidw
5/23/2006 4:31:43 PM

sql server connect: Hi,

Has anyone seen this error:

A connection to the report server failed. Most likely, you do not have
permission to connect to the computer. You should either try to connect
using report server URL for the Server name, or if the Distributed COM Users
group exists on the remote computer, verify that you are a member.
(Microsoft.SqlServer.Management.UI.RSClient)

I'm using Windows Authentication and i am setup as the sysadmin role on the
server. When i try and connect with SQL Server management studio to
reporting services on my XP machine to a local domain sql 2005 server i get
the above error. I also have my username in the permissions tab in report
server properties. The report server is running and i can connect when using
SQL Server management studio locally on the server.

I am missing some access rights or could it be a firewall problem. Anyone
else experienced this before?

Cheers

David

Re: SQL Server management studio - A connection to the report server failed (remote server)

davidw
5/30/2006 12:00:00 AM

This link helped me fix the problem i had

You can connect several ways to report server in SQL Server management
studio

http://localhost/reportserver

servername

servername\instance

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1

[quoted text, click to view]