SQL 2000 on win2k3

#1

help!
We are running a win2k3 cluster with sql2000, MSDTC seems to be running, and
it is added in the cluster resource.
I have done the dtctester and I get this result
Password: 1paSS4twf
tablename= #dtc25732
Creating Temp Table for Testing: #dtc25732
Warning: No Columns in Result Set From Executing: 'create table #dtc25732
(ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
Driver][SQL Se
rver]MSDTC on server 'BECL02KE\SQLCL1' is unavailable.'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.

#2

Make sure you do 817064 BEFORE you do 301600.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog

"Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote

Quote:

For Windows 2003, we willneed to enable network MSDTC access. Have you
already done this.

How to Configure Microsoft Distributed Transaction Coordinator on a
Windows Server 2003 Cluster
http://support.microsoft.com/?id=301600

How to enable Network DTC access in Windows Server 2003
http://support.microsoft.com/?kbid=817064

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no
rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2000 on win2k3

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

SQL 2000 on win2k3 - 09-21-2004 , 10:24 AM

Re: SQL 2000 on win2k3 - 10-05-2004 , 06:56 AM