Hi! I have a problem with linking two servers. I have created a login called "linked" and set full permissions to the pubs-database on booth servers. When I first create the linked server and linked server login on server1 everything goes fine. And I can connect to server2:s pubs-database...more >>

Hi I had a sql 2000 cluster with 2 node active\active and I would like to rename my sql default name to another name but MS recommend to uninstall and reinstall sql If I uninstall just the default name.Will it create any impact on my second instant name? Have any one done this before? Pleas...more >>

Hi all, I need to know how to install sp3 of sql on my sql cluster.Sql server runs properly now.Is there any notes to pay attention to while installing the packs? What shuld be the best pratices and best procedures for it. Thanks a lot. ...more >>

I understand it is recommended to have a private LAN for inter-cluster communication but we are not able to do that due to resource limitations. We have one network interface on each node in the 2 node SQL server cluster (no room for expansion). Each port goes to a switch where there is o...more >>

MS SQLSever service accounts should not be members of the local Administrator or Domain Admins groups. Is this also troug for SQL Server Cluster? Many Thanks John...more >>

Hi I've got a big probem, my service accounts for the cluster and sql are losing there password from time to time. So I can't move the cluster resource. All servers are W23, 2 AD Controllers, 2 Cluster Nodes. Any ideas to solve this problem? Thanks...more >>

Have cluster running on two servers; suppose I lost both of them, but have a tape backup of the cluster. Does anyone have some thorough directions on restoring the cluster on different servers? We've had no luck in completely making the restore function....more >>

Hi, We have a W2k3 cluster with a group MSSQL 2000 sp2. Now when we try to start the setup for MS SQL sp3a it stops saying that it cannot detect the satus of a service. We have applied a security template which might conflict with MS SQL sp 3a. In security log we get message as below : Does ...more >>

Hello: I took the MCDBA exam last week. I almost got over the hump, but one question on the test (related to the Subject:) left completely stumped. If you can provide any help, I would be most appreciative. The gist of the question is: -------------------------------------------------------...more >>

I have a Windows 2000 Advanced Server with SQL Server 2000 Enterprise Edition with SP3A. The cluster is set up as a Active/Active cluster. What would cause the Cluster File Share resource to fail? I have a file share directory set up so that if my server fails over the file share dir...more >>

I understand it is recommended to have a private LAN for inter-cluster communication but we are not able to do that due to resource limitations. We have one network interface on each node in the 2 node SQL server cluster (no room for expansion). Each port goes to a switch where there is...more >>

You would think this would be relatively staight forward as they are both Microsoft products. Now the issue is that when trying to run the sql 2000 setup the installtion always bombs out out when I enter the remote information ie either the designated sql service account or the administrator's...more >>

Is there any way that we can use two drives on a single database and server. Example, my database is located at drive C and that drive becomes full. Is there anyway that the data will automatically written to the second drive (Drive D for example) without user intervervention? If so, what ...more >>

on the passive node i tried to set range port for DTC I tried using dcomcnfg, but when i reboot the node cannot join the cluster. Why ? thanks in advance. Regards, Dario ...more >>

Hi All We're doing a demo tomorrow. However we only have a single node available and SQL 7 clustering wizard tells me that there is no cluster. There is, but its only a single node. Everything else is in order re disks, resource groups, services, etc. Am I to take if from this that SQL Server...more >>

My cu has the Win2003 Cluster 4 nodes with 1 Default and 3 Named instances SQL 2000, each instance is on different node, we noticed that every instances have configured with TCP port 1433. Is it possible on Cluster??? Hello.K ...more >>

Reading some previous threads, I am a little confused. We have 2 Windows 2003/SQL 2000 clusters. One has been in production for months now, without problems. We did not follow KB 817064 (how to enable network DTC access) or KB 301600 (configuring MSDTC on 2003), yet our install went fine and S...more >>

1. This is a different cluster with 2 nodes. I was not involved whatsoever during the setup and install. Therefore I have no idea what Server Admin did; 2. Win2k Advanced, SQL2kEnterprise SP3, 2 Nodes, SQL Default instance; 3. There are 2 groups configured under Cluster Admin: Cluster...more >>

Hi Guys, I implemented log shipping but if database is open during load the restore is failing. i think i selected "terminate users in database" option. how i can confirm whether i selected this option? and how can i change this. THNKS BIJU...more >>

Hi all, I have some trouble with SQLAgent...when I try to schedule a job that invokes a script (vbs, java, cmdshell,...), SQLAgent crashes at the moment of scheduled execution. If I try to execute it manually, all works fine. This installation runs on a cluster Win2003 and the node initiate a fa...more >>

I've upgraded our SQL2k server to cluster using Dell 2650's attached to Powervault chasis -- U320 all the way through. Our db's are 90% read, and performance had degraded significantly. Anyyone able to suggest a better external raid config and still keep my u320 15k scsi disks? I see the Hp offeri...more >>

I would like to setup SQL Enterprise in a 2 node cluser to act in a "active/active" form. I may be using the wrong termanolgy. I would like to have both SQL servers handle client requests for the same database. In the event if one node fails the other node will handle all of the traffic....more >>

Hi, My end goal is an active-passive sql2000 cluster running on 2 windows 2003 ee nodes. I have installed the os, got the san drives recognised and setup the cluster. then i run sql2000 setup: specify virtual,name,ip specify default instance name specify drives install options setup...more >>

I'm a newbie with a big load, and I would appreciate some insight. In my environment, I have an active/active cluster, that also has Snapshot Replication from the slave node to the master node. Can someone offer some guidance how to apply the SQL SP3a service pack? In the Service Pack 3...more >>

I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I have a few questions with regards to MSDTC. Documentation I have says that MSDTC must be clustered in order for SQL clustering to work. It also says that you cannot use comclust.exe anymore and that MSDTC must be setup in i...more >>

In a two node SQL server cluster, with each computer in the cluster storing the database on its local hard drive, is it OK to have the quorum drive on a NAS/network server. So the database will be direct attached on one server. The database will be replicated to another computer with a di...more >>

Hi, We have a SQL 2000 cluster server. We need to run a query on an access database. We have set up a linked server, however we always get the error; Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned m...more >>

I'm planning on installing SQL 2000 on a 2 node Windows Server 2003. I want to have both nodes to be active SQL servers and they will both be available for each other in the case of a Failure. Any issues regarding this tipe of setup? Is there a way to setup the second node without havin...more >>

See error below "An error occurred while creating virtual server resources for clustering. The system cannot find the file specified."...more >>