Changing the server name and IP address

A server with SQL 2000 installed is moving to a new physical location. Our
company standards mean that the name of the server and the IP address of the
server will change also. This SQL instance name is the same as the server
name. Will I have to uninstall and reinstall SQL Server (and recover the
databases) when this move is made so that the instance name equals the
server name? Is there a stored procedure that changes the instance name to
the server name? Thank you.[posted and mailed, please reply in news]

steven virnig (pezguy@.mn.rr.com) writes:
> A server with SQL 2000 installed is moving to a new physical location.
> Our company standards mean that the name of the server and the IP
> address of the server will change also. This SQL instance name is the
> same as the server name. Will I have to uninstall and reinstall SQL
> Server (and recover the databases) when this move is made so that the
> instance name equals the server name? Is there a stored procedure that
> changes the instance name to the server name? Thank you.

If memory serves, it's as simple as:

exec sp_dropserver @.@.servername
exec sp_addserver 'NewName', 'local'

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

CHANGING THE REPLICATION SERVER IP

Are you using IP address as the server registration, or
the netbiosname. If it is the latter then there is no
issue. If the former, then I would recommend using
aliases in the client network utility to avoid recreating
the publications.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Thanks for ur reply.
Now In the replication the publisher is in alise name & subscriber is in IP.
I can change the publisher IP but can't the subscriber IP.
I tried to set a test replication with both publisher & subscriber are in
alise name.
But when I set the push subscription, the replication stops & the error
message
comes "The subscription to publication 'databasename' is invalid".
What is the reason for this?
Is it possible to set both pub & sub servers in alise name ?
Thanks,
Soura
"Paul Ibison" wrote:

> Are you using IP address as the server registration, or
> the netbiosname. If it is the latter then there is no
> issue. If the former, then I would recommend using
> aliases in the client network utility to avoid recreating
> the publications.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Yes - on the subscriber for a pull subscription you can
set the publisher in the client network utility. On the
publisher in enterprise manager, you can register the
publisher using an alias. If it is push, you's also
create an alias for the subscriber. Alternatively,
assuming you have trusted domains, you could just not use
the IP addresses at all - the netbiosnames would be more
suitable.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Changing the IP address of a SQL 2000 SP3a server

What is the proper procedure for changing the IP address of a SQL 2000
Server?
Are there any gotchas, or is it as straight forward as just changing the
IP address?
Hi,
Rob Gordon
No procedures to follow to change the IP address. You can do straight away.
Nothing will happen.
"Rob Gordon" wrote:

> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
>
|||Only impact will be if any clients/programs, etc. find it via the IP address
instead of the server name.. or is that changing, also.
Regards,
Hank Arnold
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
|||You will need to stop/start the service after the address change. SQL binds
to whatever IP addresses exist at service startup time.
If you are running a cluster, that is an entirely different proposition.
You should repost the question in the .clustering newsgroup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
|||On Wed, 26 Jan 2005 20:26:03 -0800, Rob Gordon
<Robert.Gordon@.nospam.yosemitetech.com> wrote:

>What is the proper procedure for changing the IP address of a SQL 2000
>Server?
Change the IP.

>Are there any gotchas, or is it as straight forward as just changing the
>IP address?
Remember to update any DNS records you may need to, and if a client
connects via the IP address, it will need changing as well.
Jeff

Changing the IP address of a SQL 2000 SP3a server

What is the proper procedure for changing the IP address of a SQL 2000
Server?
Are there any gotchas, or is it as straight forward as just changing the
IP address?Hi,
Rob Gordon
No procedures to follow to change the IP address. You can do straight away.
Nothing will happen.
"Rob Gordon" wrote:

> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
>|||Only impact will be if any clients/programs, etc. find it via the IP address
instead of the server name.. or is that changing, also.
--
Regards,
Hank Arnold
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?|||You will need to stop/start the service after the address change. SQL binds
to whatever IP addresses exist at service startup time.
If you are running a cluster, that is an entirely different proposition.
You should repost the question in the .clustering newsgroup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?|||On Wed, 26 Jan 2005 20:26:03 -0800, Rob Gordon
<Robert.Gordon@.nospam.yosemitetech.com> wrote:

>What is the proper procedure for changing the IP address of a SQL 2000
>Server?
Change the IP.

>Are there any gotchas, or is it as straight forward as just changing the
>IP address?
Remember to update any DNS records you may need to, and if a client
connects via the IP address, it will need changing as well.
Jeff

Changing the IP address of a SQL 2000 SP3a server

