I have an error in SQL Server Error log
Failed to obtain TransactionDispenserInterface:
Result Code = 0x8004d01b
I could not find any information on this?

Does anyone have any idea how to tacke with it?

By the way
I have problem to log on to SQL server using Enterprise Manager.
It stops with 'checking security ....' while query analizer connect easily?

Report this post to a moderator

Krzysiek

The message that you have mentioned in your message comes in when the MSDTC
service has not been started at the SQL Server service starts. If you start
MSDTC (Microsoft Distributed Transaction Coordinator) service before
starting SQL Server, the error goes away.

The problem that you are having with Enterprise Manager is most likely not
related to the TransactionDispenserInterface message.

Thank you for using Microsoft Newsgroups

Pankaj Agarwal,
Microsoft SQL Server Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure ! For more info visit http://www.microsoft.com/security
Please reply to newsgroups only.

Report this post to a moderator