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

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 (AT) urmc (DOT) rochester.edu> wrote

"jj" <jeff_detoro (AT) urmc (DOT) rochester.edu> wrote

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

jj wrote:
exec sp_dropserver <old>
exec sp_addserver <new>, local

http://msdn.microsoft.com/library/de...stall_5r8f.asp
(SQL 2000 explanation).



--
David Gugick
Quest Software
www.imceda.com
www.quest.com