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

SQL Server express linked server error Expand / Collapse
Author
Message
Posted Thursday, December 29, 2011 1:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 29, 2011 2:58 AM
Points: 1, Visits: 7
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
Post #1227677
Posted Friday, May 11, 2012 3:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:07 AM
Points: 16, Visits: 35
Hi,
I guess we dont have the Oledb Driver support for 64-bit machine
Post #1298431
Posted Friday, May 11, 2012 3:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 1,315, Visits: 2,541
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
Post #1298434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse