Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Cannot initialize the data source objects of oledb

Author  Topic  tross Starting Member 20 Posts Posted - 2012-07-26 : 16:12:20 Cannot initialize the data source objects of oledb provider msdasql error 7399 I have 3 SQL servers, Server O - os 2003 – sql ver Microsoft SQL Server 2008 (SP3) - 10.0.5500. (Build 3790: Service Pack 2) Server T - os 2003 -- Microsoft SQL Server 2000 - 8.00. (Build 3790: Service Pack 2) Server P - os 2003 -- Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Build 3790: Service Pack 2) I can select data from servers Server T from server P using a Linked server and an odbc connection but I can not get Server O to connect to Server T. ( using the same manner) (we are trying to move the database from server P to server O. I get the following error when I try to open the tables in the link server on server O. <<Failed to retrieve data for this request. The ole db provider msdasql for linked server “server T” reported an error authentication failed Cannot initialize the data source objects of oledb provider msdasql … sql error 7399>> Tim