CONNECT SQL vs AUTHENTICATE SERVER ???

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » CONNECT SQL vs AUTHENTICATE SERVER ???

CONNECT SQL vs AUTHENTICATE SERVER ???

Rate Topic

Display Mode

Topic Options

Author

Message

SD1999

Posted Thursday, September 03, 2009 12:57 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:17 AM
Points: 193, Visits: 376

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

SD1999

Posted Thursday, September 10, 2009 6:13 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:17 AM
Points: 193, Visits: 376

Anybody???

Post #785641

Marcin Gol

Posted Thursday, September 10, 2009 12:26 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, October 03, 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

SD1999

Posted Thursday, September 10, 2009 1:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:17 AM
Points: 193, Visits: 376

thank you

Post #785959

« Prev Topic | Next Topic »

Permissions