Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NT AUTHORITY\SYSTEM error Expand / Collapse
Author
Message
Posted Monday, June 15, 2009 2:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:16 AM
Points: 2,840, Visits: 3,983
hi,

i am getting below error while exectuing a LINKED SERVER query

please help me



Executed as user: NT AUTHORITY\SYSTEM. The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "INDBA01test\DEV" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) OLE DB provider "SQLNCLI" for linked server "INDBA01test\DEV" returned message "The partner transaction manager has disabled its support for remote/network transactions.". [SQLSTATE 01000] (Error 7412). The step failed.



-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #734842
Posted Monday, June 15, 2009 3:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:30 AM
Points: 15, Visits: 162
was it previously working fine or is it a brand new setup?

have you checked this post? http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64
Post #734850
Posted Monday, June 15, 2009 4:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:16 AM
Points: 2,840, Visits: 3,983
No this is a new setup .

below is the query , whic is running fine while executing in mgmt studio

but i have put it in JOB , to perform it periodically

so when the job runs , it gives that error
-------------------------------------------------------
declare @SQLCmd varchar(100)
SET @SQLCmd = 'insert into ghi_prod.dbo.account_test SELECT TOP 1 * from mydba.ghi_prod.dbo.account '
EXEC(@SQLCmd) AT [mytesttest\DEV] <------linked server





-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #734882
Posted Monday, June 15, 2009 4:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:30 AM
Points: 15, Visits: 162
As first step I'd check the instructions detailed in the link i've posted earlier on.

Also, I'm not 100% sure, but I would look at security issues between the two linked servers: how did you configure the security mappings between the two servers? Also, I don't think that NT AUTHORITY\SYSTEM is a valid account on linked servers as it depends on the machine it's running on (that is, it is on both servers, but it's a "different" account on the two servers - I might be wrong here tho).

Try creating a new Active Directory account with limited privileges, grant it the access level you need on both servers and use that account for the login mapping: hopefully that should sort your issue.

As I said, I'm not 100% sure, but that's the path I would follow to sort this issue :P

Hope this helps, post again otherwise :)
Matt
Post #734886
Posted Monday, June 15, 2009 4:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:30 AM
Points: 15, Visits: 162
also, take a look here first: http://support.microsoft.com/kb/306212
Post #734888
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse