Post reply

named instance issue

  • September 21, 2011 at 6:58 am

    #245241

    I'm trying to install a named instance. I'm using ONLY numbers and regular characters ex. 5TEMP1

    For whatever reason I'm getting this: 'Instance name cannot contain spaces or special characters'

    What gives?

  • September 21, 2011 at 7:15 am

    #1384471

    Starting from SQL 2005 there are new limitations on instances names:

    SQL2005: must start with a letter or an underscore

    SQL2008 and R2: must start with a letter

    So, the answer is simple, your instance name cannot start with a number!

    References

    MSDN pages for SQL2005->2008R2

    SQL2000

    MCITP Database administrator 2008
    MCTS SQL Server 2008 Implementation and maintenance
    MCTS Sharepoint configuration
    MCP Designing Deploying and Managing a Network Solution for the Small and Medium-sized Business
    ITIL V3 Foundation

  • September 21, 2011 at 7:18 am

    #1384474

    I see. That's a little annoying considering the default instance can very well start with a number.

    Thanks though!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply