Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Problem renaming SQL server

  • 19-02-2009 04:15PM
    #1
    Closed Accounts Posts: 105 ✭✭


    Im an SQL noob so apologies if I am missing the obvious.

    I have been asked to install Microsoft Dynamcis CRM onto our W2K3 member server. I get as far as the verification results where it tells me that 'The Instance name must be the same as the computer name'

    I am aware that this is due to the fact that the server has been renamed since SQL was installed. I am trying to run the below commands but they are returning invalid syntax errors.

    @SERVERNAME AS 'Server Name'

    The above command tells me that SQL views the sername as UNIFLOW-PRINT-S. The actual servername is UNIFLOW. So I need to change it to Uniflow. I then run the below command.

    sp_dropserver <UNIFLOW-PRINT-S>
    GO
    sp_addserver <UNIFLOW>, local
    GO

    Executing this command gives me the below error.
    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near '<'.
    Msg 128, Level 15, State 1, Line 1
    The name "S" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near '<'.

    I am conscious of the fact the it is highlighting the PRINT part of the servername in blue. Is it recognising this as a command or is it that it does not like the dashes in the name?

    Any help would be hugely appreciated.

    Thanks,

    Roy.


Comments

  • Registered Users, Registered Users 2 Posts: 2,494 ✭✭✭kayos


    sp_dropserver 'UNIFLOW-PRINT-S'
    GO
    sp_addserver 'UNIFLOW', local
    GO
    


  • Closed Accounts Posts: 105 ✭✭Diver79


    Many many thanks. Worked a charm.

    Thought I tried it but must have used double quotes.

    Thanks again...


Advertisement