Hello, We have a two node active/passive SQL 2005 Cluster up and running fine and dandy for the past 3 months. We just received word that we need to change our network from a 192.168.x.x to a 10.10.x.x based IP scheme. My question is, since we have IP addresses as SQL Cluster resources, d...more >>

I'm trying to setup a SQL2005 cluster and in the setup dialog I get to the Domain Groupa for Clustered Services before I get an error. I'm logged in as the administrator for the setup and this account in Domain Admin group in AD. I have the groups setup for the SQL services, but I keep gettin...more >>

I had SQL Server 2005 installed in a cluster, everything working nicely. Then I uninstalled and installed 2000 on the same cluster. Once again everything was nicey nice. Then in the process of dealing with a SAN issue, one of my servers got restored from a backup when it was 2005. The worl...more >>

Planning to go to SQL Server 2005 A/A from SQL 2000 A/A.Assuming Installing SQL 2005 on the cluster and then migrating the databases to the 2005. I have couple of questions the SQL virtual server name and IP address of the 2005 server. Can 2005 have same SQL virtual server name and IP addre...more >>

I have got a SQL performance und cluster question: today we have got one SQL cluster in our firm. 1.) the server hardware get out of service so we have to buy new hardware the performance of the cluster gets slower 2.) we got to new applications which also use SQl server the two new...more >>

Hi all, I am trying to setup the cluster SQL server, say ServerA and ServerB. While I start the setup in ServerA, it prompts, 'Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine.' But I found that there is no remote logon to both nodes and ...more >>

On my clustered SQL Server, the SQL performance counters are missing on the primary node of an active/passive or active/active. The system is Microsoft Windows Server 2003 R2 Enterprise x64 Edition + Microsoft SQL Server Enterprise Edition 32 Bits. Help Please!!!!!1 ...more >>

Hi all, I am setting up a cluster server with SAN. Once I selected a cluster group and drive for installing virtual server data files in drive S. It prompted 'There is not enough disk space on the destination disk for the current SQL server data files. To proceed, free up disk space to mak...more >>

We're attempting to add a second node to a single node SQL Server cluster running on Win2k SQL2k SP4. The install appears to work OK but when trying to bring the SQL Server resource online the resource fails. After some investigation we've discovered that MSSQLSERVER service has the unc pa...more >>

I know how to create mount point in windows 20003 cluster, I am not sur how to set it up with SQL 2005 running on the cluster. Does sql need to be dependant on any of the disks? I have trie looking for a guide, but cannot find. current setup active active cluster running. I need to add ...more >>

I know how to create mount point in windows 20003 cluster, I am not sure how to set it up with SQL 2005 running on the cluster. Does sql need to be dependant on any of the disks? I have tried looking for a guide, but cannot find. current setup active active cluster running. I need to add s...more >>

Hi all, Currently we have the following setup: 2 Node Active/Passive SQL Server 2000 Enterprise Ed. Cluster,running on Windows 2003 Enterprise Ed. Single production database,about 1.5 GB in size,growing rate is about 150 MB per month. The shared storage is on HP EVA 5000.The 2 servers and...more >>

Hello I have Windows 2003 SP1 64-bit (enterprise) on two servers. I've installed MSCS, and am ready to start installation of SQL 2000 and SQL 2005. We are currently migrating from an existing SQL 2000 cluster to this 'new' cluster. I'm installing both SQL2000 and 2005 on the same cluster ...more >>

I am having an issue with the primary node of our SQL 2005 x64 Cluster (Windows2003EnterpriseEditionx64). After installing SP1 I am getting the below error when the service tries to start. So obviously I messed up something during the upgrade. So decided to write this node off and try and...more >>

Hello to all, I am observing the following error in NODE A event log: ----------- 17050 : initerrlog: Could not open error log file 'R:\MSSQL$PROD01\log\ERRORLOG'. Operating system error = 3(The system cannot find the path specified.). ---------- Node B running and owns SQL Server and ...more >>

