Post reply

CONNECT SQL vs AUTHENTICATE SERVER ???

  • September 3, 2009 at 12:57 pm

    #134901

    Gentlemen,

    In Management studio, right click on the server name go to properties.

    Click on Permissions….

    In the bottom part of the window where the ‘explicit permissions’ are….

    What is the difference between CONNECT SQL vs AUTHENTICATE SERVER ???

  • September 10, 2009 at 6:13 am

    #1051676

    Anybody???

  • September 10, 2009 at 12:26 pm

    #1051878

    here: http://www.mssqltips.com/tip.asp?tip=1714

    you can find following informations:

    AUTHENTICATE SERVER - Grants or denies the ability to use a particular signature across all databases on the server when impersonation is used..

    CONNECT SQL - Grants or denies the ability to connect to the SQL Server. All logins, when newly created, are granted this permission automatically

  • September 10, 2009 at 1:41 pm

    #1051930

    thank you

Viewing 4 posts - 1 through 3 (of 3 total)

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