MS SQL Server - SQL 7 No Guest

Author

SQL 7 No Guest

George Hester

2005-08-31, 9:23 am

When I make a new database the Guest account is not created. It also does
not exist in Logins under Security | Logins in the Enterprise Manager. It
does exist in all the databases that were created by various install
programs. How do I fix this?

--
George Hester
____________________
_____________

Tibor Karaszi

2005-08-31, 8:23 pm

There no such thing as a Guest login in SQL Server. As for the user named guest, such has never been
created by default. If you want one, create it. If you want such in all future databases, create
such in model.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"George Hester" <hesterloli@hotmail.com> wrote in message
news:uv4ePBjrFHA.3836@TK2MSFTNGP12.phx.gbl...
> When I make a new database the Guest account is not created. It also does
> not exist in Logins under Security | Logins in the Enterprise Manager. It
> does exist in all the databases that were created by various install
> programs. How do I fix this?
>
> --
> George Hester
> ____________________
_____________
>

Sponsored Links