Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Renaming an SQL Server

5 posts in Windows NT Last posting was on 2000-05-22 13:41:56.0Z
Wallace Henry Posted on 2000-05-17 13:27:54.0Z
Reply-To: "Wallace Henry" <whenry@futurenext.com>
From: "Wallace Henry" <whenry@futurenext.com>
Subject: Renaming an SQL Server
Date: Wed, 17 May 2000 09:27:54 -0400
Lines: 7
Organization: FutureNext Consulting
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <qSreOOAw$GA.290@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host197.futurenext.com 208.203.71.197
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2158
Article PK: 1089584

Once I've installed SQL server, is there anyway to rename it?? (Using
version 11.02.1). I was told taht there are tables that reference the server
name and taht you can run a script to update them, but I'm not sure of how
to ascertain the names of all tables/fields affected. Is there a command or
a utility that does the same thing?? Thanks.


"Mark A. Parsons" <pegasys Posted on 2000-05-19 07:08:26.0Z
Message-ID: <3924E86A.8457C756@_internet.co.nz>
Date: Fri, 19 May 2000 19:08:26 +1200
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000), Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Renaming an SQL Server
References: <qSreOOAw$GA.290@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 37
NNTP-Posting-Host: p331.ipa1-n8-16.iconz.net.nz 210.48.25.75
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2150
Article PK: 1089590


Wallace Henry wrote:

> Once I've installed SQL server, is there anyway to rename it?? (Using
> version 11.02.1). I was told taht there are tables that reference the server
> name and taht you can run a script to update them, but I'm not sure of how
> to ascertain the names of all tables/fields affected. Is there a command or
> a utility that does the same thing?? Thanks.

To rename a Sybase dataserver you ...

1) Change the name in the interfaces file
2) Change the name of your RUNSERVER file, plus the appropriate argument/flag
within the script (just edit/change the name string)
3) If you ran 'sp_addserver <old_server_name>, local' ... then run
'sp_dropserver <old_server_name>' and re-run 'sp_addserver <new_server_name>,
local' with the new name (if you ran 'sp_addserver <old_server_name>,local' in
the past, and have since bounced the dataserver, you'll find that 'select
@@servername' returns what the dataserver thinks is it's own name)
4) Bounce the server to get the name change to take effect (this will change
@@servername)
5) Make any necessary name changes in your programs and scripts

If you happen to be running RepServer against this dataserver you'll probably be
better off just re-installing RepServer as opposed to going through and
modifying config files, rep def's, subscriptions, etc., etc., etc.

--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (200), Ltd pegasys@internet.co.nz


Eric McGrane Posted on 2000-05-19 13:17:56.0Z
Message-ID: <39253F04.B43E606F@sybase.com>
Date: Fri, 19 May 2000 09:17:56 -0400
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: "Mark A. Parsons" <pegasys@_internet.co.nz>
Subject: Re: Renaming an SQL Server
References: <qSreOOAw$GA.290@forums.sybase.com> <3924E86A.8457C756@_internet.co.nz>
Content-Type: multipart/mixed; boundary="------------0AE2B818F1842A44D621C073"
Newsgroups: sybase.public.sqlserver.nt
Lines: 67
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2148
Article PK: 1089579

Mark got everything with one exception. Those servers that rpc to the now renamed
server will also likely need to have their reference to the server corrected by
dropping and readding the server. If these servers are on remote machines they will
need to have their interfaces files updated as well.

E

"Mark A. Parsons" wrote:

> Wallace Henry wrote:
>
> > Once I've installed SQL server, is there anyway to rename it?? (Using
> > version 11.02.1). I was told taht there are tables that reference the server
> > name and taht you can run a script to update them, but I'm not sure of how
> > to ascertain the names of all tables/fields affected. Is there a command or
> > a utility that does the same thing?? Thanks.
>
> To rename a Sybase dataserver you ...
>
> 1) Change the name in the interfaces file
> 2) Change the name of your RUNSERVER file, plus the appropriate argument/flag
> within the script (just edit/change the name string)
> 3) If you ran 'sp_addserver <old_server_name>, local' ... then run
> 'sp_dropserver <old_server_name>' and re-run 'sp_addserver <new_server_name>,
> local' with the new name (if you ran 'sp_addserver <old_server_name>,local' in
> the past, and have since bounced the dataserver, you'll find that 'select
> @@servername' returns what the dataserver thinks is it's own name)
> 4) Bounce the server to get the name change to take effect (this will change
> @@servername)
> 5) Make any necessary name changes in your programs and scripts
>
> If you happen to be running RepServer against this dataserver you'll probably be
> better off just re-installing RepServer as opposed to going through and
> modifying config files, rep def's, subscriptions, etc., etc., etc.
>
> --
> Mark A. Parsons
>
> Iron Horse, Inc. iron_horse@compuserve.com
> Pegasys (200), Ltd pegasys@internet.co.nz


Download VCard mcgrane.vcf


"Mark A. Parsons" <pegasys Posted on 2000-05-20 06:03:04.0Z
Message-ID: <39262A98.696D8CA3@_internet.co.nz>
Date: Sat, 20 May 2000 18:03:04 +1200
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Renaming an SQL Server
References: <qSreOOAw$GA.290@forums.sybase.com> <3924E86A.8457C756@_internet.co.nz> <39253F04.B43E606F@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 21
NNTP-Posting-Host: p350.ipa1-n8-16.iconz.net.nz 210.48.25.94
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2146
Article PK: 1089578


> Mark got everything with one exception. Those servers that rpc to the now renamed
> server will also likely need to have their reference to the server corrected by
> dropping and readding the server. If these servers are on remote machines they will
> need to have their interfaces files updated as well.

Of course, if the 'new' dataserver is using the same IP address and port as the 'old'
dataserver, and you don't change the interfaces file for those servers conducting the
rpc's into the 'new' dataserver ... they should still connect just fine using the 'old'
name. Of course, it could definitely get confusing tracking down problems with a server
being referenced by different names.

--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (200), Ltd pegasys@internet.co.nz


Eric McGrane Posted on 2000-05-22 13:41:56.0Z
Message-ID: <39293924.3D6DCFAB@sybase.com>
Date: Mon, 22 May 2000 09:41:56 -0400
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: "Mark A. Parsons" <pegasys@_internet.co.nz>
Subject: Re: Renaming an SQL Server
References: <qSreOOAw$GA.290@forums.sybase.com> <3924E86A.8457C756@_internet.co.nz> <39253F04.B43E606F@sybase.com> <39262A98.696D8CA3@_internet.co.nz>
Content-Type: multipart/mixed; boundary="------------FDB114EE1132F85B570D114F"
Newsgroups: sybase.public.sqlserver.nt
Lines: 45
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2134
Article PK: 1089566

Mark,

Your absolutely correct, that's why I said "likely". I should have been more explicit.

E

"Mark A. Parsons" wrote:

> > Mark got everything with one exception. Those servers that rpc to the now renamed
> > server will also likely need to have their reference to the server corrected by
> > dropping and readding the server. If these servers are on remote machines they will
> > need to have their interfaces files updated as well.
>
> Of course, if the 'new' dataserver is using the same IP address and port as the 'old'
> dataserver, and you don't change the interfaces file for those servers conducting the
> rpc's into the 'new' dataserver ... they should still connect just fine using the 'old'
> name. Of course, it could definitely get confusing tracking down problems with a server
> being referenced by different names.
>
> --
> Mark A. Parsons
>
> Iron Horse, Inc. iron_horse@compuserve.com
> Pegasys (200), Ltd pegasys@internet.co.nz


Download VCard mcgrane.vcf