No need to re install. Go to query analyzer and execute SELECT @@SERVERNAME.
After that go to
enter prise manager and right click above local and unregister. After that
right click above the server and choose register and
in server name give the server name based on the out put of @@Servername.
Incase if the @@servername returns empty or NULL then use SP_ADDSERVER
'Servername','Local' to add a server.
After this you need to stop and start the sql server service.
Hi, I am running SQL Server Personal Edition on a Win2k Pro box, and I
need
the server name in Enterprise Mgr toi be something other than (LOCAL),
which
is default, can I rename it or do I have any option to reinstall it and
give
it a name?
Will MSDE do as much if I need a nerwer product?
Re: computer browser service wont start ... I've noticed that dnsApi is sometimes one of the things that starts early before everything it needs is actually working, e.g. the TCP/IP and network stack.... In the situations I've seen the Event Log entry from dnsApi that you report, the computer did successfully register itself later. ... This assumes that the targetted DNS server can accept Dynamic registrations and the computer doing the dynamic registration is permitted to do so. ... (microsoft.public.windows.server.general)
ASP: Get user login ID ... But when we register the dll on our web ...server, and call it from our ASP code, it generates an error. ...Dim lngCharsReturned As Long ... (microsoft.public.inetserver.iis.security)
Re: A record dynamic DNS registration failing depending on DHCP ... for clients.... so I can assume that your server is using the default root hints. ... are only being registered in the Reverse Lookup Zone.... recieved their IP from another DHCP server register their name under the ... (microsoft.public.windows.server.dns)
Re: Boot Prbs in Win2K ... The server did not register with DCOM... No attempts to start the service have been made since the last boot.... (microsoft.public.win2000.setup)
Re: Server-to-Server Remoting ... You can't send an object from server b that you got at ... unncessary as your making a client call and there is already a channel... >My problem is that I can't figure out how to register and instantiate ... which is a subclass of BaseDataService called ... (microsoft.public.dotnet.framework.remoting)
