Access is Denied in Upgrade Advisor

Hi all,

I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003.

One thing I need to fix before I upgrade is:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

SVCACCTREQ

I'm not sure what this means or what I need to do before I can upgrade.

Does anyone have a clue on this one.

Thanks,

David

Hi David,

The issue you posted is actually an error encountered while processing the rule (SVCACCTREQ). I'm wondering if the account you used to run Upgrade Advisor was a member of the local administrators group on the machine in question?

jeff.

|||

Thanks Jeff,

I am running the Upgrade Advisor remotely as the server does not have .NET 2.0 Framework installed.

The first time I got the error, I connected to SQL Server using TCP/IP logging on as sa.

I got the same result where I had a mapped drive to the remote server using a Domain Administrator logon and use Named Pipes to connect to SQL Server.

We now have access to a test server where I can install the .NET 2.0 Framework and run the Upgrade Advisor locally.

Hopefully this will resolve the problem.

David.

|||

Jeff, same here using SA (remote).

I also get "Attempted to perform an unauthorized operation" on NETPROTOCOL, MDACVERSION and few more.

\Ruud

|||

Is there anyway to use the Upgrade Advisor tool remotely avoiding the .net framework installation on sql server 200?

i got the following errors:

Attempted to perform an unauthorized operation.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

Gianfranco

|||Some of the rules executed by Upgrade Advisor require admin priviliages at the Operating System layer that won't be available when using SQL Authentication. I suspect the rules you are encountering these errors are those rules which require admin priviliages at the Operating System layer. The SA, or equivilant SQL account, does not have permission to perform the actions necessary for these rules to execute, thus the error you are seeing.|||

You should not need to install the .NET Framework on a remote install. All rules will use either a SQL Connection or WMI to perform the action requested by the rule. The .NET Framework is a requirement of the Upgrade Advisor tool itself, so only where you are running Upgrade Advisor do you need the .NET Framework.

There are additional requirements for the Upgrade Advisor client machine, such as OLAP Tools and the DTS client, so make sure you have those installed on the machine where you're Upgrade Advisor.

|||

I was trying to do the remote installation too and I got the same error too.

I was able to fix this by running Sql Server 2005 Upgrade Advisor on a machine that was on the same domain as the database server.

I was logged in as a user who had administrator rights on both machines. So when I ran Sql Server 2005 Upgrade Advisor I made it connect to the database server and to login using Windows Authentication.