
Random House Webster's Unabridged English Dictionary Webster's Revised Unabridged English Dictionary

CONNECTED - adjective Date: 1712 joined or linked together, having the parts or elements logically linked together, related by blood or ….More meanings of this word and English-Russian, Russian-English translations for the word «NOT SIMPLY CONNECTED» in dictionaries. I am now getting this error message when I try to view the Catalogs of the newly created linked server: What is interesting is that DB19 and DB21 are identical servers in our farm. I am also able, and have for quite some time, a registered instance in SSMS on the server I am creating the linked server on. the instance I am creating the linked server to is a SQL Server 2005 SP2 instance. sp_addlinkedserver = N 'DC:AUS02DB19', = N 'OLE DB for ODBC', = N 'MSDASQL', = N 'DRIVER= SERVER= UID=user PWD=pass ' Here is the code that I used as a template (and which is from a SS2K5 server that is working fine) ()Ĭannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "DC:AUS02DB21". Now when I try to open the Catalogs object under the newly created Linked Server, I get the following message each time I try to open it:įailed to retrieve data for this request. OLE DB provider "MSDASQL" for linked server "DC:AUS02DB21" returned message "General network error. OLE DB provider "MSDASQL" for linked server "DC:AUS02DB21" returned message "ConnectionOpen (PreLoginHandshake()).". "The test connection to the linked server failed."Īn exception occurred while executing a Transact-SQL statement or batch.

TITLE: Microsoft SQL Server Management Studio


It DID created the linked server BUT when it finished up it generated the following message: I scripted out (numerous times) a Link Server create statement for a SS2K5 server that is working great and then changed the server name in the script to reflect the new server name and executed it. It has numerous Linked Server to both SS2K and SS2K5 servera already in place and working great. I have a utility server that I am running SS2K5 SP2 w/ the latest patches.
