Unable to Connect to MS Sql Database Named Instances

[garkenxian]

I was able to get everything working in a test instance, but when I moved this code over to my "production" instances, these are named instances with names like SERVERNAME\DATABASE_INSTANCE.

Honestly I am at a loss as to what to do next. The documentation only refers to using hostname but this does not seem to work with named instances.

When I use it I get this error.

│ Error: Failed to retrieve DB ID for name 'xxxxxxx'
│ 
│   with data.mssql_database.octopus,
│   on _data_sources.tf line 67, in data "mssql_database" "xxxxxx":
│   67: data "mssql_database" "octopus" {
│ 
│ parse
│ "***SERVERNAME%5CDATABASE_INSTANCE:1433?app+name=Terraform+-+mssql+provider":
│ invalid URL escape "%5C"

Thanks