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 […]

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 […]

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 […]

How do I change the IP addresses of clustered SQL Servers?

Question Recently, due to corporate requirements, we had to change all the IP numbers on all our servers, including our clustered SQL server. Since this change, we cannot set up an ODBC connection or connect to Enterprise Manager using the virtual IP address or the virtual name of the server, although we can using the […]