Share via

Integration Services evaluation period has expired and I don't have a server.

Vesna Stojanova Trajkovska 1 Reputation point
2022-04-08T09:43:44.677+00:00

I am getting Integration Services evaluation period has expired message.

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

I use SSMS to access other server and I use SSIS from time to time.

Since I don't need the server I uninstalled it. But with that the problem was not resolved.

I uninstalled all SQL components, installed SSMS only. Again the same.

I have done it several times. I can not do format, I have to many thing on my laptop.

I appreciate any help. Thanks.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,771 Reputation points
    2022-04-08T18:23:45.17+00:00

    You need to upgrade to the Developer Edition. It sounds like you have the Evaluation Edition installed.

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15

    2 people found this answer helpful.
  2. Vesna Stojanova Trajkovska 1 Reputation point
    2022-04-08T17:50:05.917+00:00

    I know that ssms is not related to the server. I was desparate.

    I just need to use ssis. If I log in remotly to the server where I have to import data it is ok.

    The problem is on my local mashine.

    0 comments
  3. Yitzhak Khabinsky 26,586 Reputation points
    2022-04-10T13:50:26.297+00:00

    Hi @Vesna Stojanova Trajkovska ,

    The problem is on my local mashine.

    If you are dealing with SSIS:

    • You development machine needs just and only Visual Studio (VS). It is better to use VS2019 with SQL Server Integration Services Projects extension.
    • SSIS run-time server needs SQL Server instance installation with SSIS.
    0 comments
  4. ZoeHui-MSFT 41,496 Reputation points
    2022-04-11T01:48:11.577+00:00

    Hi @Vesna Stojanova Trajkovska ,

    Not clear about your request.

    The problem usually occurs when you are running an evaluation instance of SQL Server and the evaluation time period has expired.

    If you do not want to get the expired error, you may install the SQL Server Develop version.

    As soon as you upgraded the edition of SQL Server, SSIS also got upgraded and things were back to normal.

    Check this evaluation-period-has-expired.

    Since I don't need the server

    You are also talking about SSIS, if you only want to design SSIS package and run it via VS.

    You may just install the VS and then design the package, run the package and modify it.

    Please give a certain scope that what you want to resolve so that we could give more help.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  5. Vesna Stojanova Trajkovska 1 Reputation point
    2022-04-15T13:19:06.687+00:00

    Hi,

    I never installed evaluation copy. I didn't know that this existed before my problem. I had SQL Express.

    I don't need the server any more on my local machine. I don't need VS as well.

    I want to just to use SSMS to log in to other company servers that have licenses and import files (with SSIS) from excel or other sources.

    This is uninstall problem.

    I don't want to close the ticket since the issue is not resolved.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.