Change the server name does not default usenames

Hi :

I am in the process of testing server name on which sqlserver is running.In this process i could sucessfully rename the server and bring the database online.I have renamed the server name in the system tables by using sp_dropserver and addserver .But still in the security logins i can see the agent logins not reflecting the change .

Oldservername \SQLServer2005SQLAgentUser$oldservername$MSSQLSERVER.How can i modify these names.

thanks

Ganesh

You need to restart the sql server after performing sp_dropserver and sp_addserver to reflect the new name !
|||

The server and the service were restarted serveral times.Any help appreciated .

thanks,

Ganesh

Change the server name does not change default usenames

Hi :

I am in the process of testing server name on which sqlserver is running.In this process i could sucessfully rename the server and bring the database online.I have renamed the server name in the system tables by using sp_dropserver and addserver .But still in the security logins i can see the agent logins not reflecting the change .

Oldservername \SQLServer2005SQLAgentUser$oldservername$MSSQLSERVER.How can i modify these names.

thanks

Ganesh

You need to restart the sql server after performing sp_dropserver and sp_addserver to reflect the new name !
|||

The server and the service were restarted serveral times.Any help appreciated .

thanks,

Ganesh