SQL server 2005 Instance name

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
LVL 4
bominthuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jogosCommented:
<<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 ...).
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
create a default instance without having to enter the instance name.  The instance name will be the same as the machine name.
bominthuAuthor Commented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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...
Anthony PerkinsCommented:
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.
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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/
Anthony PerkinsCommented:
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.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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
bominthuAuthor Commented:
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
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Applies to any instance apart from MSDE which systematically installs NAMED INSTANCE.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.