I have an instance of SQL 2005 on a Windows 2003 server that I want to analyze using Upgrade Advisor. I can access SQL Server remotely via SSMS, so I assume necessary ports are open & user privileges enabled. However, Upgrade Advisor gives me the following error:
===================================
Upgrade Advisor could not detect SQL Server components on the server. Please check if current user has the privilege to access target server's registry, and if the Remote Registry service in target server is started.
===================================
Requested registry access is not allowed. (mscorlib)
Program Location:
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource) at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) at Microsoft.Win32.RegistryKey.OpenSubKey(String name) at Microsoft.SqlServer.UpgradeAdvisor.SqlDetection.GetClusterInfo() at Microsoft.SqlServer.UpgradeAdvisor.SqlDetection.DetectComponents() at Microsoft.SqlServer.UpgradeAdvisor.FormDetectComponents.Detect()