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

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

What are the implications of server clustering on replication?

Replications works with SQL Server 7.0, SQL Server 2000, and SQL Server 2005 clustering. But as you might well imagine, configuring and maintaining a SQL Server cluster that is also involved in replication can be a headache. Whether or not you decide to cluster SQL Servers involved in replication has to do with how important the […]

I am trying to backup my databases from my clustered shared array to a local disk, but I can’t see the local disk when I run the Backup Wizard. Why?

This is a problem with both SQL Server 7.0 and SQL Server 2000 clustering. I don’t know if this is a bug, or there was some intentional reason for doing this. But there is at least one work-around that I am familiar with. The work-around is to create a backup device on the local disk […]

Is it advisable to run both Terminal Services (application mode) and SQL Server on the same cluster together?

Technically speaking, what you want to do is possible, but I wouldn’t recommend it. One problem is that Terminal Services (Application Mode) has some limitations under clustering, and is not fully cluster aware. But the biggest problem you will run into is performance. Terminal Services (Application Mode) is a huge resource hog. The same is […]