SQL Server 2005 Upgrade Advisor in a cluster environment

• trigonom

  Mr or Mrs. 500

  Points: 523

  More actions

  December 22, 2008 at 9:00 am

  #383624

  I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages.

  Even though SQL Server 2000 is up and running, it does not recognize our instance when I click the Detect button in the wizard, nor does it recognize it when I key in the instance name.

  We are running on a Windows Cluster. It worked fine when I tested it on a stand-alone server.

  Is the cluster environment the reason it cannot detect the instance?

  Is there a trick or a different set of procedures to follow when installing and running the tool on a cluster?

  If you can provide any information or guidance, I would greatly appreciate it.

  Thanks in advance!

  Mike Trigonoplos

  Smithsonian Institution

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  December 22, 2008 at 12:08 pm

  #916305

  Try putting in an alias...I believe that it only looks for items on the default ports

  ---

  
  Shamless self promotion - read my blog http://sirsql.net