What is the proper procedure for changing the IP address of a SQL 2000
Server?
Are there any gotchas, or is it as straight forward as just changing the
IP address?Hi,
Rob Gordon
No procedures to follow to change the IP address. You can do straight away.
Nothing will happen.
"Rob Gordon" wrote:
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
>|||Only impact will be if any clients/programs, etc. find it via the IP address
instead of the server name.. or is that changing, also.
--
Regards,
Hank Arnold
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?|||You will need to stop/start the service after the address change. SQL binds
to whatever IP addresses exist at service startup time.
If you are running a cluster, that is an entirely different proposition.
You should repost the question in the .clustering newsgroup.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?|||On Wed, 26 Jan 2005 20:26:03 -0800, Rob Gordon
<Robert.Gordon@.nospam.yosemitetech.com> wrote:
>What is the proper procedure for changing the IP address of a SQL 2000
>Server?
Change the IP. :)
>Are there any gotchas, or is it as straight forward as just changing the
>IP address?
Remember to update any DNS records you may need to, and if a client
connects via the IP address, it will need changing as well.
Jeff

Changing the FROM in the email on a subscription

I need to change the email address that appears as the FROM email on reports
that are being delivered via RS2000. I have change the REPLY email and that
is working correctly but I can't seem to find where the FROM email is stored.
Thanks...It is configurable in the rsreportserver.config file on the report
server machine; edit that file and look for the <FROM> tag under the
<RSEmailDPConfiguration> section
Matt A
Steve wrote:
> I need to change the email address that appears as the FROM email on reports
> that are being delivered via RS2000. I have change the REPLY email and that
> is working correctly but I can't seem to find where the FROM email is stored.
> Thanks...|||That did it! Thanks Matt!!!
"Matt" wrote:
> It is configurable in the rsreportserver.config file on the report
> server machine; edit that file and look for the <FROM> tag under the
> <RSEmailDPConfiguration> section
> Matt A
>
> Steve wrote:
> > I need to change the email address that appears as the FROM email on reports
> > that are being delivered via RS2000. I have change the REPLY email and that
> > is working correctly but I can't seem to find where the FROM email is stored.
> > Thanks...
>|||what if I want to have a diffrent from address for each send?
same as you bind the To and the CC? can it be done?
"Steve" wrote:
> That did it! Thanks Matt!!!
> "Matt" wrote:
> > It is configurable in the rsreportserver.config file on the report
> > server machine; edit that file and look for the <FROM> tag under the
> > <RSEmailDPConfiguration> section
> >
> > Matt A
> >
> >
> > Steve wrote:
> > > I need to change the email address that appears as the FROM email on reports
> > > that are being delivered via RS2000. I have change the REPLY email and that
> > > is working correctly but I can't seem to find where the FROM email is stored.
> > > Thanks...
> >
> >

changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

changing subscription email address in RS2000

Is there a way I can change the email address associated to sending timed
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
JacksonNevermind figured it out.
You need to edit the RSReportServer.config file. I had to do a find of the
email address I wanted to replace.
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:umjwsLDCHHA.3924@.TK2MSFTNGP02.phx.gbl...
> Is there a way I can change the email address associated to sending timed
> reports notifications to users?
> Currently it is under my email address and I would like it to change to a
> different email address.
> TIA,
> Jackson
>
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.
from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

changing SQL Server IP address

Hi All

Will changing SQL Server IP address affecting/break anything in sql server? Thank you in advance.

Possibly not, depending on your environment.

The critical thing is that all connection strings and references to the server must use it's NetBIOS name or DNS name. If you don't know what you're using, it's probably NetBIOS and thus you're probably ok :)

Also, if you change the IP address, any open connections to the server will break. So be sure you do this at a pre-determined downtime :)

-Ryan / Kardax

Changing smtp and from values

During the install wizard prompts where presented for a
SMTP address and a FROM value. I want to change these
values now, How do I do this?Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
Be sure to make a copy first :)
Bruce L-C
"Jim Abel" <jim.abel@.lmco.com> wrote in message
news:268801c47030$1efc9f70$a501280a@.phx.gbl...
> During the install wizard prompts where presented for a
> SMTP address and a FROM value. I want to change these
> values now, How do I do this?|||Edit the RSReportServer.config file found in %PROGRAMFILES%\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\ folder:
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Abel" <jim.abel@.lmco.com> wrote in message
news:268801c47030$1efc9f70$a501280a@.phx.gbl...
> During the install wizard prompts where presented for a
> SMTP address and a FROM value. I want to change these
> values now, How do I do this?

Changing Server Name And IP address

We are going to be moving our company to a new location. Changing server
names and Ip address of the servers. I am trying to find out and research
possible impact to the SQL databases we have. Any information on this links
etc would be a great help. If there are any impacts at all. This will be
servers only.Renaming a Server
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
AMB
"RussN" wrote:

> We are going to be moving our company to a new location. Changing server
> names and Ip address of the servers. I am trying to find out and research
> possible impact to the SQL databases we have. Any information on this lin
ks
> etc would be a great help. If there are any impacts at all. This will be
> servers only.|||... which unfortunately doesn't mention jobs, so also look at
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...[vbcol=seagreen]
> Renaming a Server
> http://msdn.microsoft.com/library/d...nstall_5r8f.asp
>
> AMB
> "RussN" wrote:
>|||And then there is the whole cluster issue. If you have a cluster to move,
hire an expert. He will tell you to rebuild it from scratch in the new
location.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
> ... which unfortunately doesn't mention jobs, so also look at
> http://www.karaszi.com/SQLServer/in...server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
> message news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
>|||Good catch, Geoff. I've updated my article with a note on this. Let me know
if you want me to remove
the credits, or change it. :-)
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
> And then there is the whole cluster issue. If you have a cluster to move,
hire an expert. He
> will tell you to rebuild it from scratch in the new location.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>|||Thanks for the credit.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uiBZBtQnFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Good catch, Geoff. I've updated my article with a note on this. Let me
> know if you want me to remove the credits, or change it. :-)
> http://www.karaszi.com/SQLServer/in...server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
>

Changing Server Name And IP address

We are going to be moving our company to a new location. Changing server
names and Ip address of the servers. I am trying to find out and research
possible impact to the SQL databases we have. Any information on this links
etc would be a great help. If there are any impacts at all. This will be
servers only.
Renaming a Server
http://msdn.microsoft.com/library/de...stall_5r8f.asp
AMB
"RussN" wrote:

> We are going to be moving our company to a new location. Changing server
> names and Ip address of the servers. I am trying to find out and research
> possible impact to the SQL databases we have. Any information on this links
> etc would be a great help. If there are any impacts at all. This will be
> servers only.
|||... which unfortunately doesn't mention jobs, so also look at
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...[vbcol=seagreen]
> Renaming a Server
> http://msdn.microsoft.com/library/de...stall_5r8f.asp
>
> AMB
> "RussN" wrote:
|||And then there is the whole cluster issue. If you have a cluster to move,
hire an expert. He will tell you to rebuild it from scratch in the new
location.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
> ... which unfortunately doesn't mention jobs, so also look at
> http://www.karaszi.com/SQLServer/inf...erver_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
> message news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
>
|||Good catch, Geoff. I've updated my article with a note on this. Let me know if you want me to remove
the credits, or change it. :-)
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
> And then there is the whole cluster issue. If you have a cluster to move, hire an expert. He
> will tell you to rebuild it from scratch in the new location.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>
|||Thanks for the credit.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uiBZBtQnFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Good catch, Geoff. I've updated my article with a note on this. Let me
> know if you want me to remove the credits, or change it. :-)
> http://www.karaszi.com/SQLServer/inf...erver_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
>

Changing Server Name And IP address

We are going to be moving our company to a new location. Changing server
names and Ip address of the servers. I am trying to find out and research
possible impact to the SQL databases we have. Any information on this links
etc would be a great help. If there are any impacts at all. This will be
servers only.Renaming a Serve
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
AMB
"RussN" wrote:
> We are going to be moving our company to a new location. Changing server
> names and Ip address of the servers. I am trying to find out and research
> possible impact to the SQL databases we have. Any information on this links
> etc would be a great help. If there are any impacts at all. This will be
> servers only.|||... which unfortunately doesn't mention jobs, so also look at
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
> Renaming a Server
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
>
> AMB
> "RussN" wrote:
>> We are going to be moving our company to a new location. Changing server
>> names and Ip address of the servers. I am trying to find out and research
>> possible impact to the SQL databases we have. Any information on this links
>> etc would be a great help. If there are any impacts at all. This will be
>> servers only.|||And then there is the whole cluster issue. If you have a cluster to move,
hire an expert. He will tell you to rebuild it from scratch in the new
location. :)
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
> ... which unfortunately doesn't mention jobs, so also look at
> http://www.karaszi.com/SQLServer/info_change_server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
> message news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
>> Renaming a Server
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
>>
>> AMB
>> "RussN" wrote:
>> We are going to be moving our company to a new location. Changing
>> server
>> names and Ip address of the servers. I am trying to find out and
>> research
>> possible impact to the SQL databases we have. Any information on this
>> links
>> etc would be a great help. If there are any impacts at all. This will
>> be
>> servers only.
>|||Good catch, Geoff. I've updated my article with a note on this. Let me know if you want me to remove
the credits, or change it. :-)
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
> And then there is the whole cluster issue. If you have a cluster to move, hire an expert. He
> will tell you to rebuild it from scratch in the new location. :)
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> ... which unfortunately doesn't mention jobs, so also look at
>> http://www.karaszi.com/SQLServer/info_change_server_name.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
>> news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
>> Renaming a Server
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
>>
>> AMB
>> "RussN" wrote:
>> We are going to be moving our company to a new location. Changing server
>> names and Ip address of the servers. I am trying to find out and research
>> possible impact to the SQL databases we have. Any information on this links
>> etc would be a great help. If there are any impacts at all. This will be
>> servers only.
>|||Thanks for the credit.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uiBZBtQnFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Good catch, Geoff. I've updated my article with a note on this. Let me
> know if you want me to remove the credits, or change it. :-)
> http://www.karaszi.com/SQLServer/info_change_server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:%23ZRYykQnFHA.3480@.TK2MSFTNGP10.phx.gbl...
>> And then there is the whole cluster issue. If you have a cluster to
>> move, hire an expert. He will tell you to rebuild it from scratch in the
>> new location. :)
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:e9NHYjQnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> ... which unfortunately doesn't mention jobs, so also look at
>> http://www.karaszi.com/SQLServer/info_change_server_name.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
>> message news:EEA5AE3D-5BBB-4335-99A0-71B0FB7C9556@.microsoft.com...
>> Renaming a Server
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
>>
>> AMB
>> "RussN" wrote:
>> We are going to be moving our company to a new location. Changing
>> server
>> names and Ip address of the servers. I am trying to find out and
>> research
>> possible impact to the SQL databases we have. Any information on this
>> links
>> etc would be a great help. If there are any impacts at all. This
>> will be
>> servers only.
>>
>

Changing result set - Abbreviations

Hello,
I have a table that stores Customer data (e.g. ID, Name,
Type, Address etc)
In the column 'Type' I store either 'B' for Business
or 'P' for private.
When I return a result set I would like to see the
words 'Business' or 'Private', rather than 'B' or 'P'
How would I do this?
Thanks,
BillyThis is a multi-part message in MIME format.
--=_NextPart_000_0206_01C3600A.432E19A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try:
select
case
when Type =3D 'B' then 'Business'
when Type =3D 'P' then 'Private'
end
from
MyTable
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Billy" <billyrotorwing@.hotmail.com> wrote in message =news:079b01c3602a$61c354f0$a001280a@.phx.gbl...
Hello,
I have a table that stores Customer data (e.g. ID, Name, Type, Address etc)
In the column 'Type' I store either 'B' for Business or 'P' for private.
When I return a result set I would like to see the words 'Business' or 'Private', rather than 'B' or 'P'
How would I do this?
Thanks,
Billy
--=_NextPart_000_0206_01C3600A.432E19A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Try:
select
=case
= when Type =3D 'B' then 'Business'
= when Type =3D 'P' then 'Private'
=end
from
=MyTable
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Billy" wrote in message news:079b01c3602a$61=c354f0$a001280a@.phx.gbl...Hello,I have a table that stores Customer data (e.g. ID, Name, Type, Address =etc)In the column 'Type' I store either 'B' for Business or ='P' for private. When I return a result set I would like to see the =words 'Business' or 'Private', rather than 'B' or 'P'How would I do this?Thanks,Billy

---

--=_NextPart_000_0206_01C3600A.432E19A0--

Changing IP Addresses of a cluster

I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes as well as the virtual IP address. In doing this, I want to make sure that I have the proper process dow
n correctly.
1. Change the IP addresses of each node as referenced in KB 230356
2. Change the IP addresses of the virtual cluster as referenced in KB 244980
Is this correct? Am I missing anything?
Thanks in advance for your assistance!
Replace IP ONLY and ONLY through SQL setup with remove option
rgds
Sinisa Perovic
|||

Quote:

Originally posted by DBADave
I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes as well as the virtual IP address. In doing this, I want to make sure that I have the proper process dow
n correctly.
1. Change the IP addresses of each node as referenced in KB 230356
2. Change the IP addresses of the virtual cluster as referenced in KB 244980
Is this correct? Am I missing anything?
Thanks in advance for your assistance!

Dave, did this work out smoothly? I'll have to do the exact same thing. Did it work after changing node IPs then using SQL setup to change the virtual SQL server IP?
Thanks,
Matt.

Changing IP address

If I change the IP addresson the server that I am running
SQL Server on I can no longer access Enterprise Manager?
How do I fix that?Sounds like a name resolution problem.
Suggest registering the servers IP Address in EM rather than it's name
--
HTH
Ryan Waight, MCDBA, MCSE
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If EM is using the IP address in the server registration, you will have to
remove the registration and re-register it. If you have not changed your DNS
(or hosts file) to reflect the new IP address then you will not be able to
access the server.
Can you PING the server by name?
John
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If it is a name resolution problem then it would be better to sort out the
network problem!
John
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:u9qZKn%23lDHA.3256@.tk2msftngp13.phx.gbl...
> Sounds like a name resolution problem.
> Suggest registering the servers IP Address in EM rather than it's name
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Bryan" <earlyriser@.knology.net> wrote in message
> news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> > If I change the IP addresson the server that I am running
> > SQL Server on I can no longer access Enterprise Manager?
> > How do I fix that?
>