Home » 2014 (Page 13)
Yearly Archives: 2014
How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?
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 any failure, you need to … Continue reading
SQL Server 2000 || Disable sa login
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 but this is not possible … Continue reading
Antivirus Exclusion Policy for SQL Server
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 face the problem. Here, we … Continue reading
Steps for Windows Cluster Installation on Windows Server 2008
Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008. Step 1: Validate Cluster Configuration a) Open Cluster Administrator & click on “Validate a Configuration” b) Wizard for cluster validation appears, click Next c) Add Node to create cluster d) Select Type of test want to perform e) Confirmation … Continue reading