SqlServer-QA.net

One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding security-related configuration settings since the good & bad times of SQL Server version 2000, ...

Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server:  Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand it. Expand the Logins folder. Right-click on the desired login and click ...

  Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version.   The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, the 3 levels are: Authentication – subjects (persons, devices, ...

What is the Kerberos Authentication?  What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters? Let us see how the user access to SQL Server resources is controlled by ...

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more keen on applying ''disabling SA account''! I was confronted by a Database developer that  ...

Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances.  SQL Server setup information is as follows:provider:SQL native ClientProduct Name: SQLNCL1Data Source: Somewhere IN this world (SQLServer 2000 default instance)catalog=Northwind 1. Remote connections: using both TCP/IP and Named ...

This was the question raised by a newbie DBA at my workplace!  Endpoint in generic network terms they are the objects that represent a communication point between the server and client. In SQL Server as per the Authentication mode (Windows only & mixed) the endpoints are automatically created depending upon the network protocol ...