Re: after sql server rename

I haven't renamed a server in a while. This is not necessarily a problem. If you go to Local Users and Groups application I bet the group names haven't changed just because you renamed the server. So they are fine. Leave them there.
To check this, on the Start menu, click Run. Type lusrmgr.msc and then click OK.
Expand Groups and look for the group names you have listed below. Presumable the local Windows groups are still there, they are still members of the sysadmin role in SQL Server. You are fine.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Claudia" <Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:191B51FA-ABD7-4E2C-912B-1F1D70B83802@xxxxxxxxxxxxxxxx
We did run sp_dropserver and sp_addserver. @@servername shows the new server
name.

Thanks.

"Erland Sommarskog" wrote:

Claudia (Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> We renamed the sql server and everything seems fine (sql2005). However,
> I see three logins that still have the old name in them:
>
> OldServername\SQLServer2005MSFTEUser$OldServername$MSSQLSERVER
> OldServername\SQLServer2005MSSQLUser$OldServername$MSSQLSERVER
> OldServername\SQLServer2005SQLAgentUser$OldServername$MSSQLSERVER
>
> What impact do they have if we leave them as they are now?
>
> Can we change the name to reflect the new server name?

What does @@servername report?

That is, did you through the sp_dropserver/sp_addserver steps?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx



.

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)
Quantcast