• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

Liciense requied for SBS SQL

I am getting the following error in my sbs 2003 server.

event ID 136

The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.

I think this is because the conflict between Express and the version that comes with SBS i am not sure how to stop this error as should the liciense for the report services be included in SBS?
0
mredfelix
Asked:
mredfelix
  • 4
  • 3
1 Solution
 
ormerodrutterCommented:
Is your SBS the Premium edition?
0
 
mredfelixAuthor Commented:
yes it is
0
 
mredfelixAuthor Commented:
i have worked out what the problem is but  it has created another problem.

it looks like the administrator before me installed 2005 Express and the Enterprise evalutation.

now how do i remove the enterprise edition and make sure all the databases, users have been moved across and running off SQL EXPress 2005
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
mredfelixAuthor Commented:
If I remove SQL 2005 evaluation when express is on the machine will it effect it at all.
0
 
ormerodrutterCommented:
Databases running on SQL2005 Enterprise or Standard edition may not run in SQL Express. So it really depends on what kind of database it is and you have to check with the vendor if their databases will run on SQL Express. If they do run on Express then it is ok to remove the Enterprise edition. Remember to make a full backup beforehand.

Alternatively, since you are using SBS Premium it should come with SQL Standard edition (I am not sure if it is SQL2005 or SQL2000). Most databases that run on Enterprise should run on Standard too. So you can detach databases that are running on Ent and attach them to Standard.
0
 
mredfelixAuthor Commented:
ormerodrutter the databases that are being used are in express there are a few in enterprise but they are not being used.

yes your right standard comes with SQL 2000 however i was not involved in the setup i was just worried that Express may use some dll's etc which standard use and are removed when i uninstall enterprise. You don't think this will be the case?

0
 
ormerodrutterCommented:
You can always download SQL Express and install again - its free anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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