|
Home > Archive > MS SQL Server > February 2006 > sql 2000 instance change to Default instance
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 |
sql 2000 instance change to Default instance
|
|
| 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..
| |
| Tibor Karaszi 2006-02-16, 3:23 am |
| You cannot change instance name. You would have to install a new instance with desired name and move
the databases from the old instance to the new instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"DennisLee" <ddongdog@haja.or.kr.korea> wrote in message
news:ufSl39qMGHA.3408@TK2MSFTNGP12.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..
>
| |
| DennisLee 2006-02-16, 3:23 am |
| Thank you Tibor Karaszi
then What does these procedure do??
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:ON8EUssMGHA.3896@TK2MSFTNGP15.phx.gbl...[color=darkred]
> You cannot change instance name. You would have to install a new instance
> with desired name and move the databases from the old instance to the new
> instance.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "DennisLee" <ddongdog@haja.or.kr.korea> wrote in message
> news:ufSl39qMGHA.3408@TK2MSFTNGP12.phx.gbl...
>
| |
| Sune Due Moeller 2006-02-16, 7:23 am |
| Dennis,
Sp_addserver and SP_Dropserver are procedures use to establish linked
servers, thats is SQL Server to SQL Server connection. In that way you can
make 4 parts statements against any linked server ie
server.catalog.schema.object.
So say you have SQL Server A and SQL Server B:
On Server A you want to make Statement against server B. You can establish
this my making server B a linked server on Server A. So on Server A you isue
the SP_addserver statment with Server B as the target server. See the online
help for more information
"DennisLee" wrote:
> Thank you Tibor Karaszi
>
> then What does these procedure do??
>
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
> message news:ON8EUssMGHA.3896@TK2MSFTNGP15.phx.gbl...
>
>
>
| |
| Tibor Karaszi 2006-02-16, 7:23 am |
| They are required after you changed the machine name in windows. SQL Server stores both
remote/linked servers as well as the local machine name in the sysservers table. If you change the
machine name in Windows, sysservers will not reflect this, hence the need for those.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"DennisLee" <ddongdog@haja.or.kr.korea> wrote in message
news:OGoqm9sMGHA.2624@TK2MSFTNGP12.phx.gbl...
> Thank you Tibor Karaszi
>
> then What does these procedure do??
>
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in message
> news:ON8EUssMGHA.3896@TK2MSFTNGP15.phx.gbl...
>
>
| |
| DennisLee 2006-02-17, 7:23 am |
| Do you mean that Machine name is Computer Machine name?
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:ud8mjIuMGHA.3960@TK2MSFTNGP09.phx.gbl...
> They are required after you changed the machine name in windows. SQL
> Server stores both remote/linked servers as well as the local machine name
> in the sysservers table. If you change the machine name in Windows,
> sysservers will not reflect this, hence the need for those.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "DennisLee" <ddongdog@haja.or.kr.korea> wrote in message
> news:OGoqm9sMGHA.2624@TK2MSFTNGP12.phx.gbl...
>
| |
| DennisLee 2006-02-17, 7:23 am |
| Thanks Sune Due Moeller.
So I should reinstall SQL.
"Sune Due Moeller" < SuneDueMoeller@discu
ssions.microsoft.com> wrote in
message news:049AA370-3563-4C1B-A58A- 07EF01AD8A2F@microso
ft.com...[color=darkred]
> Dennis,
>
> Sp_addserver and SP_Dropserver are procedures use to establish linked
> servers, thats is SQL Server to SQL Server connection. In that way you can
> make 4 parts statements against any linked server ie
> server.catalog.schema.object.
>
> So say you have SQL Server A and SQL Server B:
>
> On Server A you want to make Statement against server B. You can establish
> this my making server B a linked server on Server A. So on Server A you
> isue
> the SP_addserver statment with Server B as the target server. See the
> online
> help for more information
>
> "DennisLee" wrote:
>
| |
|
|
|
|
|