Solved

SQL server 2005 Instance name

Posted on 2012-04-01
10
429 Views
Last Modified: 2012-04-02
When I install SQL server 2005 Standard or Express edition, I manually type the instance name as my machine name. But after finished installation, in SSMS, the instance name appear as machinename\machinename. How can I create instance name as only machine name instead of machinename\machinename ?

Thanks
Rgds
0
Comment
Question by:bominthu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 37793732
<<How can I create instance name as only machine name instead of machinename\machinename ?>>
You can have an instance name DEV2008 on different servers, so  to know on which server that instance is it needs the servername (machinename). And because you name the instance the same as the server it looks odd.

Rethink why you name the instance the same as the server. Does it tell anything about what's on that instance? How will you name an instance if you face the fact you have to install a second instance on same server (test, other sql version ...).
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 37793805
create a default instance without having to enter the instance name.  The instance name will be the same as the machine name.
0
 
LVL 4

Author Comment

by:bominthu
ID: 37793811
SQL 2005 is installed in our server by one programmer. When he install, i see instance name is as attached image. Just unique and same as server name.

I'm just doing some test by installing SQL 2005 in my machine.
When I install it, it always appear as servername\servername as instance name.
The reason I'm trying to have the same as he installed is the program is configured with that instance name as he configured.

How can I configure instance name as the way he configured ?

Thanks
1.JPG
2.JPG
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 37793840
If the instance name is the NETBIOS NAME, he is probably installed a default instance.   There are only two ways to install SQL Server:

> DEFAULT INSTANCE: the instance name takes the NETBIOS NAME of the machine
> NAMED INSTANCE: adds the INSTANCE NAME entered to the existing machine NETBIOS NAME
 
Hope this helps...
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37793866
When you install SQL Server Express Edition it automatically creates a named instance machinename\SQLExpress.  I don't know anyway of changing that, but I would not be surprised if there is some way to change it.  In the case of SQL Server Standard Edition the first instance is named simply machinename.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 37793885
hi Antony :)

There is no way one can transform a named instance into a default instance.  It is however possible to rename a named instance into another named instance simply by dropping recreating the instance names.

http://sqldbpool.com/2008/09/03/how-to-change-sql-server-instance-name/
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37793940
Hey Racim,

What I meant by this:
"I don't know anyway of changing that, but I would not be surprised if there is some way to change it."
Was when installing SQL Server not after.  I should have been clearer.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 37794100
to convert named to default --> just reinstall can help

<How can I create instance name as only machine name instead of machinename\machinename ?
>
as per above posts -- during installation do not type the your server name but select the option "Default instance"
it will give you the desired result
more -see "step-by-step" installation guide:
http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx
0
 
LVL 4

Author Comment

by:bominthu
ID: 37795272
Hi Racimo,

<<<<<"If the instance name is the NETBIOS NAME, he is probably installed a default instance.   There are only two ways to install SQL Server:
 DEFAULT INSTANCE: the instance name takes the NETBIOS NAME of the machine
> NAMED INSTANCE: adds the INSTANCE NAME entered to the existing machine NETBIOS NAME" >>>>


Above applied to SQL2005Express edition ?

Thanks
Rgds
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 total points
ID: 37795290
Applies to any instance apart from MSDE which systematically installs NAMED INSTANCE.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question