August 11, 2004 at 5:17 pm
Hi
We have just embarked on a project to install sql server 2000 on
a windows server 2003 cluster ..
Wanted to know whether we could simply install sql server (non cluster mode) and let the windows server 2003 cluster do the clustering at windows level instead
of having to install sql server in a cluster mode - active/active or active/passive ..
Thanks
August 13, 2004 at 3:46 am
First of all: Don't just start on something like this!!!!
This is not very easy done, there is a lot to take care of before you can start installing SQL Server on a cluster.
This is not to scare you, but it takes some good preperation!
August 13, 2004 at 10:19 am
Hello,
I'm actually working with the orignal poster on this issue, so maybe I can give some more information.
To answer your questions:
We are running Windows 2003 Enterprise Edition, and SQL 2000 Enterprise Server. The SQL CD has SP2 on it and I get the warning message when first installing that SP2 is not compatiable with 2003. In the past I have continued and applied SP3 afterwards with no issues.
Now I am having an issue while installing the Virtual Server on the first node. I get as far into the install wizard to where I am supposed to select the location for data files and it hangs. I can get past this if I remove the shared drives from the OS cluster, but of course there is no place to put the data files.
Now one thing I can think that might be a problem is, we have the SAN drives mounted to empty NTFS directories instead of individual drive letters. I have not been able to find anything that says this might be an issue. Has anyone here done this before, or know of a problem with it?
Any help or advise would be greatly appreciated.
Ben
August 15, 2004 at 2:43 pm
I did not do that before, and i thought is was not recommended to do so. I think it is better to use drive letters.
October 15, 2004 at 12:32 pm
Hi. I saw your discussions above. I am doing the same thing, but the difference is that i am putting MSDTC. On doing that as soon as i start the MSDTC service, i am getting the following error "Could not start the Distributed Transaction Coordinator service on local computer. The service did not return an error. This could be an internal windows error or an internal service error. if problem persists contact your system administrator" . Can anyone help me please. I appreciate it.
October 18, 2004 at 12:30 am
This link is the road to the MSDTC hotfix needed when you have trouble in the starting order of MSDTC in combination with SQL Server 2000 on a Windows 2003 cluster.
http://support.microsoft.com/kb/821751/en-us
It is not directly downloadable, but when you contact Microsoft you can get it. But remember, it can be another problem too!
The following link is also of great value
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy