January 6, 2011 at 2:36 am
Hi,
i would like to Rename my sql server due to some requirement(DB mirroring).
why becoz we took the Image(image name is XYZ ) from client as it is installed in my VMware. after that changed the SID , Rename the server like ABC & added this server in Domain.
when i login the sql server. run the query 'select @@servername'.
iam getting result like XYZ.
why it is not giving ABC ?.
present server detials are:
windows server 2003 std & SQL server 2005 EE
so i want to change my sql server name like ABC.
through sp_dropserver & sp_add server.
whether the problem will be resolved or not?
any suggetions in this, plz let me know.
Subha
January 6, 2011 at 2:45 am
http://technet.microsoft.com/en-us/library/ms143799.aspx
might be of some help.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply