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 |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2006-03-27 : 00:53:04
|
| Is it possible to have an ID that can access 2 databases? If it's possible, I have to create the same ID and password under each database? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-27 : 00:58:29
|
Yes. Just grant the access to the required database to the login id.
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-27 : 00:59:11
|
Or are you referring to access to 2 databases on 2 different SQL Server ?
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-28 : 23:26:51
|
thanks KH.2 databases are on the same server  |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-29 : 00:17:49
|
| I can't find how to add access to another database. Is it done in role properties? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 00:38:22
|
You can do it via Enterprise Manager - Security oruse sp_grantdbaccess
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-29 : 03:56:43
|
I got it! many thanks  |
|
|
|
|
|
|
|
|
Single ID access 2 databases