November 5, 2010 at 1:52 pm
I have successfully deployed a report by using BIDS. Please tell me how my user can access that report and the user should not be prompted for userid and password.
SQL Server 2005 SSRS
November 5, 2010 at 2:27 pm
The user would use the http://yourservername/reports and browse to the report. It will usually prompt for username and password if one of the following is happening...
1) The user's IE settings are not allowing the windows credentials to be passed automagically to the webserver.
2) the datasource used as the back end for the report is not configured with credentials that allow the report to access the database when not run by the developer. Either specify the credentials int he datasource or make certain the user has the appropriate access to the database.
3) the user has not been granted access to the report server. Make certain they are in the correct role.
-Luke.
November 5, 2010 at 5:29 pm
How can I hide all the buttons which comes in the report manager SSRS 2005. I dont want to show everything to my user. Like subscription button, security tab and all that stuff.
OR
How can I create a different page and link the reports.
November 8, 2010 at 6:30 am
salman788 (11/5/2010)
How can I hide all the buttons which comes in the report manager SSRS 2005. I dont want to show everything to my user. Like subscription button, security tab and all that stuff.OR
How can I create a different page and link the reports.
The majority of this can be accomplished by creating and using proper roles to define the security of what the users will or will not be able to do. For some things the buttons may still be there, but the users will receive an access violation error if the try to access portions of the application they do not have access to. I recommend creating a test user and playing around with the options, or reading the Books Online Section on Securing SSRS.
Additionally, you may choose to create a custom front end in whatever language you are familiar with. You can either a) use the SSRS custom control and place reports directly on your page, or you can use hyperlinks/buttons or whatever you want to launch new windows passing parameters and such through the URL to open the report.
-Luke.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply