Re: Changing Instance Name

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/22/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Fri, 21 Feb 2003 23:53:32 -0000

You need to update the server with the name change

use master
go
sp_dropserver 'oldservername'
go
sp_addserver 'newservername','local'
go

Then restart the SQL Service and run

select @@servername

to confirm the name has changed

Having read your question again, I'm not entirely sure
what your problem is. What exactly is wrong ? 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tracy" <tracy@kpila.com> wrote in message
news:024301c2d9fc$c3998780$a401280a@phx.gbl...
> Hi, All,
>
> Does anyone out there know how someone could change the
> name of a SQL Server instance ... not the named
> instance.   We only have one instance running and it took
> the name of the box it was on.
>
> Earlier today, that name was changed and our apps blew
> up.  We tried to install another instance with the same
> previous name and it said that name already existed ...
> but it wasn't showing up in the local Ent Mngr.  The only
> one there was some other name that none of us knew.  Then
> we just tried to register the server, and it registered.
> I tried pinging this unknown name, but it doesn't
> resolve.
>
> Any ideas would be very helpful.
>
> Thanks!
>

Relevant Pages

  • Re: RACM local security authority problem.
    ... > The server is being used as a mail/internet server. ... Restart the computer. ... if I solve the error with the "Remote Access Connection ... Manager failed to start because it could not register with the local ...
    (microsoft.public.win2000.ras_routing)
  • Re: data mining algorithm plug-in problem
    ... SQL Server Data Mining ... >> You do not need to copy the PlugInAlgorithm, once you register it, and I ... >> You need to restart Analysis Services once you change the INI file. ... >> message that your algorithm was loaded successfully, ...
    (microsoft.public.sqlserver.datamining)
  • Re: Bug? -- Same MDX returns different result sets
    ... with SQL server and AS both installed. ... SQL service is running under local ... >> I have a MDX query which includes a very simple calculated member. ...
    (microsoft.public.sqlserver.olap)
  • Re: ssl renewal questions
    ... restart the sql service for it to all work. ... > Just on the server which I guess explains the clients being able to ... > Jasper Smith ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot access recovery console
    ... We were having problems with an MSSQL DB on that server. ... stop/start of the SQL service appeared to fix the problem (i.e. ... volumes, and it did find both the logical C and D drives, as expected: ...
    (microsoft.public.win2000.general)