SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » Server Name
15 posts, Page 2 of 2
««12

Server Name Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
noeld
Posted Tuesday, October 09, 2007 2:20 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 4:14 PM
Points: 6,123, Visits: 1,557
One piece of advice script out local Jobs before changing the name!!!


* Noel
Post #408684
Carolyn Richardson
Posted Tuesday, October 09, 2007 2:26 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 882, Visits: 1,648
They seem to have a .ini file with the connection string in it, the server name in this file seems to be the new server name.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #408688
Carolyn Richardson
Posted Wednesday, October 10, 2007 4:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 882, Visits: 1,648
If I alter the server name I will use sp_dropserver sp_addserver, however the clients are all connecting via an application which uses an .ini file that contains both connection details to the original server DNS name and the new server DNS name, What I was not sure of is that if I correct the name what might happen to users connection, could I be cutting them off. I wondered if there was a way to tell what they are connecting via - the old or new name. I am 90% sure that they won't notice a thing, but just wondered.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #408891
Steve Jones - Editor
Posted Wednesday, October 10, 2007 7:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Yesterday @ 4:33 PM
Points: 21,728, Visits: 5,982
It's hard to know. The application could support multiple names, there could be caching, etc.

I'd probably schedule this for a slow time or off hours. Change the name and try a workstation. If you have problems, you can roll back. The same sp_dropserver/addserver can be done in reverse.
Post #409005
John Rowan
Posted Wednesday, October 10, 2007 9:06 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 4:18 PM
Points: 3,074, Visits: 2,184
This should be an easy change to rollback if needed as Steve has suggested. This could also be easily tested on a test system if you have that available. :)


Post #409076
« Prev Topic | Next Topic »

15 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use