INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...keep up the good work with this forum, I think this is the best one around. ...you actually try to help people learn for themselves. ...I commend you on providing a very good, open learning atmosphere, where usually egos are left behind..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Setup and Administration Forum

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

Read More Threads Like This One

tdrclan (Programmer)

25 Jul 12 15:15

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

Qik3Coder (Programmer)

30 Jul 12 17:57

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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Setup and Administration