Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2005-09-15 : 21:55:51
|
| I am looking to hear best practices on setting up the data sources in Reporting Services. I don’t want to grant individual users access to the report data sources, which are databases on other SQL Servers in the same domain.It looks like my choices are to use SQL Server logins, domain logins, or local logins on the remote servers, and to enter the user name and password into the data connection. I am tending towards the idea of using local logins on the remote servers in the data connections. I try to avoid SQL Server logins for all the well known reasons, and I figure that a local login on the server will have the least access to resources.Does anyone have any experience or gotchas with this they would like to share, or know a way they feel is better?CODO ERGO SUM |
|
|
jhermiz
3564 Posts |
Posted - 2005-09-17 : 05:52:54
|
quote:
Originally posted by Michael Valentine Jones
I am looking to hear best practices on setting up the data sources in Reporting Services. I don’t want to grant individual users access to the report data sources, which are databases on other SQL Servers in the same domain.It looks like my choices are to use SQL Server logins, domain logins, or local logins on the remote servers, and to enter the user name and password into the data connection. I am tending towards the idea of using local logins on the remote servers in the data connections. I try to avoid SQL Server logins for all the well known reasons, and I figure that a local login on the server will have the least access to resources.Does anyone have any experience or gotchas with this they would like to share, or know a way they feel is better?CODO ERGO SUM
I'm not too certain I follow the issue. Why don't you create a specific user responsible for running these reports and grant access to the stored procedures used for those reports ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
|
|
RSS Data Connections