Re: What is the server name for a standalone XP SP2?

Hi Ekrem,
You say:
You can uninstall Named and Default instances if you do not need them.
How should one uninstall a Named instance in a clean fashion? I thought I
saw some Delete command in a right click somewhere, but I cannot find it
anymore...
You say:
You can not rename a Default Instance to a Named Instance. However, you can
use Aliases for your SQL Server instances which can be defined in
Configuration Manager of SQL Server 2005.
I checked the menus in the Configuration Manager and connot figure out how
to create an alias for a named instance. How does one do that?
Thanks for your comments.
--
Jac Tremblay


"Ekrem Önsoy" wrote:

You can install multiple instances of SQL Server side by side. You can
create only one Default Instance (which means that instance's name is the
Computer Name of your OS) and you can create multiple Named Instances (which
consists of <ComputerName>\<InstanceName>). You pick the names of instances.

You can uninstall Named and Default instances if you do not need them.

You can not rename a Default Instance to a Named Instance. However, you can
use Aliases for your SQL Server instances which can be defined in
Configuration Manager of SQL Server 2005.

--
Ekrem Önsoy



"Jac Tremblay" <jac.tremblay@xxxxxxxxxxxxx> wrote in message
news:B486580B-E5C1-4FE8-BC55-0B4BC8D18B96@xxxxxxxxxxxxxxxx
Hi Okrem,
Is it possible to create a new named instance and them connect to it?
Is it possible to rename "ComputerName" to "ComputerName\InstanceName"?
Is there any danger deleting a named instance that one cannot connect to?
Thanks
--
Jac Tremblay


"Ekrem Önsoy" wrote:

Go to Start\Programs\Microsoft SQL Server 2005\Configuration Tools and
open
SQL Server Configuration Manager. After openning this tool, you'll see a
list at the left side pane, click SQL Server 2005 Services. There, you'll
see SQL Server services and your instance name which is going to be
written
in parenthesis just like "SQL Server (MSSQLSERVER)".

"SQL Server (MSSQLSERVER)" means you have a Default Instance SQL Server
and
you can connect to default instances only using your Computer Name.

If it's something different like "SQL Server (SQLTEST)" then it means
it's a
Named Instance and you can connect to named instances using
"ComputerName\InstanceName" format.

And ensure your SQL Server service (which is the essential one) runs. To
see
that, check out the "State" column in SQL Server Configuration Manager
tool.
If it's stopped or not in Running state somehow, then you'll not be able
to
connect to your SQL Server instance.

--
Ekrem nsoy



"Sadat" <lmasadat@xxxxxxx> wrote in message news:fo78j1$m31$1@xxxxxxxxxxx
Hi

I have XP Pro/SP2, 20gb HD, 512mb RAM, Celeron 1ghz laptop for home
use. I
installed SQL Server 2005 Enterprise Evaluation edition for trial. When
I
clicked on the Management Studio, the dialog box asks for server name.
My
computer name is shinaspc. It is a standalone machine. I cannot create
any
database or learn from samples.

Please help.

Regards,
Sadat




.

Relevant Pages

  • change a named instance to default instance
    ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
    (microsoft.public.sqlserver.connect)
  • Re: x64 2003 Cluster - SQL2000 named instance fail
    ... one the settings are not detected by the setup. ... > in the cluster log you will notice the a connection to the SQL Server ... > named instance cannot be established. ... >> Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • RE: Cluster Configurations
    ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cannot connect to second cluster node w/instance name
    ... Is the SQL Server Browser Service running to provide the tcp port number for the named instance? ... When I attempt to connect to node2 remotely I get an error basically stating "An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Re: What is the server name for a standalone XP SP2?
    ... To uninstall an Instance of SQL Server, you go to Control Panel -> Add\Remove Programs and then find and mark SQL Server 2005 and click Uninstall button. ... you open Configuration Manager and go to "SQL Native Client Configuration" node and expand it. ... How should one uninstall a Named instance in a clean fashion? ...
    (microsoft.public.sqlserver.setup)