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 |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-02-12 : 07:42:49
|
Hi guys, I'm looking though security and getting a problem dropping the Guest login.Its saying that i cannot drop because of not having the correct rights but im a sysadmin role user, its even saying the same thing when i log in using the sa account anyideas |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-12 : 07:44:46
|
| 'GUEST' user can nott be dropped. |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-02-12 : 07:50:40
|
| I was under the impression that it was better to drop the guest login from all user databases but you can't from system databases, and i'm sure that it is possible due to most of the network user databases have the guest login dropped |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-12 : 07:56:58
|
| yes, Its possible to drop the guest login from user databases. Are you having a problem doing that ? |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-02-12 : 09:11:00
|
| Sorry yes thats the problem, it keeps giving me the errorTITLE: Microsoft SQL Server Management Studio------------------------------Drop failed for User 'guest'. (Microsoft.SqlServer.Smo)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------User 'guest' cannot be dropped, it can only be disabled. The user is already disabled in the current database. (Microsoft SQL Server, Error: 15539)But i can't see where to enable this in the properties |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-12 : 09:19:22
|
quote:
Originally posted by NeilG
Sorry yes thats the problem, it keeps giving me the errorTITLE: Microsoft SQL Server Management Studio------------------------------Drop failed for User 'guest'. (Microsoft.SqlServer.Smo)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------User 'guest' cannot be dropped, it can only be disabled. The user is already disabled in the current database. (Microsoft SQL Server, Error: 15539)But i can't see where to enable this in the properties
To add guest , run this EXECUTE sp_grantdbaccess guest To remove guest ,EXECUTE sp_revokedbaccess guest |
|
|
|
|
|
|
|
|
Problem dropping Guest login