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 |
|
cas_o
Posting Yak Master
154 Posts |
 Posted - 2003-05-29 : 09:23:42
|
| Hi all,I have two SQl Servers W2k, one running MSSQL 7.0 the other running MSSQL 8.0I have added a linked server on my MSSQL 7.0 box to my MSSQL 8.0 box as follows:EXEC sp_addlinkedserver @server='<server_name>', @srvproduct='SQL Server'GOas per BOL. server_name is the NETbios name of the server and WINS/DNS are resolving the IP address correctly and both servers are on the same subnet.I then connect to MSSQL 7.0 box with Query analyser (8.0) with WindowsNT authentication (I have a login on both boxes and my understanding from BOL is, by default - having executed sp_addlinked server as I have above - any connection throught the linked server will use the login I am currently connected with) However, if i try and execute a select statement along these lines:select * from <server_name>.<database_name>.dbo.<table_name>I receive the following error:Server: Msg 11, Level 16, State 1, Line 1General network error. Check your network documentation.Has anyone experienced anuthing like this? if so can you give me any clues on how you solved it?;-] |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 13:08:32
|
| Have you run sp_addlinkedsrvlogin yet? If not, please see BOL for the details.Tara |
 |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2003-05-30 : 05:21:07
|
| I have used sp_addlinkedsrvlogin but to no avail. It shouldn't be necessary anyway because the linked server is configured to use the currently connected security context. Both servers have the same windowsNT login, so if I connect to server1 with this login, it should use the same login to connect to server2. I have tried MS KB for this error but there is nothing that seems relevant to my situation other than authentication. But I will find the cause, and when I do, will post it here!;-] |
|
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2003-06-03 : 04:28:12
|
| OK.I ran a trace for logins/failed logins only on the linked SQL 8.0 box and when I attempted to execute a query on it from the SQL 7.0 box there was nothing, so my 7.0 box isn't even reaching the 8.0 box let alone loging in.I suspect it's to do wich MDAC which is 2.5 sp3 on the 7.0 box, older versions of MDAC running on my old NT 4.0 servers running SQL 7.0 have no trouble connecting to SQL 8.0. So there ya go backwards compatability is never 100% one of those things I guess !!;-] |
|
|
|
|
|
|
|
|
SQL 7.0 to 8.0 Linked Servers