none
Sql server database not connected remotely

    Question

  • 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


    • Edited by Tamiltms Friday, June 21, 2013 9:17 AM
    Friday, June 21, 2013 9:17 AM

All replies

  • 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

    Friday, June 21, 2013 9:27 AM