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 |
|
Revuca
Starting Member
19 Posts |
 Posted - 2003-01-17 : 07:29:25
|
| If there is anyone that could help me find out why I am logging in as an administrator I will really appreciate it.I have deleted my login as well as the domain\administrator login, removed myself from all SQL\NT groups. The only login that remain is the Builtin\administrators login which I'm assuming is what I'm now using. I don't belong to ANY admin groups on the NT domain.Why am I still logging in as administrator ? Any help will do.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-17 : 13:02:02
|
| Maybe your system has your login cached or maybe someone has added the users group to the administrators group. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-17 : 13:43:35
|
| run exec master..xp_logininfo 'domain\username' in query analyzer and you should see why it thinks you are an admin in the permissions path column of the results. Replace domain\username with the account you use to connect SQL Server.HTHJasper Smith |
|
|
|
|
|
|
Administrator login