Add support rootPassword property of google_sql_database_instance for SQL Server

[sho-abe]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment. If the issue is assigned to the "modular-magician" user, it is either in the process of being autogenerated, or is planned to be autogenerated soon. If the issue is assigned to a user, that user is claiming responsibility for the issue. If the issue is assigned to "hashibot", a community member has claimed the issue already.

Description

Since October 15th, Cloud SQL for SQL Server has been public beta.
I tried to create SQL Server instance with google_sql_database_instance, but I could not create it with the following error.

google_sql_database_instance.mssql: Creating...

Error: Error, failed to create instance mssql-tf: googleapi: Error 400: Missing parameter: Root Password., required

  on sql.tf line 1, in resource "google_sql_database_instance" "mssql":
   1: resource "google_sql_database_instance" "mssql" {

Apparently, when creating SQL Server with REST API, it seems that "rootPassword" is required in RequestBody.
The google_sql_database_instance can't set "rootPassword" currently, so I wourd like to need that feature.

New or Affected Resource(s)

• google_sql_database_instance

Potential Terraform Configuration

resource "google_sql_database_instance" "mssql" {
  name             = "mssql-tf"
  region           = "asia-northeast1"
  database_version = "SQLSERVER_2017_WEB"
  root_password    = "password" ## can be set!!

  settings {
    tier      = "db-custom-2-3840"
    disk_size = 10
    disk_type = "PD_SSD"
  }

}

resource "google_sql_database" "mssql" {
  instance = google_sql_database_instance.mssql.name
  name     = "testdb"
  collation = "UTF-8"
}

References

• https://cloud.google.com/sql/docs/release-notes#october_15_2019
• https://cloud.google.com/sql/docs/sqlserver/admin-api/v1beta4/instances/insert
  • But "rootPassword" is missing in this document.

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!