Archives: April 2014
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right
2) Click Run to start setup
3) Click Ok to… Read more
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-
1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right
2) Click RUN to start setup
3) Click ok after validation check. In case of… Read more
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2.
Answer : We can disable sa user from SQL Server 2005 onwards… Read more
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. But if team managing anti-virus server did not configure anti-virus policies properly then your SQL Server is going to… Read more