New Install - MS SQLServer Named Instance
I am trying to bring up a new install using MS SQLServer and our DBAs have set up a "named" server for me. However, I cannot seem to come up with the right connection URL to make the "Test Connection" work.
MS recommends using "hostname.domain.com\SERVERNAME" but I get "hostname not found" errors with that config.
Does anyone else have this configuration working?
Thanks,
Emmett
Hi Emmett,
I think I can help.
In the database name field, type the following:
myDatabaseName;instance=myNamedInstance
(that is, add “;instance=instanceName” to the end of the database name)
Not standard, I know. But this is how we pass the instance name in.
Regards,
Rob
Community Member of the Month
December 2019
Announcing Dynatrace's Community Member of the Month for December 2019, Enrico F.! Click here to read more! Employee Member of the Month
December 2019
Announcing Dynatrace's Employee Member of the Month for December 2019, Silvia M.! Click here to read more! 