[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 896
  • Last Modified:

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?
0
steverey443
Asked:
steverey443
  • 2
  • 2
1 Solution
 
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.
0
 
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.
0
 
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.
0
 
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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now