SQL Server express linked server error

  • Hi experts,

    I am testing the connection between 2 SQL server express 2008 instances: one on win7 32bit the other win7 64bit. Windows authentication, same domain. The user is th edb owner on both instances.

    Error about SQLNCLI10

    OLEDB provider ... authentication failed

    Cannot initialize the data source object...

    ...Invalid authorization specification

    Your help would be much appreciated

    Thank you

    justoti

  • Hi,

    I guess we dont have the Oledb Driver support for 64-bit machine

  • justoti (12/29/2011)


    Hi experts,

    I am testing the connection between 2 SQL server express 2008 instances: one on win7 32bit the other win7 64bit. Windows authentication, same domain. The user is th edb owner on both instances.

    Error about SQLNCLI10

    OLEDB provider ... authentication failed

    Cannot initialize the data source object...

    ...Invalid authorization specification

    Your help would be much appreciated

    Thank you

    justoti

    When do you get this error?


    Sujeet Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply