InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:48:50 GMT20http://www.sqlservercentral.com/Forums/Topic782496-146-1.aspxthank youThu, 10 Sep 2009 13:41:14 GMTSD1999http://www.sqlservercentral.com/Forums/Topic782496-146-1.aspxhere: http://www.mssqltips.com/tip.asp?tip=1714you 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 Thu, 10 Sep 2009 12:26:05 GMTMarcin Golhttp://www.sqlservercentral.com/Forums/Topic782496-146-1.aspxAnybody???Thu, 10 Sep 2009 06:13:28 GMTSD1999http://www.sqlservercentral.com/Forums/Topic782496-146-1.aspxGentlemen,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 ???Thu, 03 Sep 2009 12:57:03 GMTSD1999