Wednesday, March 21, 2012

I can't add a new Reporting Services server registration of a remote server.

I need a help.

This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.

Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.

From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.

On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!

Is this a systemistic, configuration issue? Some advice to solve it?

Thank you in advance.
Marina B.

So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||

Hi,
thank you for the answer.

Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...

At the end I was able to solve the problem enabling the SQL server Agent and Browser!!

Thank you

Marina B.

sql

No comments:

Post a Comment