Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot initialize the data source objects of oledb provider msdasql error 7399

Status
Not open for further replies.

tdrclan

Programmer
Sep 18, 2007
52
US
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>>

searching google did not give any answers.
Tim
 
Are O, T, and P all on the same domain and being accessed by the same user?

You've got questions and source code. We want both!
There's a whole lot of Irish in that one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top