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 |
|
Fatalsniper
Starting Member
45 Posts |
 Posted - 2005-11-08 : 09:25:41
|
| Hey Guys,How do I get Enterprise manager to ask for a login ID on the server. When I Open EM, I can get access to any DB. How do I protect anyone from reaching it?Thanks in Advance! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-08 : 11:57:33
|
| In the registration properties for the server is the login and password.There is a checkbox to always ask for the login and password.If you use integrated security then it will use whoever is logged in to windows==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-09 : 02:07:54
|
| dbaccess is dependent on the permissions you provided to the accounts/userscheck their permission set and see if they are allowed to "reach" the other DBs--------------------keeping it simple... |
|
|
|
Fatalsniper
Starting Member
45 Posts |
Posted - 2005-11-09 : 22:36:26
|
| Thanks Guys! I'm a newbie, can't help it yet! |
|
|
|
|
|
|
Enterprise Manager Login ID