| Author |
Topic |
|
daidaluus
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-17 : 06:57:21
|
| At work some has changed Server Machine's name and SQL Server does not work.how can i solve this problem? |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-05-17 : 09:15:57
|
| use server's ip address .-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-17 : 09:40:12
|
| In SQL Server 2K it's easy, just use this stored procedures.sp_dropserver 'old_server_name'sp_addserver 'new_server_name'In SQL Server 7 you need one more step,after you change the server name and reboot SQL server will complain...not able to start and so on.Run setup,this will tell you that setup is going to upgrade your system and this will change the registry.Reboot once again and with QA use the 2 strored procedures.After this step delete server registration in EM then reregister.HTHFranco |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-05-17 : 10:08:39
|
quote:
use server's ip address .-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson
Nazim, after you rename the machine, SQL Server usually refuses to start up. I guess using the IP address hardly helps  OS |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2003-05-17 : 13:53:58
|
| I cannot connect to sql server and as a result execute sp_dropserver, sp_addserver, or any other sp.ValterBorgesi already searched microsoft's web and found nothing. can you post the exect address(es) on microsoft's web? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-18 : 19:12:04
|
| What version of SQL? In 7.0 it will tell you to rerun setup, which is what you need to do to fix it. (Then run sp_dropserver and sp_addserver).-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-05-19 : 04:35:57
|
i was under the impression , that the client cant access Sql server. my bad.quote:
Nazim, after you rename the machine, SQL Server usually refuses to start up. I guess using the IP address hardly helps
-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-05-19 : 09:36:46
|
| Hey Nazim, seen you around after a really long time...welcome back P.S. Are you working at DIC?OS |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-05-19 : 10:09:06
|
yeah, Am busy in a new project . but i do miss sqlteamquote:
Hey Nazim, seen you around after a really long time...welcome back
nah!, though would love to. if u r workign there and u find a opening do recommend me:)quote:
P.S. Are you working at DIC?
-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
Shastryv
Posting Yak Master
145 Posts |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-19 : 11:23:47
|
| I have run across one other problem with name server changes when using SQL 2000. If you have any jobs defined in the SQL Server Agent, you can no longer edit them because the originating_server field in the sysjobs table still has the old server name listed. In the past I have had to allow updates to the system tables and change the name in this field to reflect the new server name.Jeff Banschbach, MCDBA |
|
|
|
|
Server name changed