How to login in sql server using guest login

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  October 17, 2011 at 4:02 am

  #260948

  Hi,

  How to login in sql server using guest login...How to test it?

  Thanks

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 17, 2011 at 4:11 am

  #1395213

  How to login in sql server using guest login...How to test it?

  By default, the database includes a guest user when a database is created. Permissions granted to the guest user are inherited by users who do not have a user account in the database.

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  October 17, 2011 at 5:12 am

  #1395236

  Guest is a login not a user...

  Thanks

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 17, 2011 at 5:25 am

  #1395238

  forsqlserver (10/17/2011)

  ---

  Guest is a login not a user...

  That's interesting. What do you get if you run this?

  SELECT [name] FROM master.sys.server_principals

  WHERE type_desc IN ('SQL_LOGIN', 'WINDOWS_LOGIN')

  John

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 17, 2011 at 5:35 am

  #1395240

  Guest is a login not a user

  Sorry for the confusion (user / login).

  I never tried it myself but based on few forums (Others) posts:

  •Enable Guest Login on SQL Server

  •Login (Windows) on SQL Server Box with 'Guest' Login

  •Connect to SQL Server with Windows Authentication.

  •Verify the rights given to ‘Guest’ account

  I can’t test the solution on my system but if it solves your issue please update us.

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  October 18, 2011 at 12:15 am

  #1395701

  Enable Guest Login on SQL Server

  • Login (Windows) on SQL Server Box with 'Guest' Login

  • Connect to SQL Server with Windows Authentication.

  • Verify the rights given to ‘Guest’ account

  DEV I dont know how to login in windows using Guest and John I am getting this with principal id's and other columns also.I am pasting first column here.There is no Guest login here.

  NAME

  sa

  ##MS_PolicyEventProcessingLogin##

  ##MS_PolicyTsqlExecutionLogin##

  NT AUTHORITY\SYSTEM

  DSU-ECGC\devsqladmin

  cisfs01

  SFS

  cikizashi01

  Thanks

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 18, 2011 at 12:59 am

  #1395713

  DEV I dont know how to login in windows using Guest

  As I already mentioned I can't do this on my system (company's IT policies) but you may enable 'Guest' Login on Windows by

  Control Panel > User Accounts > Manage User Accounts. (different route for different versions)

  Once enabled, login (Windows) on SQL Server Box with 'Guest' Login.