CONNECT SQL vs AUTHENTICATE SERVER ???

• SD1999

  Hall of Fame

  Points: 3140

  More actions

  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 ???

• SD1999

  Hall of Fame

  Points: 3140

  More actions

  September 10, 2009 at 6:13 am

  #1051676

  Anybody???

• Marcin Gol

  Hall of Fame

  Points: 3314

  More actions

  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

• SD1999

  Hall of Fame

  Points: 3140

  More actions

  September 10, 2009 at 1:41 pm

  #1051930

  thank you