I am trying to use Reporting Services but is proving more difficult than I envisaged. Here's the problem, when I try to use management studio to change the Server type to a Report server, it is disabled. Hence I cannot change it. When I read msdn, it stated that this was caused by the fact that report services was not installed. However, when I look at SQL Configuration Manager, it shows that Report Services is running. Am I not understanding something? What am I doing wrong?I know that in computing, that you should not do the same thing over and expect to get different results! I may have now have to disagree with that tenet. Somehow, magically, I am now able to set up reports in Business Intelligence, but I am still unable to change my Server type when Management Studio is started. May I get a response from one of these czars or do I have to put my fate/faith in magic?|||
Don't know if I'm a czar, but I have an answer. :)
This is by design, Management Studio Express does not support connections to Reporting Service. In fact, it only supports connections to Relational Databases. You would need to have the full version of Management Studio from one of the paid Editions of SQL Server to support connections to other services.
Mike
No comments:
Post a Comment