Re: Hostname change and SQL problem.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/09/04

  • Next message: Gary: "Re: Hostname change and SQL problem." 
    Date: Sun, 9 May 2004 06:27:23 +0530

    Hi,

    Execute the statement in Query analyzer if SQL SERVER is normal edition , if
    it is MSDE from command prompt execute

    OSQL -Sserver -Usa -Ppassword

    1> sp_dropserver 'old_server_name',
    2> go
    1> sp_addserver 'new_server_name', 'local'
    2>go

    There is a slight error in your statement, Please execute the below commands
    from Query Analyzer:-

     sp_dropserver 'old_server_name',
     go
     sp_addserver 'new_server_name', 'local'

    Note:
    sp_dropserver 'Old_server', 'droplogins'

    This removes the remote server old_server and all associated remote logins
    from the local SQL Server. But in your case
    u have remove the local server and add a new one.

    Thanks
    Hari
    MCDBA

    "Gary" <reachus@netlink.info> wrote in message
    news:4Xbnc.8664$nN6.5313@lakeread06...
    > We have had to change the hostname on an SQL server (Blade and the balde
    > moved chassis so name changed)
    >
    > It seems i need to run 2 stored procedures which are
    > sp_dropserver 'old_name', 'droplogins'
    > go
    > sp_addserver 'new_name', 'local'
    > go
    > Assuming this is right I cannot find anyway to run these stored procedures
    > as there seems ot be no interactiove SQL.
    >
    > Help please
    >
    > Gary
    >
    >
    >

  • Next message: Gary: "Re: Hostname change and SQL problem."

    Relevant Pages

    • Where the !@?!@ is my Stored Procedure?
      ... I wrote the following in the SQL Server 2005 Express Management Studio ... and hit execute. ... Even though Query Analyzer indicated success when I ... to execute the code again, and lo and behold, SQL Server gives me the ...
      (comp.databases.ms-sqlserver)
    • Re: Execute Persmission denied on object sp_OACreate
      ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
      (microsoft.public.sqlserver.security)
    • RE: exec sp_help_job user account rights
      ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
      (microsoft.public.sqlserver.security)
    • Re: SSIS - OLE DB Command - how to retrieve query results ???
      ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
      (microsoft.public.sqlserver.dts)
    • RE: xp_cmdshell, ownership chaining, sql 2000
      ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
      (microsoft.public.sqlserver.programming)