server hostname / alias

• inevercheckthis2002

  SSCommitted

  Points: 1819

  More actions

  October 4, 2013 at 5:41 am

  #278695

  We have a new SQL 2008 server. We'd like to refer to it as SERVERNAME. However, the server group insists on naming it NAMINGCONVENTION.

  We can make an alias in DNS, so that SERVERNAME resolves to the server's IP address.

  Can we then connect to SQL Server as SERVERNAME\MSSQLSERVER, or will we need to use NAMINGCONVENTION\MSSQLSERVER ?

  Does SQL Server need to know what the alias is?

  Thanks....

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 4, 2013 at 5:45 am

  #1655847

  You should be able to use the actual name as well as the alias (or even the IP address).

  John