Josh_Blade
asked on
SSRS 2005 Permissions
I recently learned how to build reports in SSRS, and it's been great. I am however having problems figuring out how to let people connect to the report manager without prompting them for credentials (and also not setting the security to anonymous).
I created a report that takes in an employee id as a parameter, and I'd like to make a page in our web app where employees can view their own report. I'm not sure if it's possible to give permissions that will just hyperlilnk to the report manager or if I'll have to use some report viewer control inside of our web app to display the report. Any help would be much appreciated!
SQL Server 2005 Standard + Windows 2003 Server
I created a report that takes in an employee id as a parameter, and I'd like to make a page in our web app where employees can view their own report. I'm not sure if it's possible to give permissions that will just hyperlilnk to the report manager or if I'll have to use some report viewer control inside of our web app to display the report. Any help would be much appreciated!
SQL Server 2005 Standard + Windows 2003 Server
Last Comment
The best way is to have Active directory (AD) integrated security where your users will automatically be authenticated by AD when they connect to the reporting services portal.
Here's how to do it: Go to your report server portal administration site (http://yourserver.com/reports) as the sys administrator then configure site wide security by clicking the home page and clicking properties.
Add AD security groups or individual users to different folders or groups (containers) on your report server.
Have a look at some of these resources:
http://technet.microsoft.com/en-us/sqlserver/Video/dd391734
http://msdn.microsoft.com/en-us/library/ms156014%28v=sql.90%29.aspx
Regards,
Chris.
Here's how to do it: Go to your report server portal administration site (http://yourserver.com/reports) as the sys administrator then configure site wide security by clicking the home page and clicking properties.
Add AD security groups or individual users to different folders or groups (containers) on your report server.
Have a look at some of these resources:
http://technet.microsoft.com/en-us/sqlserver/Video/dd391734
http://msdn.microsoft.com/en-us/library/ms156014%28v=sql.90%29.aspx
Regards,
Chris.
ASKER
Thanks for the links. I had messed around with the roles in the report manager previously, but that video very concisely explained some aspects I hadn't tried.
My problem more precisely I guess is that I don't want a prompt for credentials when remoting into our SQL Server.
My problem more precisely I guess is that I don't want a prompt for credentials when remoting into our SQL Server.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks a lot Chris!
C#
C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).
98K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER