I tried creating an alias to the server to get it to connect to analyze the server but it will not recognize the SQL 2000 server as a valid server to analyze. I can use the alias to connect in EM or SSMS. Any ideas? The server is not clustered and is at SP4. I've connected to several others in my environment but this one is causing me grief!
Thanks,
Linda
After trying several other things, insuing I had the correct permissions on the destination server, one issue was discovered and that was I had permissions on the instance of SQL server I wanted to look at but not the defautl. Adding me did not fix the problem.
The fix actually came using an alias for the full default instance name and not using the "detect" button on the server entry screen. The instance name also had to be manually typed in. This worked after setting up an alias to the full instance name and not just the server name for the default instance.
