SQL Server 2022 - Polybase External Tables - Create a master key
0
votes
1
answer
183
views
SQL Server 2022, CU 10 on Windows 2022.
I am migrating a SQL Server 2019 database to a new SQL Server 2022 and when attempting to SELECT rows from an external Polybase driven table, I get the following error:
The service master key on this server is a restored copy of the service master key from the original server.
I verified that information by comparing the GUID of the ##MS_ServiceMasterKey## in the master database on both instances.
The External Table is accessible on the original server.
If the service master key in the master database is the same as the key in the original server, what other steps do I need to take?
The password that was used to create the **database** master key is no longer available.
Polybase is enabled for the instance and the Engine and Data Movement services are running.
Thank you,
Craig
The service master key on this server is a restored copy of the service master key from the original server.
I verified that information by comparing the GUID of the ##MS_ServiceMasterKey## in the master database on both instances.
The External Table is accessible on the original server.
If the service master key in the master database is the same as the key in the original server, what other steps do I need to take?
The password that was used to create the **database** master key is no longer available.
Polybase is enabled for the instance and the Engine and Data Movement services are running.
Thank you,
Craig
Asked by user4659
Feb 6, 2024, 09:22 AM
Last activity: Jul 8, 2025, 10:07 AM
Last activity: Jul 8, 2025, 10:07 AM