|
Home > Archive > MS SQL Server security > February 2006 > Change SQL Instance name to default(local) instrance
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Change SQL Instance name to default(local) instrance
|
|
| DennisLee 2006-02-16, 3:23 am |
| I found some information, but, it didn't work.
Now, i open the enterprise manager, and My SQL Server name is
DENNIS\DENNISDB(wind
ows NT), but i want to change this name to default
name(local), when i installed sql, i changed the instance name, i want
default name.
I used this method.
EXEC sp_dropserver 'DENNISDB'
go
EXEC sp_addserver 'DENNIS', 'local'
go
and i restart SQL Server Service and,
SELECT CONVERT(char(20), SERVERPROPERTY('serv
ername'))
result : DENNIS\DENNIDB
select @@SERVERNAME
result : DENNIS
But, stil Instance name On My Enterprize Manager is DENNIS\DENNISDB, I want
"(local)" instance
Help me plase..
| |
| Uri Dimant 2006-02-16, 3:23 am |
| Hi
As far as I know you cannot change/switch a default instance with a named
one. Re-install SQL Server only.
"DennisLee" <ddongdog@haja.or.kr.korea> wrote in message
news:ONofqOsMGHA.2320@TK2MSFTNGP11.phx.gbl...
>I found some information, but, it didn't work.
>
> Now, i open the enterprise manager, and My SQL Server name is
> DENNIS\DENNISDB(wind
ows NT), but i want to change this name to default
> name(local), when i installed sql, i changed the instance name, i want
> default name.
>
> I used this method.
>
>
> EXEC sp_dropserver 'DENNISDB'
> go
> EXEC sp_addserver 'DENNIS', 'local'
> go
>
> and i restart SQL Server Service and,
>
> SELECT CONVERT(char(20), SERVERPROPERTY('serv
ername'))
> result : DENNIS\DENNIDB
>
> select @@SERVERNAME
> result : DENNIS
>
> But, stil Instance name On My Enterprize Manager is DENNIS\DENNISDB, I
> want
> "(local)" instance
>
> Help me plase..
>
>
>
|
|
|
|
|