This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C5198B.423A4230
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi.
Due to corporate guidelines we are "forced" to change the name of our = Windows 2000 server which runs our precious SQL 7.0 server. I guess = there are some issues I have to deal with afterwards to get the database = engine up and about. Do any of you have good resources (URL's) or other = information which you may share with me, to enable us rename our server = without to much hassle. Please.
Bst Regards
Mr. Smith
--=_NextPart_000_0008_01C5198B.423A4230
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi.
Due to corporate guidelines we are = "forced" to change the name of our Windows 2000 server which runs our precious SQL = 7.0 server. I guess there are some issues I have to deal with afterwards to = get the database engine up and about. Do any of you have good resources (URL's) = or other information which you may share with me, to enable us rename our server = without to much hassle. Please.
Bst Regards
Mr. Smith
--=_NextPart_000_0008_01C5198B.423A4230--This is a multi-part message in MIME format.
--=_NextPart_000_0178_01C5199A.A55BC500
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message =news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our =Windows 2000 server which runs our precious SQL 7.0 server. I guess =there are some issues I have to deal with afterwards to get the database =engine up and about. Do any of you have good resources (URL's) or other =information which you may share with me, to enable us rename our server =without to much hassle. Please.
Bst Regards
Mr. Smith
--=_NextPart_000_0178_01C5199A.A55BC500
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1491" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi</FONT></DIV>
<DIV><FONT size=3D2>Look at sp_dropserver and sp_addserver in the BOL.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Mr. Smith" <<A =href=3D"mailto:nospam@.blindfolded.gone">nospam@.blindfolded.gone</A>> =wrote in message <A =href=3D"news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl">news:uB9V6KYGFHA.444@.T=K2MSFTNGP15.phx.gbl</A>...</DIV>
<DIV>Hi.</DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN style=3D"mso-ansi-language: EN-US">Due to corporate guidelines we are ="forced" to change the name of our Windows 2000 server which runs our precious =SQL 7.0 server. I guess there are some issues I have to deal with afterwards =to get the database engine up and about. Do any of you have good resources =(URL's) or other information which you may share with me, to enable us rename our =server without to much hassle. Please.<o:p></o:p></SPAN></P></DIV>
<DIV> </DIV>
<DIV>Bst Regards</DIV>
<DIV>Mr. Smith</DIV></BLOCKQUOTE></BODY></HTML>
--=_NextPart_000_0178_01C5199A.A55BC500--|||This is a multi-part message in MIME format.
--=_NextPart_000_0140_01C51993.260B9F70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
After having renamed the server, you just need to run sp_dropserver and =then sp_addserver. You can look up the syntax in BOL.
Regards
Steen "Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse =news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our =Windows 2000 server which runs our precious SQL 7.0 server. I guess =there are some issues I have to deal with afterwards to get the database =engine up and about. Do any of you have good resources (URL's) or other =information which you may share with me, to enable us rename our server =without to much hassle. Please.
Bst Regards
Mr. Smith
--=_NextPart_000_0140_01C51993.260B9F70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>After having renamed the server, you =just need to run sp_dropserver and then sp_addserver. You can look up the syntax in BOL.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Steen</FONT> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Mr. Smith" <<A =href=3D"mailto:nospam@.blindfolded.gone">nospam@.blindfolded.gone</A>> =skrev i en meddelelse <A =href=3D"news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl">news:uB9V6KYGFHA.444@.T=K2MSFTNGP15.phx.gbl</A>...</DIV>
<DIV>Hi.</DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN style=3D"mso-ansi-language: EN-US">Due to corporate guidelines we are ="forced" to change the name of our Windows 2000 server which runs our precious =SQL 7.0 server. I guess there are some issues I have to deal with afterwards =to get the database engine up and about. Do any of you have good resources =(URL's) or other information which you may share with me, to enable us rename our =server without to much hassle. Please.<o:p></o:p></SPAN></P></DIV>
<DIV> </DIV>
<DIV>Bst Regards</DIV>
<DIV>Mr. Smith</DIV></BLOCKQUOTE></BODY></HTML>
--=_NextPart_000_0140_01C51993.260B9F70--|||There's more to it than only sp_dropserver and sp_addserver. Especially for a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/info_change_server_name.asp for more information.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or other information which
you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/info_change_server_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment