[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]IT'S WORKING[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks...
I can only use DTCTester from the Web server to the SQL Server. It creates an ODBC connection to the sql server and tests it. Here is the error...
Okay - here is what I know. There are multiple NICs on the SQL Server. They are configured as a failsafe (a single nic). We reconfigured them so...
I downloaded the DTCtester tool and utilized it. It came back with the error messages. I forwarded the error messages to my Network manager. I...
1. MSDTC is running on both systems. 2. I logged into the web server (NC-37350-APP10) and pinged the SQL Server (NC-37350-APP09). The ping was...
I just did an sp_helpserver on both the old server and new server. The old server has both the SQL server AND the Web server listed. The SQL server...
I THINK I'M GOING CRAZY. Okay, the "Distributed Transaction" worked as long as I used the Commit Transaction at the end of the SQL Statement. Since...
No, the server was built from scratch without a ghost image. Now, I am able to perform the transaction: USE pubs GO BEGIN DISTRIBUTED TRANSACTION...
We have already tried to rebuild the MSDTC per the article you referenced.
Tried the last post. It still doesn't work. I'm at a loss. I'm going to reload SQL Server 7.0 and see what happens.
The MSDTC is running on both servers. The web server runs fine when it points to my old SQL Server. The web server doesn't have SQL server loaded....
I'm not sure what's going on. I have a single SQL Server that a web app server talks to. I do not have multiple SQL Servers that work together....
I am also getting this error in my error log. *modMTSAppDO.GetConnection - Microsoft OLE DB Provider for SQL Server Line #: 114 error '8004d01c'...
I am still having issues. I read on Technet to download a program called DTCPing on both systems. I did so and tried it. It stated that both...
I'M AN IDIOT I have solved the problem. When I moved the DTS's from the old server, I forgot to change the connections within the DTS. They were...
I have just moved several SQL Server databases from a SQL Server 7.0 with NT OS to a SQL Server 7.0 with Windows 2000 OS. Each of these databases...
The SQL agent is using Window NT authentication.
I have several logins already in the db. I use a mix. How do I check the account which is being used to run SQL Server Agent?
I have just migrated a db from one SQL Server to another. Everything seems to work fine. All of my DTS's work perfectly on the new system, however...
Yes, that seemed to work fine. It will just be time consuming opening every single DTS and changing the connection to the new server, but at least...
Separate names with a comma.
