Re: Network transactions not allowed

Hello Jan,

Since a machine is in workgroup, you need to set authentication to "None"
in addition to TurnOffRpcSecurity settings

"No Authentication Required" means that the MSDTC communication on the
network can use non-authenticated and non-encrypted communication, if the
attempts fail to start secure communication

http://blogs.msdn.com/florinlazar/archive/2004/03/02/82916.aspx

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.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469

Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: Jan Eliasen <eliasen@xxxxxxxxxxxxx>
Subject: Re: Network transactions not allowed
Date: Thu, 16 Feb 2006 13:43:45 +0100
Message-ID: <oes8v11dj1p4pjoqk90kcl39rsso3h7mho@xxxxxxx>
References: <d6f6v1pph2beupfe4uaraet3e43ug933sd@xxxxxxx>
<QvAKC5pMGHA.668@xxxxxxxxxxxxxxxxxxxxx>
X-Newsreader: Forte Free Agent 3.1/32.783
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.sqlserver.connect
NNTP-Posting-Host: 194.192.110.10
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:46916
X-Tomcat-NG: microsoft.public.sqlserver.connect

On Thu, 16 Feb 2006 02:11:10 GMT, petery@xxxxxxxxxxxxxxxxxxxx (Peter
Yang [MSFT]) wrote:

This issue can occur if the following registry key values on the SQL 2005
servers are not set to 1:

HKey_Local_Machine\Software\Microsoft\MSDTC\Security\NetworkDTCAccess
NetworkDTCAccessAdmin
NetworkDTCAccessTransactions

I suggest that you check this and restart DTC service on both servers to
test. Moreover, please add the TurnOffRpcSecurity registry by referring
to
the following article to isolate the issue:

839187 You receive an "A Microsoft Distributed Transaction Coordinator
problem
http://support.microsoft.com/?id=839187

The registry keys you mentioned weren't set to 1, so now they are.
Also, I have turned off RpcSecurity, as you suggested.

This has just lead to another problem, though. Ig got me a bit
further, but now I get this error instead:
http://www.eliasen.dk/biztalk/newdtcerror.jpg

Also, I have included the following articles for your reference:

293799 How To Use DTCTester Tool
http://support.microsoft.com/?id=293799

I have downloaded and tried the dtctester tool, and here is the
result: http://www.eliasen.dk/biztalk/dtc_error.jpg

I suggest that you test on different SQL 2005/2000 servers if possible to
make sure this issue is related to this specific server.
The computer with SQL Server 2005 is running in domain A, and the
computer I am trying to connect to the SQL Server 2005 from is in
workgroup mode. Does this change anything?

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@xxxxxxxxxx


.

Relevant Pages

  • Re: Slow Logon related to groups - Update!
    ... If you use a 1-GB network adapter, ... non-Windows NTP server in Windows Server 2003 ... Microsoft CSS Online Newsgroup Support ... Group Policy processing aborted. ...
    (microsoft.public.windows.server.sbs)
  • Re: Application Hang
    ... provide free email support, sorry. ... >> Windows XP Pro system on a network with Celeron CPU (small cpu since ... >> it works as a so called printer server as well). ... >> The system is running a printer which is shared by the whole network, ...
    (microsoft.public.windowsxp.general)
  • Re: Good XP Domain Admin book?
    ... >>> Fucking IT nerds are only interested in the technology. ... An IT network of the size they have now will support them perfectly ... Unix server based network will suffice and provide them with all the ...
    (uk.rec.motorcycles)
  • Error logs after Win2k3 gets loadet
    ... I have a server which i recetly upgradet to win2k3 Enterprice Edition. ... My fist thout was that the network drivers are not loadet properly ore the ... see Help and Support Center at ... whether it is receiving broadcast traffic in an unteamed configuration. ...
    (microsoft.public.windows.server.networking)
  • Re: Server 2003 or XP for small LAN?
    ... > you will lose approximately one man equivalent of your staff to server ... As a consultant, I'm a one-woman show ... The company owner has network documentation & the admin credentials are ... I can do a lot of support remotely, ...
    (microsoft.public.windows.server.sbs)