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"
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.
Thanks