I am getting Integration Services evaluation period has expired message.

Irina Chvets 0

Last year I installed a server on my local machine. I needed a local database at the time.

After 6 mounts I started getting this message. Integration Services evaluation period has expired.

But I have downloaded and in stalled Enterprise Edition version enu_sql_server_2022_enterprise_edition_x64_dvd_aa36de9e.iso

I also checked that under my subscription I do not need activation keys. I tried to run Edition Upgrade but the process got suspended.

Could anyone please assist in this issue as I can not longer start SQL server.

3 answers

Azar 22,860 Reputation points MVP

2023-11-06T12:06:13.22+00:00

Hi Irina

Firstly Verify that your SQL Server edition is in the Enterprise Edition. If you have installed the Enterprise Edition, you shouldn't see evaluation period expiration messages.

also, check if your license is properly applied it sometimes happens due to this too.

If you're sure you have the correct edition and a valid license like I mentioned above, you may need to upgrade your SQL Server edition to the Enterprise Edition. Here's how you can do it:

Open SQL Server Installation Center.

Click on "Maintenance" on the left panel.

Choose "Edition Upgrade."

Follow the wizard to upgrade your edition to Enterprise.

kindly reboot your system after doing so and hopefully this gets fixed, do this one more time and if it still is the issue kindly raise the support req from the below link and someone from team will contact you soon.

https://support.microsoft.com/en-US/search/results?query=sql&isEnrichedQuery=false

Hope this helped if it helped kindly accept the answer thanks you very much.
Please sign in to rate this answer.
Irina Chvets 0 Reputation points

2023-11-06T12:20:27.1033333+00:00

Hi Azar, thank you very much for your reply. I only have one iso image that I run installation from as I mentioned in my post and its mentioned Enterprise edition enu_sql_server_2022_enterprise_edition_x64_dvd_aa36de9e.iso.

When I downloaded this iso image under my MSDN subscription I checked the key and it says No key required.

How can I run "Edition Upgrade." if I do not have keys. Also I am puzzled why I am getting evaluation period has expired message in first place if I have installed for sure Enterprise edition.

Could you pls help me to verify that my SQL Server edition is indeed the Enterprise Edition? Where can I confirm that?

Thanks

Azar 22,860 Reputation points MVP

2023-11-06T12:28:10.44+00:00

sure i understand

Open SQL Server Management Studio .

In SQL Server Management Studio, connect to your SQL Server instance. In SQL Server Configuration Manager, locate your SQL Server instance in the "SQL Server Services" section.

Right-click on your SQL Server instance, and then click on "Properties."

In the "General" tab, you should see the edition information listed. If it says "Enterprise Edition," you've installed the Enterprise Edition.

for detailed info on how to view it kindly go through the below link

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/find-my-sql-version.

even if after doing these and you cant get it resolved kindly raise the support request, where the team will help you troubleshoot the issue and get it sorted faster.

Dont forget to upvote and accept the answer if it helped Thanks again.

Irina Chvets 0 Reputation points

2023-11-06T12:44:11.8733333+00:00

Hi Azar, could you please guide me how can I raise the support req from the link you provided. I do not see any option to create a support request. Please help. Thanks.

Azar 22,860 Reputation points MVP

2023-11-06T12:58:40.75+00:00

sure login with your azure account and in the portals home page search for help+support or scroll below to find help+support option, for reference find below image.

after this select create a support req

there you need to fill the info about the issue in this case try searching for SQL server related and after successful submission the team will get back with you shortly,

hope this helps you, thanks

Erland Sommarskog 111.5K Reputation points MVP

2023-11-06T22:14:22.9133333+00:00

Azar, that is the place to go if you have issues with your Azure services, but Irina has made no indication that she is using Azure. It seems that she has a Visual Studio/MSDN subscription.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Olaf Helper 44,736 Reputation points

2023-11-06T12:24:56.5066667+00:00

But I have downloaded and in stalled Enterprise Edition version

And have you installed it with a valid Enterprise product key; a very expensive one?

If not then you have installed it as Evaluation Edition and that one expires after 180 days = 6 months.
Please sign in to rate this answer.
Irina Chvets 0 Reputation points

2023-11-06T12:28:10.26+00:00

@Olaf Helper No I did not because when I go to Keys I have msg saying that No key required under my subscription.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Yitzhak Khabinsky 25,861 Reputation points

2023-11-06T14:20:10.49+00:00
Hi @Irina Chvets,

Just execute the following statement in your SSMS:

SELECT @@VERSION;

It will show you exactly what SQL Server version and its edition is installed.
Please sign in to rate this answer.
Irina Chvets 0 Reputation points

2023-11-06T15:08:53.0666667+00:00

I can not login to SSMS because of the SQL server can not be started because of the the above error.

Irina Chvets 0 Reputation points

2023-11-06T15:12:10.48+00:00

Hi @Yitzhak Khabinsky Thank you but the problem is I can not login to SSMS because SQL server can not be started because of the initial error above. As a result I can not execute and SQL statements in SSMS.

Erland Sommarskog 111.5K Reputation points MVP

2023-11-06T22:18:52.6733333+00:00

I can not login to SSMS because of the SQL server can not be started because of the the above error.

Go to C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG and look at the top of the file ERRORLOG. The information we are looking for is on the top of the file. (Unless you have cycled the errorlog, in which case you need to check the earlier files.)

Although, I agree with the others, that it is quite clear that you have Evaluation Edition. If you have an image of Enterprise from MSDN, you can run Edition Upgrade. That image is pre-pidded, so there is no issue with keys.

Beware that if this is Enterprise, I don't think it is licensed for production, since you got it from MSDN.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

I am getting Integration Services evaluation period has expired message.

3 answers

Your answer