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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2006-12-07 : 15:01:12
|
| Hi all,I have problem regarding linked server between one SQL Server 2000 Standard Ed. SP4 (default instance) and SQL Server 2005 Developer Ed SP1 (named instance on same machine). I created it with:- Name: EXAMPLE- option Other data source: Microsoft OLE DB Provider for SQL Server- Product name: '.'- Data source: ServerName\InstanceName- security: remote login with password- Server Options: dataAccess, RPC, RPC Out, User Remote Collation - checked.But, when try to perform 'select * from EXAMPLE.DBName.dbo.TableName I've got messagge:"Server: Msg 14, Level 16, State 1, Line 1Invalid connection."I've got the same linked server in cluster environment where both servers are developer edition (first is SQL 2000 and the second is SQL 2005). And it works.What could be a problems ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-07 : 15:15:15
|
| Add an alias using Client Network Utility on the database server. Alias would point to name of the linked server and would reference the ServerName\InstanceName in it.Tara Kizer |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-07 : 15:37:53
|
| Welcome back, Tara!Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Linked server