This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Cloud SQL Server sys admin user permissions

Posted on 12-16-2024 11:53 PM
ganamur
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi All,

I am trying to restore database in SQL Managed instance (Google Cloud) and I am getting permission denied error. The user doesn't have sysadmin permissions. As per GCP docs, sysadmin role is not supported in GCP.

Please suggest how to grant sysadmin permissions to user in GCP for Backup restore.

0 1 112
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
ChieKo
Staff
Reply posted on --/--/---- --:-- AM

Hi @ganamur,

Welcome to the Google Cloud community!

In Cloud SQL for SQL Server, some features that rely on the "sysadmin" role in on-premises SQL Server are not supported. This includes certain system stored procedures like sp_OADestroy. As a result, automated schema deployment using DACPAC files may not be directly supported.

This limitation arises because Cloud SQL for SQL Server manages security and permissions differently compared to on-premises SQL Server.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

0 Likes
Top Solution Authors
View all