How to rename a SQL-server

[Alex Kwak]

Hi all,

I would very much like to rename my SQL-server from 'NTSERVER' to
'SERVER2', but I don't know how to do this.

Anyone?

Thanks in advance,

Alex Kwak
Assist Consultancy
Apeldoorn, the Netherlands
email: ak...@assist-consult.nl

[Neil Pike]

Alex,

> I would very much like to rename my SQL-server from 'NTSERVER' to
> 'SERVER2', but I don't know how to do this.

Q. How do I change the name of SQL Server?

A. If you change the NT name of a server and want to change SQL Server 6.5 or
below to match it then do :-

sp_dropserver "<oldname>"
go
sp_addserver "<newname>", local

You have to stop and restart SQL Server for it to take effect. The SQL Server
Programmers Toolkit recommends doing this with SQL Server started in minimal
configuration mode (sqlservr -f from the command prompt). In addition, if you
use the IPX/SPX netlib for SQL Server connectivity you must also run the SQL
Setup, choose the option to change the network support, and fix the server name
in there too.

If you change the NT name, SQL 7.0 will warn you that your installation is
corrupt and will insist you re-run setup. Setup will ask if you want to
'upgrade', but all it does is detect the name conflict, resolve it, and then
finish. You still have to run sp_dropserver and sp_addserver to get the new
name in the error log and in @@servername.

===

v1.06 2000.04.15
Applies to SQL Server versions : All
FAQ Categories : Server Administration and Tools
Related FAQ articles : computername
Related Microsoft Kb articles : n/a
Other related information : "How to change to the current server name in
the 6.x master database (ISQL/w)" in SQL Server Programmers Toolkit and Books
Online 7.
Authors : Neil Pike

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
or http://www.ntfaq.com/Section.cfm?sectionID=34
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

[Alex Kwak]

Thanks, I bookmarked the FAQ now...

Alex.

Neil Pike <10057...@compuserve.com> schreef in berichtnieuws
VA.00000df...@compuserve.com...