bominthu
asked on
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
Thanks
Rgds
create a default instance without having to enter the instance name. The instance name will be the same as the machine name.
ASKER
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
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
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...
> 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...
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.
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/
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/
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.
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.
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
<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
ASKER
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
<<<<<"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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ...).