Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2003-05-14 : 09:16:54
|
Previous configuration:NT 4 EE Sp6a - SQL Server 2K SP32 Hard Disk: C and DSQL was installed on D.Last week I tried to reboot this machine but get errors on NT loader, NT kernel and so on.Tried to repair NT installation but no luck.Pray...but no luck.  New configuration:I decided to install a new fresh Windows 2K Server instead of NT4.When Windows was up and running I copied the old "data" folder (*.mdf and *.ldf files) of the D drive to a safe place on C.Format D drive.Install SQL Server 2K and SP3 on D.Shutdown SQL Server.Delete the "data" folder.Copy the old "data" folder from C to DStart SQL Server....fine.Everything is up and running but there is something strange with the name of the server:In EM the server name appear to be "local" and not the real name "PWS01050" as before.sp_helpserver returns :"Server: Msg 15205, Level 16, State 1, Procedure sp_helpserver, Line 17There are no servers defined".Table sysservers of master db is empty (How can this be?)  If I open a QA session I can see the proper name of the server (PWS01050) on the left pane under "object browser" (where is he reading this information?)Every DTS packages works well, jobs runs well too.Any idea on fixing this things?Any help is really appreciated.Kind regards.Franco |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-14 : 09:19:32
|
| Hi!Run this:sp_addserver @local='LOCAL', @server='yourservername'You might need to restart your service after you do that...Edited by - andraax on 05/14/2003 09:20:14 |
 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-15 : 10:40:17
|
Thanks so much.Works really good.  In addition I have deleted EM registration then register again.Cheers.Franco |
|
|
|
|
|
|
sp_helpserver