change @@SERVERNAME 2005 - Urgent please help !!!

Hi There

I have changed the servername of a sql server 2005 instance. Using sp_dropserver and sp_addserver as per BOL.

However, after changing the servername i still see that :

EWX-JDGSQLSRV1\SQLServer2005SQLAgentUser$EWX-JDGSQLSRV1$MSSQLSERVER

EWX-JDGSQLSRV1\SQLServer2005MSSQLUser$EWX-JDGSQLSRV1$MSSQLSERVER

EWX-JDGSQLSRV1\SQLServer2005MSFTEUser$EWX-JDGSQLSRV1$MSSQLSERVER

built in logins still have the old server name.

My big concern is that these will no longer work?

Also i am changing not only servernames but doamins, i cannot find anythign on chaning domains and all that must be done.

Are the built in sql server logins still ok after i change the servername ? Even though they do not reflect the change?

Wjat else must i do before moving the server to a new domain (i will change the servcie accounts to use new domain accounts in the configuration manager?)

Thanx

Dietz:

Did you include the "local" tag when you called the sp_addserver stored procedure?

Dave

|||

Yes i did, i found the prblem though. Has nothing to do with that when i checked the sql log it could not execute sp_startup_agent, becuase agent XP's were not enabled, i could not enable agent XP's because lock pages in memory priviledges were not granted to the new sqlservice account.

So i granted the priviledges and enabled agent XP's and all was well.