SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'My-Server' is unavailable.


Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'My-Server' is unavailable.

Author
Message
Sgar...
Sgar...
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 666
I tried following code in SQL2K8r2..... for getting login modes of Linked server's

code is absolutely correct. But when I tried to execute it gives error like...

Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'My-Server' is unavailable.

I tried by restarting DTC service.... but still same error persists.


code :
--------------------------------

DECLARE @srvname varchar(50)
create table #temp(name varchar(20),mode varchar(50))
create table #servtemp(servername nvarchar(50))
DECLARE @getsrvname CURSOR
--SET servername = [@srvname]
--Declare @servername nvarchar(50)

SET @getsrvname = CURSOR FOR SELECT name FROM master.sys.servers where is_linked <> 0 -- SET cursor statement
OPEN @getsrvname
FETCH NEXT
FROM @getsrvname INTO @srvname
WHILE @@FETCH_STATUS = 0

BEGIN
insert into #temp exec( '['+ @srvname +' ] .master.sys.xp_loginconfig [login mode]')
insert into #servtemp values(@srvname)
exec('select * from #servtemp,#temp')
truncate table #temp
FETCH NEXT
FROM @getsrvname INTO @srvname
END

CLOSE @getsrvname
DEALLOCATE @getsrvname


--drop table #servtemp
--drop table #temp

Sagar Sonawane
** Every DBA has his day!!Cool
Sgar...
Sgar...
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 666
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...

Please find attachement....

Sagar Sonawane
** Every DBA has his day!!Cool
Attachments
MSDTC.JPG (168 views, 31.00 KB)
Dev
Dev
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4640 Visits: 1602
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...


I am sorry but I didn't get you. You are facing some issue with Linked Server and you know the reason for that issue. Then why are you posting it here? Is it FYI post?
Sgar...
Sgar...
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 666
Dev @ +91 973 913 6683 (10/13/2011)
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...


I am sorry but I didn't get you. You are facing some issue with Linked Server and you know the reason for that issue. Then why are you posting it here? Is it FYI post?


I faced that issue...and after posting here.... I have resolved that issue... I thought to post the resolution for the problem here... so in case if anyone will have same problem will get a solution.... I do post here to only increase my knowledge...

Sagar Sonawane
** Every DBA has his day!!Cool
Dev
Dev
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4640 Visits: 1602
if anyone will have same problem will get a solution

Nice Thought... and this is what I meant by FYI (For Your Information) post :-D

I do post here to only increase my knowledge...

You are most welcome here..
sita.yeleswarapu
sita.yeleswarapu
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 68
hi

I'm too facing the same error

i'm running the below query from source server

INSERT INTO <source_tablename>
exec [destination server name].[master].[dbo].[xp_fixeddrives]


Msg 8501, Level 16, State 3, Line 1
MSDTC on server '<source server>' is unavailable.


I checked the linked server option and enable promotion of distribution transcation is true.

but still i'm getting error ..
please help me out in finding the solution.
sita.yeleswarapu
sita.yeleswarapu
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 68
I have enable my MSDTC services too..
but still unable to run the query

i have changed the MSTDC setting by checking allows remote client connection, and checking in-bound and out bound transaction.
but still i'm facing the error.

Any one could please provide me a information on this
sita.yeleswarapu
sita.yeleswarapu
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 68
I'm unable to view MSDTC setting which is installed on 2000 server.
I think , i have to go and re install the services.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search