Founder Member of this blogspot PSD Nashik:- Honble. CPMG Maharashtra Circle Col.K.C. Mishra (VSM), Hon Ex. PMG AGD, T. Murti Sir, Honble. PMG Aurangabad Shri. M.E. Haque, Honble DPS HQ Mumbai Dr. Vinod Kumar, Honble DPS Aurangabad V. Ramulu, Supdt PSD Nashik Shri. M.S.Ahirrao, Sys Admn Shri. N.R.Pandav.

 

Wednesday, 29 October 2014

CHANGE SQL SERVER NAME WITHOUT UNINSTALL

0 comments

CHANGE SQL SERVER NAME WITHOUT UNINSTALL

Complete Steps To Change SQL Server Name

In PO Server Configuration, Most of the time we are forget to rename the Computer at the time of installation. it may continue in SQL Installation also.
  • Operation system may assign the computer with some letters like DOP-a754fs2g. In SQL installation server name we does not make any changes, we may choose default instance.
  • we may find this issue at the time of connect the SQL server

Easy Way To Change SQL Server Name

Before do the DOP software configuration, just rename the Server / Computer Name then, SQL server name automatically change if you have selected default instance at the time of SQL Server Installation.
Note: After dop software configuration never try this one, problem may occur with link server and some other configuration.

Steps To Rename In SQL

When one changes the name of the computer running the SQL Server, one needs to perform the following steps to ensure that SQL Server also uses the new updated name. 
  • First to check whether the SQL Server has the correct name, execute the following query
SELECT @@SERVERNAME                 AS oldname,       Serverproperty('Servername') AS actual_name
  • @@Servername gives the computer name that has been set/registered with SQL Server Serverproperty('Servername') provides the newly updated name from windows.

If @@servername,Serverproperty('Servername') results are different then one should update the new name on the SQL Server. To update, follow the steps provided below.

step 1 :- sp_dropserver/sp_addserver

EXEC  Sp_dropserver   'oldservername'EXEC  Sp_addserver   'newservername' ,   'local'

step 2 :- update sysjobs

Applies only for SQL 2k.

USE msdbUPDATE sysjobsSET    originating_server = Serverproperty('Servername')

step 3 :- Restart SQL Service 

Restart SQL Services for the changes to take effect.

0 comments:

Post a Comment

 
PSD-NASHIK © 2013