Sunday, February 12, 2012

Change of Computer Name

Hi,
I'll like to change the computer name but my sql server 7 instance is tied
to the computer name. May I know how to resolve this without re-installation ?
TIA !
DesmondDesmond
See sp_addserver and sp_dropserver in the BOL as well as visit at this web
site
http://vyaskn.tripod.com/moving_sql_server.htm
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without
re-installation ?
> TIA !
> Desmond|||http://www.karaszi.com/SQLServer/info_change_server_name.asp
Note that you have to adapt the SQL code that handles your jobs (the code is to SQL Server 2000)...
Or use the KB article strategy instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond|||Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Desmond" wrote:
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond

No comments:

Post a Comment