Post reply

How to login in sql server using guest login

  • October 17, 2011 at 4:02 am

    #260948

    Hi,

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

    Thanks

  • 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.

  • October 17, 2011 at 5:12 am

    #1395236

    Guest is a login not a user...

    Thanks

  • 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

  • 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.

  • 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

  • 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.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply