Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / October 2005

Tip: Looking for answers? Try searching our database.

msdtc config / sql server 2k cluster(sp4) / W2k3 sp1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LufkinTXDbajohn - 28 Oct 2005 17:27 GMT
I have an application that uses com components to connect to it's backend sql
server db.  Right now the db is running on a W2k server (sp4)
(non-clustered).  I've copied the dbs to the clustered environment that we
are migrating all of our databases to, and now the com components do not
connect.  I've installed the Network DTC components and have configured the
MSDTC resource via Cluster Adminstrator and can see that the service starts
on each server in the node as I fail the cluster group between those nodes.  
I've read and adhered to doc 301600 and it's sub article of 817064
(pre-reqs).  Not sure what else may be wrong or that I need to validate.  The
application returns the following error when the user tries to login via the
web portal:  New transaction cannot enlist in the specified transaction
coordinator.  The application runs on a W2k (sp4) server.  Any guidance would
be greatly appreciated.
Geoff N. Hiten - 28 Oct 2005 19:01 GMT
It isn't anything to do with the cluster. This would happen on a stand-alone
system anyway.

HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;555017

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I have an application that uses com components to connect to it's backend
>sql
[quoted text clipped - 16 lines]
> would
> be greatly appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.