Changing computer name

Can anyone advise how to change the computer name of a PC
which is running sql client with msde.
I find if I change the computer name sql server will not
start.
Any advise would be appreciated. Thanks
The following works for the default instance:
DECLARE @.old_server_name SYSNAME
DECLARE @.new_server_name SYSNAME
SET @.old_server_name = @.@.SERVERNAME
SET @.new_server_name = <your new computer name>
EXEC sp_dropserver @.server = @.old_server_name
EXEC sp_addserver @.server = @.new_server_name , @.local = 'LOCAL'
UPDATE msdb..sysjobs
SET originating_server = @.new_server_name
WHERE originating_server = @.old_server_name
You have to restart SQL Server (MSDE), and then change the computername, for
it to take effect though.
Jacco Schalkwijk
SQL Server MVP
"Elayne" <pstjw@.hotmail.com> wrote in message
news:c37501c47a33$c0d79090$a401280a@.phx.gbl...
> Can anyone advise how to change the computer name of a PC
> which is running sql client with msde.
> I find if I change the computer name sql server will not
> start.
> Any advise would be appreciated. Thanks
|||I've never experienced the SQL Server service failing to start after the
computer name was changed. What is the error you get when starting the
service from the command line (net start mssqlserver)? Are you able to
start SQL Server as console app by running "sqlservr.exe -c" from the
command line?
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Changing Computer Name

Here's my situation. We have a production SQL server 2000 with about 18
different databases running on it. The lease is up on the server and now i
must roll everything over to the new server. What i need to do is join the
domain with the new server using a different ip address and name than the
current SQL server, get everything installed, test it, then take both servers
down, rename the new server and change it's ip address to what the old one
was, and put it into production. Does anyone know how painful this will be
and what obstacles i need to look out for? Also, if there's a step by step
guide somewhere that'd be pretty great too. The old server has windows 2000
on it, the new server will have windows 2003. Thanks.
See answer to "Moving SQL Server"
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.
|||Double Post. Answered in "Moving SQL Server".
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.
|||"get everything installed"
Install SQL Server, service packs, restore the databases...
"test it"
How are you going to test it? Can you just leave the new server name in
place and change the connection string to connect to the new computer? I
suppose not, or you would not have the question. Anyway, this is the
easiest option.
"rename the new server"
When the box is restarted SQL Server will display an error message on start.
You will have to pop in the SQL Server CD and choose install. This step
will not actually install SQL Server...it will just fix up some registry
entries.
If you have jobs defined on your server you might have to update the value
as stored within the originating_server column.
SELECT originating_server FROM msdb..sysjobs
If @.@.servername is incorrect you will have to drop and add server using the
stored procedures listed below:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName', 'local'
Keith
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.

Changing Computer Name

Here's my situation. We have a production SQL server 2000 with about 18
different databases running on it. The lease is up on the server and now i
must roll everything over to the new server. What i need to do is join the
domain with the new server using a different ip address and name than the
current SQL server, get everything installed, test it, then take both server
s
down, rename the new server and change it's ip address to what the old one
was, and put it into production. Does anyone know how painful this will be
and what obstacles i need to look out for? Also, if there's a step by step
guide somewhere that'd be pretty great too. The old server has windows 2000
on it, the new server will have windows 2003. Thanks.See answer to "Moving SQL Server"
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.|||Double Post. Answered in "Moving SQL Server".
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.|||"get everything installed"
Install SQL Server, service packs, restore the databases...
"test it"
How are you going to test it? Can you just leave the new server name in
place and change the connection string to connect to the new computer? I
suppose not, or you would not have the question. Anyway, this is the
easiest option.
"rename the new server"
When the box is restarted SQL Server will display an error message on start.
You will have to pop in the SQL Server CD and choose install. This step
will not actually install SQL Server...it will just fix up some registry
entries.
If you have jobs defined on your server you might have to update the value
as stored within the originating_server column.
SELECT originating_server FROM msdb..sysjobs
If @.@.servername is incorrect you will have to drop and add server using the
stored procedures listed below:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName', 'local'
Keith
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.

Changing Computer Name

