Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CONNECT SQL vs AUTHENTICATE SERVER ??? Expand / Collapse
Author
Message
Posted Thursday, September 3, 2009 12:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 5, 2014 8:20 AM
Points: 201, Visits: 405
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 ???



Post #782496
Posted Thursday, September 10, 2009 6:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 5, 2014 8:20 AM
Points: 201, Visits: 405
Anybody???


Post #785641
Posted Thursday, September 10, 2009 12:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, October 3, 2010 3:50 AM
Points: 146, Visits: 178
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
Post #785897
Posted Thursday, September 10, 2009 1:41 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 5, 2014 8:20 AM
Points: 201, Visits: 405
thank you


Post #785959
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse