RE: network error
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 10/20/04
- Next message: Shanthi: "Connectivity error on a table"
- Previous message: Mike Epprecht (SQL MVP): "RE: OS Error 121 - semaphone timeout period expired."
- In reply to: Dony: "network error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 20 Oct 2004 02:09:09 -0700
Hi
Check the destination server for login failures.
See if you can run a system stored procedure like sp_who2 against server2.
Regards
Mike
"Dony" wrote:
> 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
> >
> >
> >
> >
>
>
>
>
>
- Next message: Shanthi: "Connectivity error on a table"
- Previous message: Mike Epprecht (SQL MVP): "RE: OS Error 121 - semaphone timeout period expired."
- In reply to: Dony: "network error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
