Problem Upgrading From SQL 2000 To SQL 2005

I have SQL 2000 with the latest SP that was installed with pretty much the
default settings as part of SBS 2000 Premium Edition.
I am using SQL to run Microsoft CRM 3.0 and want to upgrade to SQL 2005 to
take advantage of the Reporting Services.
When I try to upgrade to SQL 2005 I am getting the following message: "SQL
Server Setup cannot upgrade service ReportServer. SQL Server cannot run a
service account as a Local Service account or Network Service account on a
domain controller."
What do I need to do to get this upgrade to successfully complete?
Thanks.
Rick Bellefond
RB Data Services
www.rbdata.comHi Rick
Have you tried changing the service account for reporting services to a
domain account or localsystem?
Running the upgrade advisor before trying to upgrade may have shown this
error! It may be worthwhile running this.
John
"Rick" wrote:
> I have SQL 2000 with the latest SP that was installed with pretty much the
> default settings as part of SBS 2000 Premium Edition.
> I am using SQL to run Microsoft CRM 3.0 and want to upgrade to SQL 2005 to
> take advantage of the Reporting Services.
> When I try to upgrade to SQL 2005 I am getting the following message: "SQL
> Server Setup cannot upgrade service ReportServer. SQL Server cannot run a
> service account as a Local Service account or Network Service account on a
> domain controller."
> What do I need to do to get this upgrade to successfully complete?
> Thanks.
>
> Rick Bellefond
> RB Data Services
> www.rbdata.com|||Hi Rick
Usually that is because a DLL has not been correctly registered see
http://msdn2.microsoft.com/en-us/library/z2wd57es.aspx, if you know which DLL
this is you could try and re-register it using Regsvr32.
John
"Rick" wrote:
> Hi John,
> I knew I should have run the Upgrade Advisor first. :-)
> I went into services and changed the ReportServer service from a Network
> Service to localsystem and restarted it.
> I then ran the Upgrade Advisor and got the following error
> Analyze Analysis Service
> ActiveX component can't create object (DSO)
> Any idea as to how I fix that error?
> Thanks.
>
> Rick
>
> "John Bell" wrote:
> > Hi Rick
> >
> > Have you tried changing the service account for reporting services to a
> > domain account or localsystem?
> >
> > Running the upgrade advisor before trying to upgrade may have shown this
> > error! It may be worthwhile running this.
> >
> > John
> >
> > "Rick" wrote:
> >
> > > I have SQL 2000 with the latest SP that was installed with pretty much the
> > > default settings as part of SBS 2000 Premium Edition.
> > >
> > > I am using SQL to run Microsoft CRM 3.0 and want to upgrade to SQL 2005 to
> > > take advantage of the Reporting Services.
> > >
> > > When I try to upgrade to SQL 2005 I am getting the following message: "SQL
> > > Server Setup cannot upgrade service ReportServer. SQL Server cannot run a
> > > service account as a Local Service account or Network Service account on a
> > > domain controller."
> > >
> > > What do I need to do to get this upgrade to successfully complete?
> > >
> > > Thanks.
> > >
> > >
> > > Rick Bellefond
> > > RB Data Services
> > > www.rbdata.com