I was trying to install SQL 2005 64 bit on a cluster . the install half way and when I uninstalled SQL I still have the services in Computer Managment. Is there any way to get read of them to be able to do another install? Help ...more >>

Hi, We're having a SAN outage & I've noticed some **flakiness with regard to a 'clean' shutdown of our SQL 2000(active/active) & 2005(active/passive) clusters. **In the past when we've disconnected storage and had to cold boot all the cluster nodes, we've had trouble starting the cluster...more >>

I am going to install SQL 2000 SP-4 on Active/Active & Active/Passive. we cannot have down time as it is 24/7. i need help to install SP-4 with some good steps & what are the things to be consider before & after installing SP-4. Any help is appreciated & thanking in advance. ...more >>

Hello , I have couple of questions on clustering as well as on hardware. 1) Is the license for SQL Server 2005 Enterprise edition ( Production) on active/active and active/passive is same? 2) Is the license for sql server 2005 is socket based or processor based, is there any differnce b...more >>

I just setup my first 2 node Active/Active SQL Cluster and from what I can tell you can have only one (1) default instance in an Active/Active cluster. The other instance has to be a named instance. Is this correct, or am I crazy? If so, I don't undertand why this limitation. Since the 2 SQL ...more >>

I am installing SQL 2005 64 bit on a cluster Active/passive . I am getting an error when I am giving SQL install path of D drive which is a local Drive .. I am getting this error any idea? Could not access network location D: (x86)\. ...more >>

We are upgrading our current clusters to new hardware HP DL 380 G5 with 2 clusters each with 2 nodes. but for both sql clusters we need to use same MSA 1000 with 2 controllers (having 4 arrays Array1,2,3,4(with 2 arrays(1,2) for Cluster1 and remaining two arrays arrays(3,4) for cluster 2 . i...more >>

Hi, I am a newbie to Clustering. I dont know how to decide how many number of nodes I need to install. For example, if I have 4 SQL database servers and all 4 servers should be highly availabe and automatically failover. In this case how can I configure clustering? ...more >>

Hi Apologies if this isn't the right forum. I have an instance of sql (2005) setup called SQL1\SQL1 I am trying to connect to a database (hm1) using the following connection string in my web.config: server=SQL1\SQL1;database=hm1;uid=hm1;pwd=hm1; ...but it can't find it. I need to k...more >>

Hello, What is the SQL Server 2000 supportability..? Can i get any KB which explains that. Is SQL Server 2000 with SP3 supported. I hope this is the right group....to post... Thanks...more >>

Hello, I had two issues setting up a SQL 2005 cluster today. Can anyone shed any light? 1. I tried to move tempdb from one drive to another and received the following error: Msg 5184, Level 16, State 1, Line 1 Cannot use file 'T:\Sqldata\tempdb.mdf' for clustered server. Only formatted ...more >>

Hey All, We have SQL Server 2000 in our production environment and we have a brand spanking new cluster that has more CPU power and RAM than our current server. The issue I have is how to move the data. We have 10 Databases, most are small, but we have a few that are 5 to 9 GB and one that is...more >>

Hello: Does SQL2005 Standard Version can be install on Win2003 Cluster? Thanks!...more >>