Setup Server Name - SQL-FineBuild/Common GitHub Wiki

Previous FineBuild Initialisation Manual Install Setup Service Timeout Next

The name of the server must be in upper case. This is because SQL Server has a history of problems occurring when the server name is not in upper case, particularly during the application of Service Packs and Cumulative Updates.

FineBuild Setup Server Name Processing

Automated processing of Setup Server Name relates to Process Id 1BA in the FineBuild1Preparation script. Automated processing of Upper case Server Name will always occurr if the server name is not in upper case.

The process used by the FineBuild script to change the server name is significantly different to the processing performed manually.

FineBuild uses a call to the hostname.Rename API to change the server name.

If the server name is changed to upper case, then a reboot will be scheduled to allow the new name to be used.

Top

Manual Setup Server Name Processing

The following steps show what you would have to do to setup Server Name manually. FineBuild does all of this work for you automatically.

The user interface requires that the server is rebooted twice before proceeding further.

  1. Right-click on Computer and select Properties.

    Computer Properties

  2. If you are using Windows 2008 or above, click on Advanced system settings:

    Advanced Settings

  3. Select the Computer Name tab, and click on Change:

    System Properties

  4. The user interface considers that a mixed case name and an upper case name are identical. In order to force the server name to upper case the server must first be renamed, then named back to its original name but in upper case.

    Add a suffix to the server name. In the example the letter a has been used. Click OK to save the change.

    New Name

  5. Click OK to acknowledge the need to reboot.

    Reboot Warning

  6. Click OK on all the preceeding windows until you get back to the Desktop. Then click Restart Now on the following message to reboot the computer:

    Reboot Now

  7. After the reboot, return to the Computer Name tab and set the server back to its original name, but in upper case. Click OK to save the change, and then proceed with the reboot.

    UC Name

Copyright FineBuild Team © 2012 - 2018. License and Acknowledgements

Previous FineBuild Initialisation Top Setup Service Timeout Next