Here's my situation. We have a production SQL server 2000 with about 18
different databases running on it. The lease is up on the server and now i
must roll everything over to the new server. What i need to do is join the
domain with the new server using a different ip address and name than the
current SQL server, get everything installed, test it, then take both servers
down, rename the new server and change it's ip address to what the old one
was, and put it into production. Does anyone know how painful this will be
and what obstacles i need to look out for? Also, if there's a step by step
guide somewhere that'd be pretty great too. The old server has windows 2000
on it, the new server will have windows 2003. Thanks.See answer to "Moving SQL Server"
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.|||Double Post. Answered in "Moving SQL Server".
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.|||"get everything installed"
Install SQL Server, service packs, restore the databases...
"test it"
How are you going to test it? Can you just leave the new server name in
place and change the connection string to connect to the new computer? I
suppose not, or you would not have the question. Anyway, this is the
easiest option.
"rename the new server"
When the box is restarted SQL Server will display an error message on start.
You will have to pop in the SQL Server CD and choose install. This step
will not actually install SQL Server...it will just fix up some registry
entries.
If you have jobs defined on your server you might have to update the value
as stored within the originating_server column.
SELECT originating_server FROM msdb..sysjobs
If @.@.servername is incorrect you will have to drop and add server using the
stored procedures listed below:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName', 'local'
--
Keith
"dimsdale_007" <dimsdale007@.discussions.microsoft.com> wrote in message
news:F61F754D-1967-4A67-BACE-136759C158D6@.microsoft.com...
> Here's my situation. We have a production SQL server 2000 with about 18
> different databases running on it. The lease is up on the server and now
i
> must roll everything over to the new server. What i need to do is join
the
> domain with the new server using a different ip address and name than the
> current SQL server, get everything installed, test it, then take both
servers
> down, rename the new server and change it's ip address to what the old one
> was, and put it into production. Does anyone know how painful this will
be
> and what obstacles i need to look out for? Also, if there's a step by
step
> guide somewhere that'd be pretty great too. The old server has windows
2000
> on it, the new server will have windows 2003. Thanks.

Changing computer name

how to change windows 2000 computer name with SQL 2000 Server on itSQLserver2K will will rename it self.
SQL7&6.5 you need to run the set up
/ Hasselblad
"Thomas Mcintee" <anonymous@.discussions.microsoft.com> skrev i meddelandet
news:6DA36872-2875-45F8-B971-D909C694AD1D@.microsoft.com...
> how to change windows 2000 computer name with SQL 2000 Server on it|||Hi
To change the name of the server you can change it in My
Computer/Properties/Network Identification. Once this is done you can rename
SQL server see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Thomas Mcintee" <anonymous@.discussions.microsoft.com> wrote in message
news:6DA36872-2875-45F8-B971-D909C694AD1D@.microsoft.com...
> how to change windows 2000 computer name with SQL 2000 Server on it|||yes I know where to change it but when i change it SQL tells me it can't find my user name it shows oldname\tom not newname\tom even though it is in windows users and if i try to add it it tells me it doesn't exsist
-- John Bell wrote: --
Hi
To change the name of the server you can change it in My
Computer/Properties/Network Identification. Once this is done you can rename
SQL server see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Thomas Mcintee" <anonymous@.discussions.microsoft.com> wrote in message
news:6DA36872-2875-45F8-B971-D909C694AD1D@.microsoft.com...
> how to change windows 2000 computer name with SQL 2000 Server on it|||I should use, sp_droplogin on master & Sp_dropuser on Userdb and then
recreate them
//Hasselblad
"Thomas McIntee" <anonymous@.discussions.microsoft.com> skrev i meddelandet
news:003A7ECE-7CD7-490F-B6F6-B3DCEC65A4F3@.microsoft.com...
> yes I know where to change it but when i change it SQL tells me it can't
find my user name it shows oldname\tom not newname\tom even though it is in
windows users and if i try to add it it tells me it doesn't exsist
> -- John Bell wrote: --
> Hi
> To change the name of the server you can change it in My
> Computer/Properties/Network Identification. Once this is done you can
rename
> SQL server see
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
> John
> "Thomas Mcintee" <anonymous@.discussions.microsoft.com> wrote in
message
> news:6DA36872-2875-45F8-B971-D909C694AD1D@.microsoft.com...
> > how to change windows 2000 computer name with SQL 2000 Server on it
>
>sql

changed my login password??

I changed my login password to my computer, now I can't start my SQL
services. It says it can't start because of login falure?
Nevermind. I figured it out
|||You need to change password for MSSQLSERVER and SQLSERVERAGENT services.
Go to Computer management console and for this services change password on
the LogOn tab.
I hope this will help.
Ana
"DaveF" <dfetrow@.geodecisions.com> wrote in message
news:OmVPiGoNEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I changed my login password to my computer, now I can't start my SQL
> services. It says it can't start because of login falure?
> --
>
>

changed my login password??

I changed my login password to my computer, now I can't start my SQL
services. It says it can't start because of login falure?
--Nevermind. I figured it out
--|||You need to change password for MSSQLSERVER and SQLSERVERAGENT services.
Go to Computer management console and for this services change password on
the LogOn tab.
I hope this will help.
Ana
"DaveF" <dfetrow@.geodecisions.com> wrote in message
news:OmVPiGoNEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I changed my login password to my computer, now I can't start my SQL
> services. It says it can't start because of login falure?
> --
>
>

