Post reply

HOW TO GET THE NEW SERVERNAME WHICH WAS CHANGED AFTER SQL SERVER WAS INSTALLED

  • March 1, 2006 at 11:20 pm

    #112026

    My computer name is computer-1

    But it was previously computer-2

    So in my SQL Server 2000 when i run the command as follows:

    SELECT @@SERVERNAME

    I get computer-2 instead of computer-1

    Then i deleted the entry of computer-2 from remote server entry in the security option. As a result the entry in the sysservers table in Master database was deleted. Now when i run the command as above i get NULL.

    May be, when the SQL Server was installed intitially, it created the login using old machine name.

    I tried using sp_addlinkedserver, sp_addserver options. But it says the server already exists.

    By the way I am trying to create a user 'COMPUTER-1\ASPNET' where COMPUTER-1 is my machine name and ASPNET the user name.

    Can anyone help me so that the @@SERVERNAME returns the present machine name. Will I have to change the login, mapped login name etc...?

    OR 

    Will I have to re-install the SQL Server?

    If you can please explain the steps, I'd be really grateful.

    Thanks so much.

    Ron.

  • March 2, 2006 at 12:48 am

    #624205

    not sure where you are now but here are the steps i usually perform:

    1. rename the server box name

    2. reboot

    3. sp_dropserver

    4. restart the services

    5. sp_addlinkedserver

    6. restart the services

    7. issue select @@servername

     

    HTH

  • March 2, 2006 at 3:16 am

    #624227

    run:

    sp_dropserver 'computer-2'

    go

    sp_addserver 'computer-1','local'

    go

    restart sql server services.

    Karl
    source control for SQL Server

  • March 2, 2006 at 5:45 am

    #624257

    Okay, so now I dropped the server

    sp_dropserver 'Computer-1'    (which is my new server name)

    then I again added it using

    sp_addserver 'Computer-1', 'local'

    After this i restarted the services and issued

    SELECT @@SERVERNAME

    and it worked.

    Thanks Karl and HTH.

    But HTH, I wasn't quite sure of what you meant by Server Box Name

    I couldn't try that out as i wasn't sure of that. Could you please speciy where exactly i can find server box? Did you mean the Service Manager window that pops up when the services start?

    Thanks again,

    Ron.

     

     

     

  • March 2, 2006 at 5:52 am

    #624259

    you can call me jen, hth is hope this helps... ha haha

    this is usually the first step, you rename the server (box itself), like servername.domain.com

    coz in forums like this they associate server as the sql server which is actually a software

  • March 2, 2006 at 6:02 am

    #624263

    is it actually a software? reading through the forums one can get the impression it's rather a nightmare


    _/_/_/ paramind _/_/_/

  • March 2, 2006 at 7:11 am

    #624289

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply