SQL Server Tips

Getting Started with Web applications development with servlets and JSP - Part 5: Filters

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Just Learned

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today


	Like

Invite Friends

Tips · Submit A Tip · Members (427) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

Change SQL Server instance name - SQL Server

Oct 25 2011 4:33AM by Paresh Prajapati

During working with replication, encountered with one error to use actual server name for replication. For solution we need to change the SQL Server instance name as actual server name with following,

EXEC sp_dropserver 'Old Server Name'
EXEC sp_addserver 'New Server Name','local'
GO

Then restart the SQL service and confirm the new server name with @@SERVERNAME.

Read More.. [0 clicks]

Previous: SQL Server - New warnings in Actual Execution Plan
Next: SELECT count(*) - A myth busted

Paresh Prajapati

7 · 24% · 5511

Liked

Knew

Learned

Incorrect

Interesting

Forgotten

Move


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it
This post should be moved to a more appropriate category


	Submit

4 Comments

I would change the first statement to:

sp_dropserver 'old_name', droplogins
GO

commented on Oct 25 2011 6:20AM .

Nakul Vachhrajani

6 · 26% · 5926

Yes Nakul,

commented on Oct 25 2011 6:52AM .

Paresh Prajapati

7 · 24% · 5511

When I tried:

EXEC sp_dropserver 'Old Server Name'

Received the following error:

The server 'Old Server Name' does not exist.

commented on Oct 25 2011 9:11AM .

Cris

167 · 1% · 219

if your renaming the default sql server instance you must also rename the machine (computer name) otherwise sql server will fail to connect to the new instance name

commented on Oct 26 2011 2:56AM .

MAKAROV

679 · 0% · 25

Your Comment

Sign Up or Login to post a comment.

"Change SQL Server instance name - SQL Server" rated 5 out of 5 by 14 readers +Paresh Prajapati