sql server connect: Hi there,

We have two physical sites - A and B - and each has its own Domain. Within
site A's domain, we created a link server and everything works just fine. We
can call store procedures from one database to another database. We can also
insert store procedure results into a temp table and life is good at Site A.

At Site B however, we can execute a store procedure at Site A by crossing
the domain using linked server but we can't insert the result into temp table
or any user created table. We are getting Server: Msg 7391 unable to begin a
distributed transaction error.

I did a search on Google and find the following posting very similar to what
we experienced. We can call the store procedure from Site B but can't insert
the result. The posting doesn't mention about crossing two different domains
however.
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/edb3547ae24b0a71/db934b5757459ab3?lnk=st&q=Msg+7391%2C+Level+16%2C+State+1%2C+Procedure+The+operation+could+not+be+performed+because+the+OLE+DB+provider+%27SQLOLEDB%27+was+unable+to+begin+a+distributed+transaction.&rnum=9&hl=en#db934b5757459ab3

We have Windows 2000 server and SQL 2000. So the following link doesn't
apply to us: http://support.microsoft.com/kb/839279

Any suggestions? Could you please help?

Thanks.

Abel

Hello Abel,

The MSDTC services is also installed in the Windows 2000 server.

Here, I would like also provide some articles for you to troubleshoot this
issue:

329332 You receive error 7391 when you run a distributed transaction
against a linked server in SQL Server 2000 on a computer that is running
Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;EN-US;329332

306212 How to troubleshoot error 7391 that occurs when you use a linked
server in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306212


Hope it will be helpful for you.

Sincerely,

Wei Lu
Microsoft Online Community 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.

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community 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.