?
Solved

Liciense requied for SBS SQL

Posted on 2008-10-06
7
Medium Priority
?
853 Views
Last Modified: 2012-08-14
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
Comment
Question by:mredfelix
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 23

Expert Comment

by:ormerodrutter
ID: 22648628
Is your SBS the Premium edition?
0
 
LVL 5

Author Comment

by:mredfelix
ID: 22648743
yes it is
0
 
LVL 5

Author Comment

by:mredfelix
ID: 22651189
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 5

Author Comment

by:mredfelix
ID: 22667112
If I remove SQL 2005 evaluation when express is on the machine will it effect it at all.
0
 
LVL 23

Accepted Solution

by:
ormerodrutter earned 2000 total points
ID: 22667210
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
 
LVL 5

Author Comment

by:mredfelix
ID: 22668382
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
 
LVL 23

Expert Comment

by:ormerodrutter
ID: 22668455
You can always download SQL Express and install again - its free anyway.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question