I have 3 instances dev,qa and uat of sql 2012 on one windows server.
Here are names.
1) sql-001\dev --named instance --no I/P
2) sql-001\qa --named instance -- no I/P
3) sql-001 --default instance --10.10.10.1
I went to other box and created alias for sql-001\dev called as 'sqldev' in sql config manager and then I can connect to sqldev from that other server.
Now my application team tries to connect to this instance which has '-' and '/' so we gave them same alias but they are not sure how to use it?
My understanding is they have to create this alis first in their system after that they can use it inside config file.
But how to create this alias on application??
Please let me know.