Friday, March 30, 2012

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>> A person, who installed SQL Server specified LOCAL as name of the SQL
>> Server
>> If you want to change the name ,just delete the registration from EM and
>> create a new one with name of the machine
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>>
>

No comments:

Post a Comment