Renaming a server after SQL is installed.

Hi All
I remember seeing a KB on the issue of renaming a server
name after SQL has been installed. It had something to do
with the fact that SQL binds itself to the server name. I
can't seem to find the article again. Any ideas or
thoughts?
Thanks
Jonolookup RENAMING SERVERS in BOL, you will have to do
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
If you created any jobs under the old server name you will have to change
the originating server in sysjobs in the MSDB database, also, make sure your
service account has appropriate permissions to the new servername (like
ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--"Jono"
<anonymous@.discussions.microsoft.com> wrote in message
news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
> Hi All
> I remember seeing a KB on the issue of renaming a server
> name after SQL has been installed. It had something to do
> with the fact that SQL binds itself to the server name. I
> can't seem to find the article again. Any ideas or
> thoughts?
> Thanks
> Jono|||Using
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
doesn't seem to work for SQL7 and you have to run setup
again. The setup process will ask if you want to upgrade,
select yes and sql will assume the new name of the server.
Mark S
>--Original Message--
>lookup RENAMING SERVERS in BOL, you will have to do
>sp_dropserver <old_name>
>go
>sp_addserver <new_name>
>go
>If you created any jobs under the old server name you
will have to change
>the originating server in sysjobs in the MSDB database,
also, make sure your
>service account has appropriate permissions to the new
servername (like
>ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--
"Jono"
><anonymous@.discussions.microsoft.com> wrote in message
>news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
>> Hi All
>> I remember seeing a KB on the issue of renaming a server
>> name after SQL has been installed. It had something to
do
>> with the fact that SQL binds itself to the server name.
I
>> can't seem to find the article again. Any ideas or
>> thoughts?
>> Thanks
>> Jono
>
>.
>