Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Authentication Rss

   Items 1 to 5 of 5   
 

Stairway to SQL Server Security Level 2: Authentication

Authentication is the first step in letting a principal get access to an instance of SQL Server, essentially resolving the question, Who are you? In this stairway level you’ll learn about the basics of authentication and the authentication options available. This level covers logins and users and you’ll learn about the password policies that can help strengthen SQL Server authentication.  Read more...
By Don Kiely 2014/06/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,826 reads

Removing the Linked Server 2 hop Limitation

This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.  Read more...
By Derek Stanley 2013/12/17 | Source: SQLServerCentral.com | Category: authentication
Rating: |  Discuss |   Briefcase | 7,138 reads

How to check SQL Server Authentication Mode using T-SQL and SSMS

Many times developers want to put logic into their code or SSIS/DTS package to check the SQL Server authentication mode. How can this be done programmatically?  Read more...
By Additional Articles 2011/01/03 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 4,182 reads

Windows Group Membership Checker

A script to reveal which logins have access to your sql server via windows groups.   Read more...
By Richard Doering 2010/09/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,008 reads

Find SQL Server Authentication Mode Configuration

Quick Method to find Configured???????????????????????? Authentication Mode  Read more...
By Vijendran R 2009/07/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 852 reads
   Items 1 to 5 of 5   
 
Tags
security (4)    
2 hop (1)    
auditing (1)    
linked servers (1)    
login failed for user (1)    
nt authority\anonymous logon (1)    
stairway series (1)    
windows (1)