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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-07 : 09:01:11
|
| Kim writes "I have a stored procedure that needs to pull in data from 2 databases on the same SQL server. The databases have application roles that are used to give execute permissions to the stored procedure. Both databases have the same application role name and password, and the role has permissions to the data needed. However, the stored procedure gives an error stating the user is not valid on the database being called from the stored proc. Any ideas?" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-01-07 : 17:54:57
|
| Once you set the application role, your connection no longer has the user context that it had before.Even though the login for the connection had access to the other database, it doesn't after the application role is set. |
 |
|
|
|
|
|
Cross-Database Transactions