none
Create new instance of sql 2008 R2 server

    Question

  • Is there a way to create a instace of sql server just using my pc name? Currently sql uses 'machine name\instance name'
    Thursday, September 16, 2010 4:00 PM

Answers

  • That is what we call a "default instance" in contrast to a "named instance". You can only have one "default instance" installed on a machine.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Thursday, September 16, 2010 4:09 PM

All replies

  • That is what we call a "default instance" in contrast to a "named instance". You can only have one "default instance" installed on a machine.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Thursday, September 16, 2010 4:09 PM
  • Thanks, but I have a named instance called "pcname\servername", so if rerun the install can i craete a defult name called "pcname"?

     

    Thursday, September 16, 2010 4:53 PM
  • As Tibot mentioned. You can have ONLY one default instance on a server (or a cluster as well).

    The sequence of installation doesnt matter. You can add the default instance now.

    Thursday, September 16, 2010 5:05 PM
    Answerer
  • Yes, you can. Assuming you dont already have a default instance, of course.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Thursday, September 16, 2010 5:06 PM
  • The problem is that my pc name has a '-' in the name and i can't change it bacuse it's corporate policy. We have offices in other states, so each user has   'state abbrevatin - user name' as their computer name.

    is there a simpy way to rename the server name?

    Thursday, September 16, 2010 5:14 PM
  • There is no need to rename your server or computer to install a default instance MSSQLSERVER on it - even if it has a dash in it. It is fully supported - just re-run the setup program and select the 'Default instance'. This will give you excactly what you want - a SQL Server with the same name as the machine name.
    Thursday, September 16, 2010 7:54 PM
  • hi

    I just added a new instance on our server.  Our server has a default instance (which is same as machine name).  When i add the 2nd instance, I go thru the whole installation process as if it is a new sql install using the sql 2008 r2 iso.  It will come to a point that you can add a new instance and put in the new instance name.  For options you can select database engine and leave all shared options not checked.  After installation, to access to your sql instance... default instance is just your machine name and other instance is machinename\instancename.

    I guess in your case, your can create the instance name as your machine name if you want to.  Hope that help.

     

     

    Thursday, September 16, 2010 8:34 PM
  • Hi Dan1104

    I came across the same situation,I resolved simple by using "alias name" of the Instance and setting port as 1433.

     

     

     

     

     

    Thanks&Regards

     

     


    SNIVAS
    Friday, September 17, 2010 10:34 AM