SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 upgrade advisor 2005 not working
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/21/2010 :  09:02:29  Show Profile  Reply with Quote
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 - 01/21/2010 :  09:06:45  Show Profile  Reply with Quote
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!!!



Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 Posts

Posted - 01/21/2010 :  09:07:11  Show Profile  Visit jackv's Homepage  Reply with Quote
Are you using Windows Authentication? If so , try SQL Authentication, and let me know the result

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 Posts

Posted - 01/21/2010 :  09:14:18  Show Profile  Visit jackv's Homepage  Reply with Quote
is remote connections allowed checked ?

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/22/2010 :  02:26:09  Show Profile  Reply with Quote
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??
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/22/2010 :  07:27:49  Show Profile  Visit russell's Homepage  Reply with Quote
is remote registry service running on target machine?
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/23/2010 :  10:58:14  Show Profile  Reply with Quote
I will check and try again.

Thanks All.
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/25/2010 :  00:18:57  Show Profile  Reply with Quote
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.....



Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/25/2010 :  02:02:59  Show Profile  Reply with Quote
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???????
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/25/2010 :  02:08:52  Show Profile  Reply with Quote
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.
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 01/25/2010 :  13:12:49  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
Requested registry access is not allowed. (mscorlib)

Are you an administrator on that machine?
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/27/2010 :  09:56:32  Show Profile  Reply with Quote
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.
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 01/27/2010 :  17:02:51  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
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"
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/30/2010 :  12:58:45  Show Profile  Reply with Quote
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?
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 02/01/2010 :  14:29:01  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
Data Execution Prevention.
In the advanced options of system properties.
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 02/02/2010 :  02:52:33  Show Profile  Reply with Quote
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!


Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 02/02/2010 :  07:14:39  Show Profile  Reply with Quote
The problem has been resolved now.

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

Thanks All! :)
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 02/08/2010 :  11:41:40  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
Of coarse it was the simple thing.

Always the easy things first!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.47 seconds. Powered By: Snitz Forums 2000