I am running a workstation running XP Pro (SP 3) and a server running Server 2003 Standard with SQL Server 2005. I have a VB6 app on the workstation that connects to SQL to retrieve and modify data. When the app modify's small amounts of data (10-20 characters in one or 2 columns) in certain tables, it works great. There is one table that has a column with data about a page or 2 long (200-300 characters). The app can read it, but when the data is modified and the user tries to save the changes back to the SQL DB, it throws the attached error:
Object Error 278533
MSDTC on server <servername\instance name> is unavaible.
I've googled this error and tried the following things with now improvment:
- Made sure the Distributed Transaction Coordinator service was started on both the SQL server and workatation.
- Went into Component Services and made sure the MSDTC was configured to allow network access, with NO AUTHENTICATION REQUIRED.
- I verified the SQL login we were using in our connection string had read & write permissions.to the DB.
- I rebooted both the server and workstation.
I don't know where to go next because I'm not sure what is causing this issue.