August 25, 2008 at 4:36 am
I'm study SQL Server 2005
when i installed SQL server it didn't require me to enter instance name, this option is not available in my edition (SQL Server 2005 Enterprise).
How i can create instance name after installation or create another instance name from inside SQL Server management studio?
please help meeeeeeeeeeeeeee.
August 25, 2008 at 4:52 am
Hi
During installation it asks for a instance name. The default instance name is the computer name. This option is selected by default. Maybe u did not notice it and went ahead with your installation. Anyway was the installation complete?
Run this query select serverproperty('InstanceName') to get the instance name.
"Keep Trying"
August 25, 2008 at 7:48 am
thanks but when i was install SQL Server it didn't appear this option whether Default instance name or specify instance name, this window didn't appear.
August 25, 2008 at 7:51 am
you wouldnt have visited the advanaced options screens.
August 25, 2008 at 8:16 am
To go to advanced options, you must look for a small check box at the bottom of one page configuration. It state that you want to have advanced options when configuring along.
It's not a typical screen option where you have "Typical", "Advanced" or "Custom" installations choices.
August 25, 2008 at 9:44 am
If you want to rename the existing default instance, you must run these stored procedures then restart the instance:
sp_dropserver
GO
sp_addserver , local
GO
See BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/bbaf1445-b8a2-4ebf-babe-17d8cf20b037.htm
Greg
August 27, 2008 at 12:06 am
Hi
If you really want a instance with a specifc instance name you will either have rename the instance as mentioned in the earlier post or install one more instance.
Is it a problem if instance name is default name?
"Keep Trying"
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply