2003 server connecting to SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

mark_at_icsfiles.com
Date: 08/22/04


Date: Sun, 22 Aug 2004 10:59:38 -0700

I am connecting to a SQL Server database from ASP pages.
The web site and SQL Server are on two different
machines. The web server is running 2000 server.
Everything works fine.

I copied the web site to a 2003 server and I'm still
connecting to SQL Server on another machine (the same
database as was working with W2K). Now, intermittently,
the ASP returns:

New transaction cannot enlist in the specified transaction
coordinator

and there is a new event in the event viewer:

MS DTC is unable to communicate with MS DTC on a remote
system. MS DTC on the primary system established an RPC
binding with MS DTC on the secondary system. However, the
secondary system did not create the reverse RPC binding to
the primary MS DTC system before the timeout period
expired. Please ensure that there is network connectivity
between the two systems. Error
Specifics:d:\nt\com\complus\dtc\dtc\cm\src\cso.cpp:2007,
CmdLine: C:\WINDOWS\system32\msdtc.exe, Pid: 1188
No Callstack (0)

I have followed the recommendations of
http://support.microsoft.com/default.aspx?scid=kb;en-
us;329332&Product=winsvr2003
with partial success (it happens less often).

Any ideas would be appreciated. Thanks,

Mark



Relevant Pages

  • 2003 server connecting to SQL Server
    ... I am connecting to a SQL Server database from ASP pages. ... I copied the web site to a 2003 server and I'm still ... MS DTC is unable to communicate with MS DTC on a remote ...
    (microsoft.public.sqlserver.connect)
  • <App Name> is trying to create an object that is not registered, in procedure <Proc Name>
    ... anything about on Microsoft's web site. ... connecting from a VB 6 app using ADO and MDAC 2.8. ... Microsoft OLE DB Provider for SQL Server ... <App Name> is trying to create an object that is not ...
    (microsoft.public.sqlserver.connect)
  • Re: 1 ASP page multiple connection to SQL server
    ... It's one SQL Server with 5 diferent Query. ... Are you connecting to 5 sql servers? ... does the web site ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • RE: Management Point not available
    ... > configured the Default Web Site within IIS 6 to use port 8080. ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)