none
Sql server database not connected remotely

    Frage

  • Dear all,

    insert into [server1].[getit].dbo.TBL_test_numbers
    (
    callerid,uploadfilename
    )
    select CALLERID,UPLOAD_FILE_NAME from [server1].[getit].dbo.TBL_test2_NEW dn inner join
    [dataserver2].[getit].dbo.TBL_test3_Temp ct on TELEPHONE_NUMBER=CALLERID where status=0 or status=1

     above query is executing, getting below error.

    OLE DB provider "SQLNCLI" for linked server "dataserver2" returned message "Invalid authorization specification".
    Msg 7399, Level 16, State 1, Line 2
    The OLE DB provider "SQLNCLI" for linked server "dataserver2" reported an error. Authentication failed.
    Msg 7303, Level 16, State 1, Line 2
    Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "dataserver2".

    Note: dataserver2(64 bit server)

                     same query as executing another server successfully executed.

    insert into [server1].[getit].dbo.TBL_test_numbers
    (
    callerid,uploadfilename
    )
    select CALLERID,UPLOAD_FILE_NAME from [server1].[getit].dbo.TBL_test2_NEW dn inner join
    [dataserver3].[getit].dbo.TBL_test3_Temp ct on TELEPHONE_NUMBER=CALLERID where status=0 or status=1

    Note: dataserver3 (34 bit server).

    Can you pls help me to resolve this issue.

    Regards,

    Tamil


    • Bearbeitet Tamiltms Freitag, 21. Juni 2013 09:17
    Freitag, 21. Juni 2013 09:17

Alle Antworten

  • Hello Tamil,

    Where do you see a relation between your question and "Data Mining", the subject of this forum? You should post your question to a more related forum.

    Check the security settings of the linked server, seems they are not correct.


    Olaf Helper

    Blog Xing

    Freitag, 21. Juni 2013 09:27