Hi I wish to install a windows 2003 SQL cluster into an environment that does not have a domain. Is it possible to configure a cluster without a domain? I know that windows authetication will not be available on the SQL server but the applications that we need only use SQL logons. Any ad...more >>

I have a SQL 2000 Ent server cluster with current drives in place and working. We are adding two new drives from a new SAN enclosure. The server sees the drives fine. I have added the drives into the depenecy list under the SQL server listing under the "SQL group" in cluster administrator. ...more >>

Are there any cluster aware anti virus products that dont cause problems such as the ones outlined in KB250355 http://support.microsoft.com/default.aspx/kb/250355 ?? I dont want to run with no anti virus. Thanks ...more >>

Hi, we have a win2000 adv cluster with sql server 2000 ent. last time i had to move resources from active node to passive node, i had big troubles. Moving groups caused many sql db files damaged, having db marked 'suspect' Why ? Do you know any possible reason ? This cluster does not h...more >>

We are moving away from our existing Windows 2003 cluster to virtual servers. Is it possible to move the existing SQL 2000 database from the clustered environment to a new default instance on a stand alone server? The new server would have the same name as the clustered virtual server. ...more >>

We have a two node, single instance SQL Server 2000 cluster. If I do an in-place upgrade to 2005, will it replace the binaries on both nodes, or must I run the upgrade on each node?...more >>

Running Sql Server 2000 SP3a on a two node cluster with one instance running on the active node (Active/Passive) We have to replace one of the physical nodes (repeated hw failures) - how do I go about replacing the node within SQL Server. The NT guys are telling me - that have to install fro...more >>

Can you have a 3 way server cluster with SQL 2000 on each server? I think you can do this but how does the cluster manager know which of the two remaining clusters to fail over to. Can you then upgrade only two of them to SQL 2005? Thanks, Val ...more >>

Hi all. My first time posting to this newsgroup, but I think I am in the right place. I am in the discovery stage of building a web site that we anticipate will have a large amount of traffic. Our design platform is Windows and Microsoft SQL and the goal is to have web sites and database ...more >>

Hi Is it possible to install an instance of SQL 2005 and an instance of SQL 2000 onto the same virtual server in a microsoft cluster. What I need to do is to have a total of 3 instances on a 2 node microsoft 2003 cluster running in active active. One node needs to have one SQL2005 instance...more >>

hi... Sorry if i am putting question at wrong place, guide me. I have tried 2 exploits (available on net) of Distributed Transaction Coordinator at 4 different 2k machines. But after execution of exploit, i dont see any change in behavior of DTC. It works as it was. The target systems do not...more >>

Hello, We are wanting to setup a sql2k5 std cluster and are curious if we have good specs drawn out. SAN has 3 arrays SQL Group has the following resources: Network name IP Address physical disks for data (RAID 5) physical disk for logs (RAID 1) Cluster Group has the following ...more >>

Hi, We have a two node failover SQL 2000 cluster setup. These servers are on a closed netowrk where they do not have access to internet or anything other network. I now have a need to be able to connect to the SQL server from another network. I had added the correct gateway etc and can assi...more >>

We have an clustered sql server 2000 with service pack 4. We are trying to import some date using 'bulk insert'. The command ends ok but there is no rows inserted on our table. Furthermore if we specifify a data_file that not exists the commands end ok with no error message. The same comman...more >>

Hey everyone, We are about to try to cluster SQL 2005 for HA on two windows 2003 ent. servers. Anyone know of a step-by-step white paper? Do I need a "Quorum" disk like our Exchange cluster? Are the steps for clustering Windows the same as when we did our Exchange 2003 cluster? If so,...more >>

It is my understanding that this Active Directory account takes on the role(s) of SQL's BuiltIn Administrator in a clustered environment. Should the ClusterService Log On account password be reset in AD, without reseting in the properties tab for the service on the physical nodes cluster fa...more >>

