Reporting Services 2005 Error "The Database Engine instance you selected is not valid for this edition of Reporting Services."

Error "The Database Engine instance you selected is not valid for this edition of Reporting Services." when trying to connect to an MSSQL 2000 datasource from Reporting Services 2005 using MSSQL 2005 Workgroup Edition.

I have Reporting Services running on a named instance of MSSQL 2005 Workgroup Edition.  I am trying to use a data source located which is a SQL2000 database.  This database is the default instance on the same server.

My suspicion is that Workgroup Edition of MSSQL 2005 will not allow remote databases and considers a different instance to be remote.

Is this the case or should I be able to access the local 2000 databases from Reporting Services 2005 using the Workgroup Edition?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ted BouskillSenior Software DeveloperCommented:
You are correct, another instance of SQL (even on the same box) is considered remote.  You should consider using a 'Linked Server'  That would allow the SQL 2000 databases to remain where they are but allow you to access them directly through SQL 2005.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
steverey443Author Commented:
Thanks for the confirmation.  I'm accepting your answer but we just mounted the 2000 database on 2005 and are using it there for everything.
Ted BouskillSenior Software DeveloperCommented:
Ah, I assumed you had applications linked to the other instance.  Yes, detaching and reattaching is a very easy way to go.  Cheers.
steverey443Author Commented:
Hi tedbilly,

We did but have an application linked to it but it's a web app.  Changing one line in the web.config seemed easier than anything else.  Thanks for the workaround though.  In another situation that would have been really handy.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.