Monday, March 19, 2012

Getting Report Server Running on Local Instance of SQL Express

I have installed SQL 2005 Tools which installed Visual Studio 2005 including SQL Server Reporting Services Designers. I thought this would create a local instance of SQL Server 2005 but it did not. So I installed SQL Server 2005 Express so I could designate it as my local Report Server instance. How do I configure this local instance to be used for Report Server?

RS Configuration Manager

Machine Name: "localmachinename"

Instance Name: greyed out

No report servers were found on the specified machine.

Details: Invalid Namespace

Did you install the Advanced Edition of SQL Server 2005 Express ? If not you wont have the Reporting Server installed. YOu can download the Advanced Services edition from here: http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=de

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I eventually came to the same conclusion. Thanks

No comments:

Post a Comment