January 22, 2003 at 3:00 pm
I found out recently that in NT security is used to launch EM. Can I use SQL Server security? Is it possible to make EM ask for UserID and Password everytime it launches?
Edited by - bani on 01/22/2003 3:01:48 PM
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
January 22, 2003 at 3:13 pm
Yes to all of the above. Usually you can set these things when you register a server. But if you need to do afterwards then open EM, drill to the server, right click the server the choose "Edit SQL Server Registration properties...". The rest should be understood.
January 23, 2003 at 3:11 am
I tried it and still no luck. Changing the properties in the server registration did not grant non-admin NT user right to use EM. What I want is to allow non-admin NT user to use EM. It is up to EM to ask for the user and password. I want SQL server to decide who can use EM not NT.
Thanks for the reply
Edited by - bani on 01/23/2003 03:14:03 AM
Edited by - bani on 01/23/2003 03:15:11 AM
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
January 23, 2003 at 4:27 am
Ahh. Sorry that is not possible. You have two modes of authentication, NT or Mixed (SQL and NT). EM can be used by either one but they still only have as many rights as you gave them for login. So even thou they can see all the DB names, they will not be able to interact with those they don't have rights on.
January 23, 2003 at 12:05 pm
Try granting the userid in question Read on Master (it might need msdb as well).
I have found Query Analyzer will not work unless they can read master.
KlK, MCSE
KlK
January 24, 2003 at 12:11 am
That is alsp my hunch but I just want to make sure. I think I have to do a little Winsk server digging myself. I am just curious.
Tahnk you Antares686 and kknudson. kknudson, I'll try your suggestion.
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply