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

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification" Expand / Collapse
Author
Message
Posted Saturday, December 12, 2009 3:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, March 04, 2011 1:09 AM
Points: 56, Visits: 101
Hi All,

I try to write a trigger which is updated a table in an other Server and Database. I use OPENDATASOURCE for this.But I don't know the correct syntax for it.
INSERT INTO OPENDATASOURCE('SQLOLEDB','Data Source=(local)').[DataBase].[dbo].[InsertedTable]([col1],[col2])
When I executed the script above,I taken an error below,

[color=OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "(null)" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "(null)".][/color]

Can you help me?

Kind Regards

Ayşegül


Post #833313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse