SQL Alis for application

• dallas13

  SSCertifiable

  Points: 7491

  More actions

  June 12, 2014 at 2:25 pm

  #308083

  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.

• Hema kumar-337490

  Say Hey Kid

  Points: 697

  More actions

  June 12, 2014 at 2:32 pm

  #1721245

  I had a similar situation in SharePoint implementation. I have used the SQL aliasing. Create an alias refer the alias name in the code.

  Please find the link below.

  http://blogs.msdn.com/b/priyo/archive/2013/09/13/sql-alias-for-sharepoint.aspx