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 |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2010-10-25 : 12:28:02
|
| I have a new database server that I am going to use for reporting services. It will be server A. Server A connects to B and C. I want to make some distributed queries through stored procedures so people can read the data through a web page or SharePoint page or a Reporting Services page. I presume you need some kind of faceless service account so the web page can access the server. Am I correct on this?But I also want to make sure the stored procedures don't fail if they have to log into B or C. We are using Active Directory with Windows authentication - no SQL Server authentication.Any suggesstions on this will help, even if they don't cover everything I mentioned.Duane |
|
|
|
|
|
Help with stored procedure permissions/accounts