TechOnTip Weblog

Run book for Technocrats

Rename SQL Server 2008 – Single Server Senario

Posted by Brajesh Panda on January 5, 2010

Have you ever changed SQL server name? I frequently do the same in my LAB because I use “Sysprep” OS image for my lab deployment. Read my other posting to know about how to Sysprep Windows 2008 R2 Server?

SQL Infrastructure architecture can be created in multiple ways;

– All SQL Roles are running on the same single server

– SQL Roles are in different servers i.e. Database Services, Reporting Services etc are running on different servers

– Clustered SQL Instances

There are numbers of articles are available over internet. However I will recommend to visit Microsoft TechNet to find the official supported article; Over here I am going to state some simple steps for the 1st scenario. So I have to deal with SQL Database Server renaming & Re-configuration of Report Server; Over here I am using SQL 2008 with SP1.

Let’s start operation “RE-BIRTH” of my SQL Instance. Open SQL Query Manager & do some trick to rename our SQL DB Instance;

Use master

go

select @@SERVERNAME

# It should result the OLD Server Name

sp_dropserver ‘OLD SERVER NAME’

go

# It will drop the old server name from master database

sp_addserver ‘NEW-SERVER-NAME’, ‘LOCAL’

go

# It will add new server name in the master database

# Don’t forget that ‘LOCAL’ parameter, else it will se the SERVERNAME to “NULL”

Re-Configure Reporting Services

– Open “Reporting Services Configuration Manger” from Start – Microsoft SQL Server 2008 – Configuration Tools

– It will open up below window having new name of the DATABASE Server. If not find/type the new name and Click on “Connect”

– After you get connected to server, you can verify Service Account, Web Service URL. Default Virtual Directory usually set to “ReportServer” onPort “80”

– Move to Database Page

– We may see the OLD Database server name! If yes, then click on “Change Database” – Select “Chose an existing report server database” – Type Database server details in next window & Click “Test Connection” – If Test is successful you can move ahead to select the reporting Database on next window & other authentication parameters.

– I usually prefer defualt NETWORK SERVICE account for service authentication purpose.

– Here is the summary page of all configuration

– Verify & Click next to create/save same configuration

– To verify your configurations please access http://servername/reportserver

– Output should be below screen

Advertisements

5 Responses to “Rename SQL Server 2008 – Single Server Senario”

  1. Prasad said

    Really helpfull Brajesh. Thanks for sharing this trick 🙂

  2. […] is the link.. https://techontip.wordpress.com/2010/01/05/rename-sql-server-2008-single-server-senario/ September 17, 2010 11:15 am Jon I’m glad you got it solved. You should choose this […]

  3. […] Here is the link.. https://techontip.wordpress.com/2010/01/05/rename-sql-server-2008-single-server-senario/ […]

  4. Govindarajan S said

    Hi,
    I missed to mention ‘LOCAL’ while changing the hostname. It displays NULL when i select @@servername. How i can get it changed to reflect the new server name.

    Kindly suggest.

    Regards
    Govind

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: