|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Host Name Change - SQL Server won't start
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Host Name Change - SQL Server won't start
|
|
| Evan Kouroupis 2002-11-08, 7:23 am |
| How do you get SQL server to start after you change the
hostname of the system its installed on.
Thank you in advance.
| |
| Stefan 2002-11-08, 7:23 am |
| Evan
I assume you're talking about sql7. Run the setup again from the CD; at some
point, it will ask you if you want to upgrade to standard version. Say yes
and you're all set. Start the service, than run this as sa:
exec sp_dropserver <old_server_name>
go
exec sp_addserver <new_server_name>, local
go
Restart services again.
"Evan Kouroupis" <ekouroupis@enghouse.com> wrote in message
news:917701c28725$9cf5a840$37e
f2ecf@TKMSFTNGXA13...
> How do you get SQL server to start after you change the
> hostname of the system its installed on.
>
>
>
> Thank you in advance.
>
>
| |
| Wayne Snyder 2002-11-11, 8:23 am |
| IN addition to Stefan's comment... It doesn't really re-install SQL Server,
but just fixes up some registry entries... It doesn' run but a minute.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Evan Kouroupis" <ekouroupis@enghouse.com> wrote in message
news:917701c28725$9cf5a840$37e
f2ecf@TKMSFTNGXA13...
> How do you get SQL server to start after you change the
> hostname of the system its installed on.
>
>
>
> Thank you in advance.
>
>
|
|
|
|
|