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
I live to serve. :-)
Seriously - glad to help.
Rob
