Change what is returned by @@SERVERNAME on cluster

I have not tested this, but I believe to change what is returned by @@SERVERNAME, you go to
1) Failover Cluster Manager
2) Expand Services and applications on the left pane
3) Click on SQL Server on the left pane
4) Right click/properties on the SQL Server under Server Name, in the main pane
5) Change name under DNS Name
6) Restart of services may be required.

I feel bad showing an untested solution..but maybe I can help someone.

Advertisements
This entry was posted in Database Administration and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s