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 |
|
nsteiner
Starting Member
13 Posts |
 Posted - 2001-11-19 : 09:35:30
|
| Platform: NT4SQL Server: 7Problem: Can't connect to linked server (also SQL7) - Error 11: General network errorHello,I have created a linked server from a local SQL Server to a remote SQL Server not on our network. I set up the DSN, and tested the connection, and it worked. So, I know the DSN is correct.I set up the linked server two separate times: once using Enterprise Manager, the other time using sp_addlinkedserver and the like. Both times when I go to Enterprise Manager to view the tables of the linked server, the console "hangs" for a while, and then returns the following error:Error 11: General network error. Check your network documentation.Has anyone recevied this error? If so, what solution(s) did you use?Thanks for the information.Nate==================================================Forced into becoming a SQL Guru |
|
|
RocketScientist
Official SQLTeam Chef
85 Posts |
Posted - 2001-11-28 : 17:18:01
|
| I'd suggest that you may want to check your client configuration on the server and make sure it's using something like TCP/IP Sockets instead of named pipes or RPC. Named Pipes and RPC connections attempt to establish an NTLM security context between boxes, which will work fine when it's you doing it, but it won't work if your SQL Server Service account tries to do it unless you've already configured for that.--rs |
 |
|
|
|
|
|
Error 11: General network error occured . . .