SQL Server Performance

Enterprise Manager

Discussion in 'SQL Server DTS-Related Questions' started by jrezucha, Feb 23, 2007.

  1. jrezucha New Member

    Hi sql'ers,

    We have 2 sql servers, a main and a backup. from the main box I'm trying to add the backup in the enterprise manager, but keep getting errors like server not found, with name or time out with ip.

    Now from the backup box I have successfully added both servers to enterprise manager, by both name and ip.

    why would the backup recognize the main, but not visa versa?

  2. jrezucha New Member

    both boxes are running sql server 2000 under windows advanced server 2000.
  3. MohammedU New Member

    Are you ping the backup server from main?

  4. satya Moderator

    Go through this KBAhttp://support.microsoft.com/kb/328306 and resolve it.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. jrezucha New Member

    I can ping, I can ftp, I can even map drivers across servers.

    Some Event viewer error:
    The session setup to the Windows NT or Windows 2000 Domain Controller \ATMSERVER.ATM.COM for the domain ATM is not responsive. The current RPC call from Netlogon on \ATMBACKUP to \ATMSERVER.ATM.COM has been cancelled.

    The master browser has received a server announcement from the computer ATMSERVER that believes that it is the master browser for the domain on transport NetBT_Tcpip_{1E97E444-D95C-4120. The master browser is stopping or an election is being forced.

    Not sure if these are related to my problem, but I appreciate everyone's help.
  6. MohammedU New Member

    Check the article mentioned by Satya...<br />Check if there is any alias created in client network utility...<br />Try using different protocols through QA.<br /><br />Ex: named pipes: np<img src='/community/emoticons/emotion-7.gif' alt=':S' />ervernameinstancename<br /> Tcp/p: tcp<img src='/community/emoticons/emotion-7.gif' alt=':s' />ervernameinstancename<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com

Share This Page