We have a SQL 2008 clustered named instance Server01\instance02. The port is set to static 1466. We'd like to be able to connect using the name through a F5 Big IP Virtual IP.
We've set up a VIP named Server1 <--please note there is no 0 in this name
Attempting to connect to Server1\instance02 does not work.
Server1,1466 does work.
We have ports 1433, 1434 and 1466 open.
Can we configure this to be able to use the name without any changes to the SQL client.
Thanks!!
note:
A vital tool in troubleshooting this was to start the sqlbrowser service on the server like this:
sqlbrowser.exe -c
This displayed all requests to the service and helped rule out sql being an issue.