locked
Hostname for SQL Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We are migrating to SQL Server 2019 on new hardware. Is there any specification for Hostname like the lenght etc?

    Thanks



    • Edited by biltz Thursday, July 16, 2020 7:46 AM
    Thursday, July 16, 2020 7:46 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We are migrating to SQL Server 2019 on new hardware. Is there any specification for Hostname like the lenght etc?

    There must be but have you hit that limit ? What is the reason for this question can you elaborate, the one I know is the AG name and listener name has 14 character limit

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles
    MVP

    Thursday, July 16, 2020 7:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As said, we are migrating from SQL Server 2016 to SQL Server 2019. So got this question from application team.

    If any SQL Server user is appended by hostname?

    Also, one more question.

    Is it fine to place tempdb on local SAS disks? We have systems which use tempdb heavily. 

    In our new hardware we have local SAS disk installed and the database will be on SSD SAN storage.

    Thanks



    • Edited by biltz Thursday, July 16, 2020 8:16 AM
    Thursday, July 16, 2020 8:16 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Host name is OS related and there is a limit of max. 15 characters, see Naming conventions in Active Directory for computers, domains, sites, and OUs

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Enric Vives Thursday, July 16, 2020 9:45 AM
    Thursday, July 16, 2020 8:33 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    If any SQL Server user is appended by hostname?

    No, this is weird question but why would SQL Server be appended by hostname.

    Is it fine to place tempdb on local SAS disks? We have systems which use tempdb heavily. 

    In our new hardware we have local SAS disk installed and the database will be on SSD SAN storage.

    You said that tempdb is heavily used in that case I would suggest you to keep it on SSD SAN. It would be better. 

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles
    MVP

    Thursday, July 16, 2020 8:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi biltz,

    >>If any SQL Server user is appended by hostname?

    You can try to manually create a username with a hostname appended.

    >>Is there any specification for Hostname like the length etc?

    Host name is a string with a maximum length of 15 bytes of content:

    • can use ASCII characters (1 byte each) and/or multi-byte characters such as Kanji, so long as you do not exceed 15 bytes of content.
    • cannot use spaces or any of the following characters: { | } ~ [ \ ] ^ ' : ; < = > ? @ ! " # $ % ` ( ) + / . , * &, or contain any spaces.
    • cannot use some non-standard characters, such as emoji.

    Best Regards,

    Amelia

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, July 17, 2020 2:10 AM