Monday, March 19, 2012

servers

I have two servers running SQL Server 2000 SP3 and SP4. The one running SP4
was created recently by restoring all the system and user databases from
another server which has now been retired. Now I have both the servers linked
from the other server and they both show up in the Enterprise Manager.
However, I can only access the server running SP4 from the server running
SP3, not vice versa. It gives an error:
Server: Msg 17, Level 16, State 1, Line 2
SQL Server does not exist or access denied.
Any insight will be greatly appreciated. Thanks.Are you able to ping old server from the new one?
Manu
"sharman" wrote:
> I have two servers running SQL Server 2000 SP3 and SP4. The one running SP4
> was created recently by restoring all the system and user databases from
> another server which has now been retired. Now I have both the servers linked
> from the other server and they both show up in the Enterprise Manager.
> However, I can only access the server running SP4 from the server running
> SP3, not vice versa. It gives an error:
> Server: Msg 17, Level 16, State 1, Line 2
> SQL Server does not exist or access denied.
> Any insight will be greatly appreciated. Thanks.

No comments:

Post a Comment