September 13, 2013 at 10:26 am
Does your other transaction or SP working fine with same linked server .
September 13, 2013 at 10:49 am
No it is not.
I have also tried to execute other sp using same linked server but it is giving me same error.
September 13, 2013 at 10:59 am
I tried it like
Inser into #tmp
Exec linkedserver.db.dbo.mysp
Then it is giving me error but when I directly run following statement then it gives me output
linkedserver.db.dbo.mysp
September 13, 2013 at 3:33 pm
What sort of environment is this? Are both computers in the same domain? Do you only have a workgroup?
Getting MSDTC to work when you don't have the trust from a domain can be very difficult. I have been successful in my workgroup at home, by have the same name for the service accounts for the DTC service with the same password.
On SQL 2008 there is a server option to turn off promotion to disitributed transaction, but alas it is not available in SQL 2005.
By the way, this forum is intended for the most recent release of SQL Server, SQL 2014, currently in beta.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 17, 2013 at 5:34 am
I have one server in domain and another is in workgroup.
The one which is in Domain on that server i am executing the query and the procedure is on server which is in work group environment.
September 17, 2013 at 3:06 pm
That sounds indeed like a difficult case. I don't know enough about Windows to say whether this can be solved and how. And MSDTC is a Windows component.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 17, 2013 at 4:09 pm
Do you have RPC enabled for that linked server, server options?
September 20, 2013 at 2:26 am
Thanks for your reply,
My issue got solved ,I just updated my host file from drives\etc folder,
I added IP address and host name into the file in both server. :-):-):-)
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply