Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

use of guest account Expand / Collapse
Author
Message
Posted Saturday, March 23, 2013 10:00 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:14 PM
Points: 746, Visits: 1,702
Hi All,

What is the Guest account in SQL Server 2K,2k5 and above?

What is the use of this account? Do we really need this account?

When does sql uses this account ?

What if we disable account ? What will if i disable it ?

Can anyone give brief and precise explaination.

Thank you in Advance.
Post #1434661
Posted Sunday, March 24, 2013 11:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
What is the Guest account in SQL Server 2K,2k5 and above?

Database Users > guest User

What is the use of this account? Do we really need this account?

You can think of it as the default anonymous User, or "Everyone".

When does sql uses this account ?

When a person logged into to an Instance tries to connect to a database and their Server Login does not have a Database User mapped to the database then SQL Server will attempt to connect them to the database using the guest User. If the guest User is disabled then they are denied the ability to connect to the database.

What if we disable account ? What will if i disable it ?

You can disable it in your User-databases, and you should if you have no need to allow anonymous access into that database, but do not mess with it inside the System databases, e.g. msdb.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1434684
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse