RE: Enforce distributed transactions (MTS) setting always cleared

Hello,

You could try the following statements:

sp_configure 'remote proc trans', 1
reconfigure with override


Per your question, network DTC is only available to install in Win2003. In
Win2000, it is enabled by default. You could try to reinstall MSDTC to test
the situation

c:\winnt\system32\dtcsetup.exe

Also, please check in event log to see if there is any related errors.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

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.


.

Relevant Pages

  • Re: Restoring from MDF and LDF
    ... reconfigure with override ... where name = 'BADDBNAME' ... Start database in emergency mode ...
    (microsoft.public.sqlserver.server)
  • Re: Xorg Configuration in Etch
    ... which dpkg-reconfigure refuses to update.) ... Except that Bill Jones just told me where I can download a ... reconfigure dialog seems normal, but the new file is not update. ... It is a fresh install. ...
    (Debian-User)
  • Re: sp_configure (RECONFIGURE)
    ... Sounds like you have the option "allow updates" enabled and are on SQL 2005. ... "with override". ... You should now be able to use reconfigure without encountering errors. ... system administrator. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Replication errors - vicious circle
    ... reconfigure with override ... > When I try to create a transactional publication, ... > does not have a primary key column. ...
    (microsoft.public.sqlserver.replication)
  • Re: qpopper / portinstall / custom install
    ... I have added the information in my pkgtools.conf file to override ... > the install options and not try to install the apop file? ... The port isn't designed to support building without apop. ... wouldn't be terribly hard to fix; the port maintainer might even ...
    (comp.unix.bsd.freebsd.misc)