November 30, 2005 at 5:09 pm
Hi everyone.
Apologies for what may be a very basic question.
Is there a correct way to remove guest as a user with msdb ?
I have deleted it manually within EM.
However we have identified this a potential issue with our application. When deleting guest , and manually adding the name back in with a public role on our test server the applicaiton performs perfectly.
However on live the re-introduction of guest does not cure the problem and the applicaiton still fails.
Would backing msdb on test and restoring onto live be a useful exercise ?
Jobs remain the same on both servers.
many thanks.
December 1, 2005 at 3:35 am
El,
First of all, what is it that the application is perfroming that requires access to the msdb database, if anything?
What errors are you getting from you application relating to this?
I wouldn't advise backing up the database and restoring it on Production, very risky business that one.
Assuming SQL2000 have a look in BOL "guest User", it explains the purpose of the 'guest' account in databases, i assume you wanted to delete the 'guest' account to reduce unauthorised access, then recreate it again as you are experiencing problems? This should not be a problem and you seem to be doing it correctly, by default the 'guest' account is a member of the fixed database 'Public' role only, as with all user accounts this role cannot be removed. You can test if you have successfully recreated the 'guest' account by creating another SQL Server login (SQL or Windows) without an associated 'msdb' user and try to query any table within the msdb database? It's also worth noting that the 'guest' user is not a special user account within databases and can be added or removed as required from any database excluding 'master' and 'tempdb'.
Failing the above, if your application does need access to the 'msdb' database have you tried creating an associated user with specific rights within the 'msdb' database for your applications login?
ll
December 1, 2005 at 3:54 am
Thanks II , will look into those ideas and let everyone know.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply