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 |
|
FrankSausH
Starting Member
10 Posts |
 Posted - 2010-03-14 : 17:58:14
|
| Hello,I have two databases and want to get data with query in db1 from db2.I get an 916-error "The server principal "user1" is not able to access the database "db2" under the current security context"What can i do?Thank you for your help. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-14 : 18:04:17
|
| Can assign user1 to db_datareader role in db2or can allow cross database ownership chaining. but i like the 1st solution better |
 |
|
|
FrankSausH
Starting Member
10 Posts |
Posted - 2010-03-15 : 10:24:09
|
| Hello, thanks for your answer. On my local server it works, but not on the hosted one. There i have two dbs and each db has its login/user. |
|
|
|
FrankSausH
Starting Member
10 Posts |
Posted - 2010-03-15 : 12:06:40
|
| Hello, my hoster says that this is plesk limitation: each user can manage one db. Does anyone knows about this limitation? |
|
|
|
|
|
|
query between two dbs