Friday, March 30, 2012

network error

Hello,
I get the following error:
Server: Msg 11, Level 16, State 1, Line 1
General network error. Check your network documentation.
Need help.
I have 2 sql server instances on two different machines.
Created a linked serve between SERVE1 and SERVER2.
Tried to run a select query using four-part-naming-convention from server1
to get the query results.
From Server1 ran the following query:
select * from servername2.datbasename.owner.tablename
got the following error message:
Server: Msg 11, Level 16, State 1, Line 1
General network error. Check your network documentation.
Need help to resolve this issue.
Don
Go into Enterprise Manager and click on the linked server. See if you can
see any of the tables. If not, you haven't got the connection setup
correctly. Take the parameters from the linked table and try to connect
with the same authentication in Query Analyzer. Does that work? I'm
assuming you can ping the other server? Also, if the second server is an
instance, let us know if you have "Hide Server" checked in the server
configuration on that server.
"Dony" <donb@.yahoo.com> wrote in message
news:enTc1PMtEHA.1216@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I get the following error:
> Server: Msg 11, Level 16, State 1, Line 1
> General network error. Check your network documentation.
>
> Need help.
> I have 2 sql server instances on two different machines.
> Created a linked serve between SERVE1 and SERVER2.
> Tried to run a select query using four-part-naming-convention from server1
> to get the query results.
> From Server1 ran the following query:
> select * from servername2.datbasename.owner.tablename
> got the following error message:
> Server: Msg 11, Level 16, State 1, Line 1
> General network error. Check your network documentation.
> Need help to resolve this issue.
> Don
>
>

No comments:

Post a Comment