March 28, 2008 at 2:17 pm
I am working on Sql Server 2005 Express with Advanced Services and trying to set up the ability for users to view reports from their desktops. BOL is very unclear about if this is possible, and how to do it. The SSRS portion is installed on the same server as SQL Express (of course), it is installed on the Domain Controller, and all users are trying to connect remotely.
When a user navigates to the URL, the title block comes up without any of the links, and the user who is set up as the admin gets a "insufficient rights" error when using the BI Dev Studio to "deploy" reports to the server.
Only the Network Admin account gets more than the title block on the report URL.
Am I running into a "features block" or a permissions error? Also, the BOL talks about setting up users in the predefined roles ("browser", "publisher") but I have been unable to find these roles listed anywhere in the software (I am aware that I can only use the pre-defined roles in the Express edition). Again, BOL isn't clear on where that is.
Any guidance would be appreciated.
March 28, 2008 at 2:34 pm
Have you enabled remote connections on the SQL Express instance?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 28, 2008 at 2:53 pm
I have, and the Admin can connect remotely.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply