Upgrade SQL SERVER 2017 from 2014

Joann Liao 1 Reputation point
2021-04-08T15:45:53.627+00:00

Upgrade to SQL Server 2017 from 2014. As the result, these users under the folder [Security] and [Server Roles], showed different. Attach the screenshot.
Please advise how these users can be restored.

85869-image.png

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
490 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2021-04-09T06:12:04.45+00:00

    Hi @Joann Liao ,

    The only difference is that SQL server 2017 add a default login NT SERVICE \ SQLTELEMETRY$BADTEST. This login is used for Extended Events. It is related to telemetry.

    Refer to the thread NT SERVICE\SQLTELEMETRY User to get more information.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

  2. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2021-04-12T08:21:23.98+00:00

    Hi @Joann Liao ,

    > MS_PolicyEventProcessingLogin## become disabled
    > MS_PolicyTsqlExecutionLogin## become disabled

    It is disabled both in SQL 2014 and SQL 2017. Any account enclosed in "##" are certificate based accounts and you will not be able to simply create them as you would other logins/users. The above logins are disabled by default. Please refer to MS document Certificate-based SQL Server Logins.

    > NoVIUser become disabled

    The login is disabled in SQL 2014, it will also in disabled state after upgrade SQL server 2014 to SQL 2017.

    > In addition, all roles under Server Roles, there's no marked in red; What happend?

    You are using a newer version SSMS to connect to SQL server 2017, this is SSMS UI design.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.