How can we help you today? How can we help you today?

Re-attaching SC to a server with a different name

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?
HeavenCore
0

Comments

3 comments

Sort by
  • Eddie D
    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 D
    0
  • David Atkinson
    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
    0
  • HeavenCore
    David Atkinson

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

    Thankyou very much :D
    HeavenCore
    0

Add comment

Please sign in to leave a comment.