Showing posts with label restart. Show all posts
Showing posts with label restart. Show all posts

Wednesday, March 21, 2012

problem with guest account in the tempdb

When i restart my database server, guest login is getting deleted automatically from tempdb. it shudn't happen. please can anyone suggest me solution for my problem.
thanx and regards
kiranthe tempdb is recreated every time the sql service is restarted from a copy of model. i might create a guest account in model to correct the issue but I am not sure why you are having people log into tempdb directly.|||Hi Sean Roussy
thanx a lot for ur reply. I added guest user in sysusers table of model database. and i restarted the server and tested the tempdb, now guest user is not deleted. It works well..

thank you.
kiran|||Note that creating a guest user in the model database is a HUGE security hole, not very far beyond removing the password from the sa login. It makes all kinds of attacks trivial against your server if you ever grant anyone the ability to write queries against your server.

-PatP|||True, I agree with Pat in this matter as the security is most important for a DBA.

Kiran
If this is a development environment then you can say it is not an issue, but if you can explain your need then there will be a way to accomplish.sql