| Author |
Server Renaming Problems!!!
|
|
|
| I have a SQL 7 server that I renamed. It wouldn't start after that (I had
forgotten that SQL 7 didn't respond well to name changes) so I put the cd in
and updated the system but the SQL service STILL doesn't start. Now when I
put the cd in it doesn't give me the option of updating it just goes right
into the setup. I had actually played around with the naming of the server
so I'm not sure if that was part of the problem.
How do I fix this? Is there a registry key to look for? I need to get this
server up cause I need to get DTS jobs out of it before I blow it away.
TIA!!
jj
| |
| Andy S. 2005-07-19, 11:23 am |
| You can try to start SQL in single user mode from a command prompt and
rename it back. You can't export sqldts packages, but you may be able to
resolve the issue. You should also look in Event Viewer to see if there are
any errors there to look at.
sqlservr.exe -c -m
Look in SQL Server Books online under rebuilding master database to see how
to use that. Sometimes running sp_addserver '<servername>' to readd the
servername helps. Good luck.
"jj" <jeff_detoro@urmc.rochester.edu> wrote in message
news:elwTyNHjFHA.4028@TK2MSFTNGP10.phx.gbl...
>I have a SQL 7 server that I renamed. It wouldn't start after that (I had
>forgotten that SQL 7 didn't respond well to name changes) so I put the cd
>in and updated the system but the SQL service STILL doesn't start. Now when
>I put the cd in it doesn't give me the option of updating it just goes
>right into the setup. I had actually played around with the naming of the
>server so I'm not sure if that was part of the problem.
>
> How do I fix this? Is there a registry key to look for? I need to get this
> server up cause I need to get DTS jobs out of it before I blow it away.
>
> TIA!!
> jj
>
| |
| Rick Sawtell 2005-07-19, 11:23 am |
|
"jj" <jeff_detoro@urmc.rochester.edu> wrote in message
news:elwTyNHjFHA.4028@TK2MSFTNGP10.phx.gbl...
> I have a SQL 7 server that I renamed. It wouldn't start after that (I had
> forgotten that SQL 7 didn't respond well to name changes) so I put the cd
in
> and updated the system but the SQL service STILL doesn't start. Now when I
> put the cd in it doesn't give me the option of updating it just goes right
> into the setup. I had actually played around with the naming of the server
> so I'm not sure if that was part of the problem.
>
> How do I fix this? Is there a registry key to look for? I need to get this
> server up cause I need to get DTS jobs out of it before I blow it away.
>
> TIA!!
> jj
>
>
I don't know if this will fix your problem or not, but take a look at
sp_addserver in the BOL. You may need to add your new server name and
remove your old servername from the master database using this sproc.
Rick Sawtell
| |
| David Gugick 2005-07-19, 1:23 pm |
| jj wrote:
> I have a SQL 7 server that I renamed. It wouldn't start after that (I
> had forgotten that SQL 7 didn't respond well to name changes) so I
> put the cd in and updated the system but the SQL service STILL
> doesn't start. Now when I put the cd in it doesn't give me the option
> of updating it just goes right into the setup. I had actually played
> around with the naming of the server so I'm not sure if that was part
> of the problem.
> How do I fix this? Is there a registry key to look for? I need to get
> this server up cause I need to get DTS jobs out of it before I blow
> it away.
> TIA!!
> jj
exec sp_dropserver <old>
exec sp_addserver <new>, local
http://msdn.microsoft.com/library/d...5r8f
.asp
(SQL 2000 explanation).
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
|
|
|
|