Home Forums SQL Server 2005 Administering @@servername and serverproperty('servername') gives different values RE: @@servername and serverproperty('servername') gives different values

  • August 27, 2009 at 9:46 am

    #1045643

    Ronzo (8/27/2009)

    So, as a follow up, what about a more complex situation:

    Clustered default instance of SQL Server with different virtual IP address and network name then the virtual name and address of the clustered Windows server it is installed on. (note: virtual as in cluster naming, not as in virtual server stuff).

    The @@ServerName reports the SQL cluster name, while serverproperty('servername') reports the Windows cluster name. I do not want to change @@Servername to match serverproperty, I want to make serverproperty match @@Servername. How is this done in a clustered situation like this?

    How to: Rename a SQL Server Failover Cluster Instance

    http://msdn.microsoft.com/en-us/library/ms178083.aspx