Re-attaching SC to a server with a different name

HeavenCore · February 7, 2012 10:38AM

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?

Eddie D · February 9, 2012 2:44PM

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

David Atkinson · February 10, 2012 4:53AM

@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

HeavenCore · February 16, 2012 6:15AM

@David Atkinson

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

Thankyou very much

Re-attaching SC to a server with a different name

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk