Solved

Liciense requied for SBS SQL

Posted on 2008-10-06
7
848 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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