Distributed Transaction Error

I have two SQL Servers (Standard), one running on Windows Server 2003 sp1,
and the other on Windows 2000 sp4. Both are SQL Server sp4.
When I design a view on the 2003 machine, using a linked server (Win2k
system), I can get results by running the view. However, when I try to save
it, I get "The operation could not be performed because the OLE DB provider
'SQLOLEDB was unable to begin a distributed transaction', and 'OLE/DB
provider returned message: New transaction cannot enlist in the specified
transaction coordinator' messages.
I followed the instructions in KB816701, but this did not solve the problem.
There was no option on the Win2k system to set up Application Server: Enable
network DTC access.
Both systems have the Distributed Transaction Coordinator service running.
It seems strange that I could run the unsaved view, but not save it from the
designer. However, creating it via Create View does work, i.e. creating the
view and saving it.
Any assistance would be greatly appreciated.
Thanks,
TomT
Hello,
The following articles are for your reference:
306212 INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
827805 MSDTC fails to mutually authenticate when computers do not run in the
http://support.microsoft.com/?id=827805
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sophie,
Thanks for your response. However, I think there may be an issue between the
two platforms (Win2k and 2003). I had been planning to upgrade the Win2k
system to 2003, and did so today.
Once that process was completed, the issue I encountered went away. I.e., a
view created in the designer on one server using a linked server table, can
now be saved - no error messages.
Thanks,
TomT
"Sophie Guo [MSFT]" wrote:

> Hello,
> The following articles are for your reference:
> 306212 INF: Troubleshooting Linked Server Error 7391
> http://support.microsoft.com/?id=306212
> 827805 MSDTC fails to mutually authenticate when computers do not run in the
> http://support.microsoft.com/?id=827805
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>