Re-attaching SC to a server with a different name

HeavenCoreHeavenCore Posts: 15
Hi all

We have many SQL servers, 1 of which was not named correctly (internal naming policy).

when the server was renamed, its old name was added as a CNAME (alias) on our internal DNS.

If i access the server by its old name (using the cname) - my ssms obviously recognises the server and shows source controlled databases in green etc.

If i access the server by its new name, ssms and SC obviously fail to recognise the server.

Is there any way to rename a server in Source Control 3?

Comments

  • Eddie DEddie D Posts: 1,726 Rose Gold 5
    Thank you for your post into the forum.

    OK, if you cannot get SSMS to recognise the new server name then SQL Source Control is not going to connect as it is a plug-in to SSMS.

    No you cannot rename a server using SQL Source Control 3.

    I found this Microsoft MSDN ARTICLE that may contain the advice you are looking for.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • @HeavenCore - In what way does SSMS fail to recognise ths server? Or do you mean SQL Source Control fails to recognise it?

    If the latter, you could try renaming the server name in the link file, which is at:

    C:\Users\[username]\AppData\Local\Red Gate\SQL Source Control 3\ LinkedDatabases.xml
    David Atkinson
    Product Manager
    Redgate Software
  • @David Atkinson

    Cheers David, correcting the server name in the xml file works perfectly.

    Thankyou very much :D
Sign In or Register to comment.