Skip to main content
Database Administrators

Return to Question

Notice removed Draw attention by CommunityBot
Bounty Ended with no winning answer by CommunityBot
added 73 characters in body
Source Link
Imran Qadir Baksh - Baloch
Imran Qadir Baksh - Baloch
  • 1.3k
  • 6
  • 19
  • 33

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/

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.

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/

Notice added Draw attention by Imran Qadir Baksh - Baloch
Bounty Started worth 50 reputation by Imran Qadir Baksh - Baloch
Source Link
Imran Qadir Baksh - Baloch
Imran Qadir Baksh - Baloch
  • 1.3k
  • 6
  • 19
  • 33

Multiple SQL Server versions and Integration Services evaluation period has expired

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.