0

Initially, I have installed Enterprise Evaluation Edition and then we have installed licensed version Standard Edition 2017.

enter image description here

All our apps using SQLSTANDARD instance and backup maintenance jobs were running fine.

Suddenly, I have found that the jobs are failing with this error,

Integration Services evaluation period has expired

I ran,

SELECT * FROM msdb.dbo.syssubsystems

and it returns C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTExec.exe

I have also changed registry,

enter image description here

But still same error. The maintenance jobs created from licensed Standard Edition version.

I have tired of this and switch it to use https://ola.hallengren.com/

Improve this question
8
  • Have you completely uninstalled the Enterprise instance?
    – Mike Petri
    Commented Jan 19 at 17:27
  • No. Does this required?
    – Imran Qadir Baksh - Baloch
    Commented Jan 19 at 19:06
  • If you believe you have migrated everything to Standard, it would be the next logical choice to eliminate potential causes for conflict; especially with the issue you're experiencing. If it were me, I'd remove the Enterprise instance. Then you know you're only dealing with Standard edition features.
    – Mike Petri
    Commented Jan 19 at 19:19
  • The app is running on prod. Does removing an instance impact the server?
    – Imran Qadir Baksh - Baloch
    Commented Jan 19 at 19:20
  • If you are certain none of your processes are using the Enterprise instance, it should not affect the Standard instance, outside of requiring a reboot at some time post-uninstall. However, you should schedule an outage window to be safe.
    – Mike Petri
    Commented Jan 19 at 19:27

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.