Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Liciense requied for SBS SQL

Posted on 2008-10-06
7
Medium Priority
?
862 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

577 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