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 go to the pull-down, nor does it recognize it when I key in the instance name.
We are running on a Windows Cluster and the cluster servers are attached to a SAN.
Is the cluster/SAN 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 in a cluster/SAN environment?
If you can provide any information or guidance, I would greatly appreciate it.
Thanks in advance!