NT AUTHORITY\SYSTEM error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » NT AUTHORITY\SYSTEM error

NT AUTHORITY\SYSTEM error

Rate Topic

Display Mode

Topic Options

Author

Message

Bhuvnesh

Posted Monday, June 15, 2009 2:57 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #734842

mattedue

Posted Monday, June 15, 2009 3:31 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 15, Visits: 161

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

Bhuvnesh

Posted Monday, June 15, 2009 4:26 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #734882

mattedue

Posted Monday, June 15, 2009 4:39 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 15, Visits: 161

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

mattedue

Posted Monday, June 15, 2009 4:46 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 15, Visits: 161

also, take a look here first: http://support.microsoft.com/kb/306212

Post #734888

« Prev Topic | Next Topic »

Permissions