upgrade advisor 2005 not working

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

upgrade advisor 2005 not working

Author

Topic

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-21 : 09:02:29

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
------------------------------

Any fix for this???

Thanks in Advance.

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-21 : 09:06:45

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!!!

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-21 : 09:07:11

Are you using Windows Authentication? If so , try SQL Authentication, and let me know the result

Jack Vamvas
--------------------
http://www.ITjobfeed.com

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-21 : 09:14:18

is remote connections allowed checked ?

Jack Vamvas
--------------------
http://www.ITjobfeed.com

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-22 : 02:26:09

yes i beileve. This is what i have done.

Right click on My computer--> Properties --> Remote Tab --> Check Remote Assistance and Allow Remote users

Also, on the other system i have added my domain\system for allow users.

Is there anything i missed out??

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-22 : 07:27:49

is remote registry service running on target machine?

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-23 : 10:58:14

I will check and try again.

Thanks All.

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-25 : 00:18:57

Started the Remote registry service on remote machine.
allowed remote connection.
But still the Error Persists.

I tried to do is installed 2000 sql server on my machine and restored databases and ran the upgrade advisor against the databases.

Moving a step forward, am getting the below error.

"SQL BPA command like has encountered a problem and needs to close."

Please find the attached word document i followed.

What could be the problem????

I have downloaded "upgrade advisor 2005" from

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

Seeking for an urgent fix.....

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-25 : 02:02:59

Hi,

ONE MORE ERROR!!!!!!!

Unable to connect to server. Reason: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

But to my knowledge, the server is there.
the instance is there.
the tcp/ip , shared memory ptocols enabled

More, importantly i am able to connnect to 2000 instance from 2008 Sql Server Mgmt Studio.

dono what's wrong!

Can anyone figure out what the problem is???????

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-25 : 02:08:52

Tried to create a sample database on remote sqlq 2000 server thru 2008 ssms. it is working fine.

But why it is stopping thru Upgrade Advisor.

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2010-01-25 : 13:12:49

Requested registry access is not allowed. (mscorlib)

Are you an administrator on that machine?

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-27 : 09:56:32

I belong to admin group at Active directory level and i have added my user to allow remote connections on the other machine on which sql 2000 is running.

I think that shudn't be a problem.

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2010-01-27 : 17:02:51

there are occasions where depending on activew directory your permissions may not properly propagate.

The override, is to right click my comptuer, manage, local users and groups, groups, administrators, add your user name.

I recently have been having more instances where DEP was being triggered in all sorts of programs, from IE to SNMP services. Due to spyware infections.

"SQL BPA command like has encountered a problem and needs to close."
is similar to the error message that could result.

Other things, check your firewall, and possibly the Remote Registry servies. which is not the same as "Check Remote Assistance and Allow Remote users"

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-01-30 : 12:58:45

quote:

I recently have been having more instances where DEP was being triggered in all sorts of programs, from IE to SNMP services.

quote:

what is full form of DEP, IE?

I think IE is internet explorer but about DEP?

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2010-02-01 : 14:29:01

Data Execution Prevention.
In the advanced options of system properties.

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-02-02 : 02:52:33

Hi All,

Am able to connect to 2000 instance locally but am unable to connect to sql 2000 instance which is on network..

TITLE: Connect to Server
------------------------------
Cannot connect to MVENKATASHAM-3.
------------------------------
ADDITIONAL INFORMATION:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

I have clicked the above link
/*
Explanation
The SQL Server client cannot connect to the server. This error could occur because the firewall on the server has refused the connection.

User Action
Make sure that you have configured the firewall on the server instance of SQL Server to accept connections.
*/

The Same message am getting when am trying to connect through Management Studio to that machine.

This is what the configurations settings i have done. Please tell me if i missed out any.

Local machine on which 2008 and 2008 upgrade advisor is installed
----------------------------------------------------------------
1. Started the Remote Registry services on local in services.msc
2. Enabled TCp/IP and Shared Memory

Remote Server running SQL Server 2000
----------------------------------------
1. Started the Remote Registry services on local in services.msc
2. Enabled TCp/IP and Shared Memory
3.Enabled the Allow Remote connections on the system
4. Right click MyComputer-->Properties--> Remote tab--> check Allow users to connect remotely to this computer(i.emstsc)
5.Added my user by clicking Select Remote Users button. domain\username
6.Right click Computer-->Manage-->users and Groups--> Groups--> Administrators --> Added my domain user to the Admin group.
7.Ensure SQL Server 2000 is running but it is running as Local system Account/
8. Have added my domain user account in sql logins for Windows Auth
9. Created a login (Sql Auth) given system admin role for remote access.

Do i need to enable something in sql server 2000 through command line to Allow Remote connections?
How/where can i find the firewall settings in my system? what steps do i need to perform in the firewall?

to get the firewall settings ->> when to Start--Run--> "firewall.cpl"

I can find 3 tabs here.
General Tab, Exceptions Tab and Advanced Tab

In General tab,

Off is enabled but it is grayed out.

My Machine details
Windows XP Profession SP3

Thanks!

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-02-02 : 07:14:39

The problem has been resolved now.

On the remote machine, i switched off the firewall settings. Then it worked fine.!!!

Thanks All! :)

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2010-02-08 : 11:41:40

Of coarse it was the simple thing.

Always the easy things first!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources