Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

renaming a server Expand / Collapse
Author
Message
Posted Wednesday, August 5, 2009 5:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, November 16, 2014 3:12 PM
Points: 91, Visits: 520
Try dropping the distribution database via the cleanup sp, this effectively runs the menu command 'Remove Publishing and Distribution' but bypasses the checking. Run

USE master
GO
EXEC sp_dropdistributor @no_checks = 1
GO

You should then be able to rename your SQL server with

EXEC sp_dropserver ''
GO
EXEC sp_addserver '', 'local'
GO

but don't forget to restart the services or it won't take effect.
Post #765901
Posted Monday, August 17, 2009 10:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
The Quest e-book , page #77 was an excellent tip. I have a crappy network that seems to decide on it's own whether DNS works or not. I had to rename the server to the FQDN, and couldnt because of replication which had linked server logins.

Thanks Jamie !!

Post #772083
Posted Friday, October 30, 2009 10:53 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:13 AM
Points: 80, Visits: 206
If you are getting this error because of sticky points due to replication run this:

sp_dropdistpublisher 'bad server name'

that should clear up the name mismatch on replication and allow you to change your server name as you noted in the origional post.



thanks, ERH
Post #811744
Posted Thursday, February 11, 2010 3:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 25, 2014 2:18 AM
Points: 4, Visits: 63
I tried the disable of the publishing, but it still would not allow the connection to the alias.
I ended up changing the server name back on the network, disabling replication, then dropping server and adding server as new name.
Post #863947
Posted Thursday, February 11, 2010 3:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 25, 2014 2:18 AM
Points: 4, Visits: 63
THIS, worked for me:

select @@servername

sp_helpserver

sp_helpremotelogin 'xxxx'

--sp_dropremotelogin 'xxxx','DOMAIN\account'
--sp_dropremotelogin 'xxxx'
--sp_dropserver 'xxxx'

sp_dropserver 'xxxx', 'droplogins'
sp_addserver 'xxxx-new', local
Post #863963
Posted Monday, August 16, 2010 11:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:26 PM
Points: 1, Visits: 60
I can report that the "alias" approach works where replication cannot be otherwise disabled.

I had wondered how deeply in the code aliases were utilized, as I've been using them quite superficially until now.

Thanks!
Post #969948
Posted Monday, April 4, 2011 5:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:36 AM
Points: 22, Visits: 117
this worked for me thanks!
Post #1087975
Posted Friday, January 4, 2013 12:18 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 27, 2014 8:36 AM
Points: 14, Visits: 159
Worked like a charm Thanks Luis!
Post #1403058
Posted Friday, August 8, 2014 1:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 9:43 AM
Points: 2, Visits: 281
Wow thanks Luis that worked!!!
Post #1601322
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse