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.
| Author |
Topic |
|
saleemMSMS
Starting Member
3 Posts |
 Posted - 2010-11-09 : 02:20:44
|
| hi everyone :)these are the detailsi have a computer at ip 192.168.0.55also, there is another server at ip 192.168.0.92 with default instance. (network name "SERVER14")i want to link that server with mine. so i tried the following1. i used the server type as sql server and the linked server name as the 192.168.0.92's network name. but things didn't go correct. the reason is i need to have a user defined name as my linked server name; not the actual network name of the server.2. then i tried to establish an SQL Native Client using ODBC data sources. the data source was successfully created named "MYLINK".and these are the settings i entered in the new linked server menu.Linked Server Name > a user defined name. (it is the same as the created Data Source Name "MYLINK")Provider name > the Created Data Source's NameData Source > the network name (the actual name) of the 192.168.0.92 server ("SERVER14")Provide String > Same as the Data Source ("SERVER14")and in mappings, i mapped the windows authentication to the sa account of the 192.168.0.92 server. but when i try to connect; i get the following errorcannot initialize the data source object of OLEDB provider "SQLNCLI" for linked server "MYLINK"OLEDB provider "SQLNCLI" for linked server "MYLINK" returned message "Invalid Connection string attribute"i tried OLEDB for SQL Server Driver too but things are not working.THE MOST IMPORTANT THING IN THIS SCENAREO IS THAT I NEED TO LINK THE SERVER NAMED "SERVER14" INTO MY LOCAL SQL SERVER WITH THE NAME "MYLINK" SO THAT THE IT CAN BE REFERED AS MYLINK.ADVENTUREWORKS.DBO.OBJECT_NAME INSTEAD OF SERVER14.ADVENTUREWORKS.DBO.OBJECT_NAMEplease help me. what am i doing wrong here ? is there any other approach to my requirement ?thank you very much in advance :) |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-11-12 : 16:56:20
|
| the provider string is incorrectit's a combination of the provider name and datasource--------------------keeping it simple... |
 |
|
|
|
|
|
the linked server question.