Is there an easy way to rename the Cluster Server Name ? What about renaming the underlying physical nodes as well ? Can this easily be done or does this call for an entire Cluster rebuild ? Using SQL 2K and Windows 2003 ...more >>

We are planning to move to SQL Server 2005 and we do have A/A cluster . Which is the most efficient way to move from SQL Server 2000 A/A to SQL Server 2005 A/A cluster. 1) Upgrade from SQL Server 2000 to SQL Server 2005 2) Install a new installion of SQL Server 2005 cluster and attach the ...more >>

In the old days when we have physical disk drives in our SQLServers, we always located the logs on a seperate volume from the data files for performance reasons. In the new era of using SAN storage for the database files, does it still make sense to use seperate logical SAN drives for the d...more >>

Does it matter on the type of domain group to create; Domail Local, Global, Universal. Does it matter where in the AD it resides, under departmental OU's or highe....more >>

I'm sure this is an often asked question, but can SQL 2005 be clustered after it is installed, or do you need to cluster Windows first then install SQL 2005 on each node? Thanks!...more >>

On one of our active nodes we cannot start the configuration manager but we can start management studio. We get the error message "Connection to target machine cannot be made in a timely fashion". Any ideas on what causes this and how to fix? Thanks...more >>

The basics Win2k Enterprise SQL 2005 Enterprise 2 node cluster, single instance. So I have had these servers up for a little while and would like to add SSIS to them. I found this document here about running setup from the command line for a cluster http://msdn2.microsoft.com/en-gb/lib...more >>

If I am correct I have mistakenly added the private network to the sql ips. I now understand these are used for client access and so the Private network which is used for the cluster heartbeat should not have been added. Correct me if I am wrong.... Now, if I am not wrong and it is/was a mista...more >>

Hoping someone might help on this sizing problem: I have ordered 2 * 2950s for DAS to a Dell PowerVault221S On each node I will have 2 * 36GB drive RAID 1 for local OS on each node 2 * 73GB drive RAID 0 for a local backup destination On the shared storage / powervault I have: 2 * 36GB f...more >>

i have a table with 10,000,000,000 records and i need Select and Insert many records from or into this table in less than one second. i can't buy a very expensive hardware(Server) for this SQL Server 2005 but i can buy many medium price hardwares(Servers) for this SQL Server 2005. how can i di...more >>

Hello, re: SQL Server 2005, SP1 I set up Database Mail on a clustered server using the db mail wizard in Management Studio. I set up an operator using a mail group. The test email worked fine. I also restarted the SQL Server Agent on node 1 of the cluster (twice). Next, I set up a notifi...more >>

I have to add SAN space to an existing cluster. what are the steps? thanks...more >>

I got this error while trying to install sql server 2000 Ent Edition on Windows 2003 Cluster: "another virtual server with the same name exist on the network" Any help will be appreciated. Thanks ...more >>

I have a cluster active/Pasive with windows 2000 profesional advanced Server. I have installed SQL Server SP3. After an update of drivers for HBA, when i restar the computer i obtain a error in the Application Event Log, like this Event Type: Error Event Source: MSSQLSERVER Event Catego...more >>

When makes an application require the use of a default SQL instance versus named instances? If named instances are allowed with an application, how does one specify the specific instance to use? ...more >>

We are planning to move all resources to some SATA drives so we can reconfigure the SAN. This includes the Quorum and all data resources. Does anyone have any advice or can anyone think of any "gotchas" that we should be watching for or preparing for? ...more >>

Hi! I have a problem with Full Text Search in a clustered enviroment. The Resource Fullt Text Search will not come online, it fails and giving me a error in the log that says "An Error occurred during the online operation for instance <SQL Server Fulltext (UTB2)>: 80070002 - the system ca...more >>

We have set up SQL Server 2005 Failover with Windows 2003 cluster. Our cluster consists of two servers and a SAN. Our Active server includes a tape drive. In the process of researching how to backup to tape in a cluster environment, I came across this statement... Tape devices should nev...more >>