changed my login password??

I changed my login password to my computer, now I can't start my SQL
services. It says it can't start because of login falure?Nevermind. I figured it out|||You need to change password for MSSQLSERVER and SQLSERVERAGENT services.
Go to Computer management console and for this services change password on
the LogOn tab.
I hope this will help.
Ana
"DaveF" <dfetrow@.geodecisions.com> wrote in message
news:OmVPiGoNEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I changed my login password to my computer, now I can't start my SQL
> services. It says it can't start because of login falure?
> --
>
>

Change the location of the database files

Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)
Refer to following url
http://support.microsoft.com/default...en-us%3B224071
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
"Gal" <W32.virus@.wanadoo.fr> wrote in message
news:uM8J5PqMEHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to move my base from drive C: to drive D: .How can I do this
> with MSDE (I don't have the MMC installed on the computer where I want to
do
> this)
>
|||hi Gal,
"Gal" <W32.virus@.wanadoo.fr> ha scritto nel messaggio
news:uM8J5PqMEHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to move my base from drive C: to drive D: .How can I do this
> with MSDE (I don't have the MMC installed on the computer where I want to
do
> this)
you can do it detaching the desired database, moving the database files to
the new desired position a,d reattacchin the database...
log into oSql.exe..
1>EXEC sp_detach_db db_name
2>GO
move the file(s) to new location
1>EXEC sp_attach_db @.dbname = 'db_name' ,
2>@.filename1 = 'd:\:fulldatapath_of_DataFile.Mdf' ,
3>@.filename2 = 'd:\:fulldatapath_of_LogFile.Ldf'
4>GO
for your convenienence, you can have a look at a free prj of mine, available
at the link following my sign., which provide a user interface similar to
Enterprise Manager for full MSDE administration...
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Change the location of the base

Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)
Try this article:
http://support.microsoft.com/default...b;en-us;224071
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Gal" <W32.virus@.wanadoo.fr> wrote in message
news:ecXhZPqMEHA.2704@.TK2MSFTNGP10.phx.gbl...
Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)

change sql 2005 server name

I have Sql Server 2005 on my computer and i want to change the name of the server. I found this procedure but i didn't understand how it worked. So the actual name of my server is STATIE4 and i want to change it.

I executed this procedure, but the name of the server is still STATIE4. If i write sp_helpserver STATIE4 it doesn't find STATIE4. What have changed after using this procedure?

sp_dropserver old_name

GO

sp_addserver new_name, local

GO

to restart your SQL Server service. Connect agin and run the following command (It should output the new server name):

SELECT @.@.SERVERNAME
GO

HTH

Change Reporting Services server name

I renamed the computer name for the server running both SQL Server and
Reporting Services. I used sp_dropserver and sp_addserver to correct the
servername for SQL Server, but now I cannot use the Management Studio to
connect to the Reporting Server. I am running SQL 2005. Any ideas how to
fix the name without re-installing?
Thanks,
MattThe Reporting Services Configuration Manager tool has a Database Setup tab
that you can use to set the server name for the ReportServer database
repository.
Steve MunLeeuw
"Matthew Bando" <MatthewBando@.discussions.microsoft.com> wrote in message
news:D3CF59E6-B63C-4B7D-9C0B-DED2357DF561@.microsoft.com...
>I renamed the computer name for the server running both SQL Server and
> Reporting Services. I used sp_dropserver and sp_addserver to correct the
> servername for SQL Server, but now I cannot use the Management Studio to
> connect to the Reporting Server. I am running SQL 2005. Any ideas how to
> fix the name without re-installing?
> Thanks,
> Matt

Change Password

Hi
How do I do when it's time to change the password on the
computer. When I do that I can no longer start up the SQL
server. I quess that I have to make som changes in the Sql
server, but where'
/AnettHi
Control Panel > Services
Or under service properties forthe SQL Server in Entrprise Manager
If this is a production SQL Server, you should create a special account on
the domain for SQL Server that does not require password changes.
Regards
Mike
"Anett" wrote:
> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where'
> /Anett
>|||Instead of using the Services tab, it is better to change passwords in SQL
Enterprise Manager... This gets around some issues if you are running
full-text search, so I always use SEM... Don't forget to change the password
for any other shared services like SQL Agent...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:3bfc01c4c574$9d0d76c0$a401280a@.phx.gbl...
> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where'
> /Anett

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 !
Desmond
Desmond
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/inf...erver_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/de...stall_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

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/in...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-installati
on ?
> TIA !
> Desmond|||Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/d...nstall_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-installati
on ?
> TIA !
> Desmond

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