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
 SQL Server Administration (2008)
 linked server error

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2011-08-24 : 01:05:56
i was running a script and i m getting this error... Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "linkedserver name" kindly help me in this.


thanks
pramod

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-24 : 01:49:36
connect to server expand server objects-> linked servers-> right click on linked server and click test connection and see if it responds.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -