January 21, 2010 at 7:09 am
Hi,
When i am trying to connect to SQL 2000 instance located on different machine in the same domain thru SQL 2005 upgrade advisor , am getting the below error.
TITLE: Detect SQL Server Components
------------------------------
Upgrade Advisor could not detect SQL Server components on the server.
------------------------------
ADDITIONAL INFORMATION:
Requested registry access is not allowed. (mscorlib)
------------------------------
BUTTONS:
OK
------------------------------
For the first screen in upgrade advisor, i have given
Servername : <<MachineName>>/IPAddr
Selected database componets -->Next--> Specified Instance name as "MSSQLSERVER" as it is a default instance and provided sql server authentication as "sa" login and password and i am getting the above error!!!
Any fix for this???
Thanks in Advance.
January 24, 2010 at 10:34 pm
done the following from my side.
1. On the 2000 server start the remote registry windows service.
2. enabled the remote allow connections on the 2000 server machine
3. added my user name to allow to connect remote from my machine to 2000 sql server machine.
but still the error exists.
Please find the Error.doc as attachment.
October 11, 2011 at 9:55 am
This is because of the firewall issue, open the port 1433 and 1434 or you can check your port by typing netstat –an in CMD line.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply