Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Liciense requied for SBS SQL

Posted on 2008-10-06
7
Medium Priority
?
857 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

618 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