SQL Server Clustering

We are unable to install SQL Server 2005 on additional node on top existing cluster setup running Windows 2003 x64 bit operating system?

When we are trying to install SQL Server 2005 x64 bit on the second node, it is listed as ‘unavailable’. Further we are unable to install SQL Server 2005 x32 bit that hangs on installing the SQL Server cluster resources. How can this issue be resolved and how to install SQL Server 2005 x64 bit […]

What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?

Question We are considering running our SQL Server 2005 database server on a Dell 2950 x64. We also want to implement database mirroring, and are considering using an HP DL360 as a witness server. In addition, the mirrored databases will be running in a VM running on ESX. Is it a feasible configuration to use different […]

What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005?

Question: What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005? How to track password changes on SA account? Solution: There are few caveats for the beginners in SQL Server to be aware about in managing roles and security. The […]

How to view properties when trying to view the same index details in SQL Server Management Studio ?

Question:   I’m able to add and edit Indexes using SQL Server Management Studio (SSMS) successfully, but unable to view properties when trying to view the same index details in SSMS. How to resolve this problem?  Answer: The user can view database.table.index properties using SQL Server Management Studio without any issue if that user has the privilege to perform such a task. But it is not possible to view an index’s properties if […]

How to hide databases in SQL Server Management Studio from unauthorised users?

Question: If a user is not authorized to see a database can I exclude that database from even appearing in SQL Server Management Studio for that specified user or group? Answer: Until SQL Server version 2000 it was not possible to hide the database information from being displayed on SQL Server Enterprise Manager. In SQL Server 2005 […]

How to allow access to non sysadmin users to view status of sysadmin owned scheduled jobs?

In SQL Server 2000 only sysadmin (sa) privileged users can manage the scheduled jobs under SQL Agent tasks. In general any user can create a job, but a job can be edited only by its owner or members of the sysadmin role. The user can also view its history. Viewing a job’s history allows you to […]

I am having a problem installing an Active/Active SQL Server cluster.

Question I have recently set up a two-node cluster using Windows 2000. I have a single RAID 5 shared disk array that is sliced into two logical disks which appear in Windows 2000 Disk Manager as Disk 1 and Disk 2. I have also created one primary partition on each disk and have assigned drive […]

Does a SQL Server cluster support load balancing?

Question I was told by a friend, that at his last company they had a SQL Server environment which contained four clustered servers that were load balanced. So in effect, when they pulled the plug on one server, the other three would adjust and pick up the load.From my experience of setting up and using […]

We have a SQL Server 2000 cluster. I have been trying to get SQLMail to work with it, but have failed. What am I doing wrong?

SQLMail is not officially supported under SQL Server7.0 clustering. SQLMail in SQL Server 2000 is supposed to work under clustering, although I have not personally tried it. In fact, I don’t recommend it as you must add mail clients to both servers, and I don’t like the idea of adding mail clients (with all the […]

We are planning a new SQL cluster. We intend to have the two servers separated by 100 meters. Will the cluster’s shared disk array be a single point of failure for us?

A cluster is designed to provide fault tolerance for the physical servers, the operating system, and the application software, but not for data. Fault tolerance for data should be handled by a fault tolerant shared disk array, log shipping, or database mirroring (in SQL Server 2005). So in a sense, the shared disk array is […]