October 18, 2005 at 5:16 am
Hi,
I know this seems odd but is there any way to change the guest's password?
I know this is paradoxical regarding the nature of guest user but if there is any way please clarify me!
-Thanks
October 19, 2005 at 8:51 am
Guest is a database user. It is not a login. Only Login names have passwords. Once you have logged into SQL Server using either your NT login or a SQL Server login (using a password) then SQL checks to see if you have a corresponding user in the database you are trying to connect to (SQL also checks if you are a member of a server role that will grant you access) SQL Server will also check to see whether a guest username exists. If so, the login ID is granted access to the database as guest. If the guest account does not exist, SQL Server denies access to the database.
The user name is used internally by SQL to check your permissions, You don't use this name to actually log in, so no password is needed.
Francis
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply