OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification"

• aysegul

  Right there with Babe

  Points: 778

  More actions

  December 12, 2009 at 3:25 am

  #139981

  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,

  Can you help me?

  Kind Regards

  Ayşegül