question

rallgayer avatar image
rallgayer asked

Error creating Integration Service Catalog

I am trying to create an integration services catalog and get the following error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.IntegrationServices) ------------------------------ ADDITIONAL INFORMATION: Cannot drop asymmetric key 'MS_SQLEnableSystemAssemblyLoadingKey' because there is a login mapped to it. The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it. The server principal '##MS_SQLEnableSystemAssemblyLoadingUser##' already exists. Cannot find the login '##MS_SQLEnableSystemAssemblyLoadingUser##', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15559) The key exists as well as the login. Here is my version information: Version Level Edition 13.0.1742.0 RTM Standard Edition (64-bit) Need some help. Thank You
login
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Adedba avatar image Adedba commented ·
Not really that good with troubleshooting the integration services catalog however I did stumble upon this link which may help: https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-asymmetric-key-transact-sql , in particular the Remarks section. Hope this helps
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.