Results 1 to 9 of 9

Thread: Cannot save DTS Packages after server name change

  1. #1
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    Unhappy Cannot save DTS Packages after server name change

    I previously installed SQL 7.0 on my machine. The name of the Server was DEVELOPMENT. Unfortunately I needed to change the computer name, but I had already created my databases and did not want to lose the information. It was suggested that I should simply change the computer name and reinstall SQl. I changed the name to DEVSERVER. This seemed to work fine. Now I am having a problem when I try to create a DTS package on the renamed server from another SQL server . I receive the following error. "A connection could not be established to Development. Specified SQLserver not found" The server which is now called Devserver, is registered on the server I am creating the package from, however the message seems to imply that the server I'm connecting to is still called Developement and cannot be found. Any ideas would be appreciated.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Run following on DEVSERVER:

    sp_dropserver DEVELOPMENT

    sp_addserver DEVSERVER, local

    then restart sql service.

  3. #3
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52
    Thank. I ran sp_dropserver and the server name changed so that seems to have worked, however when I try to register the server from another SQL machine the Server name is not listed in the list of Available Servers and I have to manually type in the Server name (DEVSERVER) for it to be registered. Now when I try to save a DTS I get a msg the sp R_iRTblVersion cannot be found. I tried scripting the sp from the working server and copying it to DEVServer, but it does not seem to be added to the MSDB database. Any ideas?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Did you see table RTblVersion there?

  5. #5
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    I am seeing the table

    Yes the table is listed under the msdb database.
    Last edited by Katyan; 10-02-2002 at 03:23 PM.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Try refresh display to see if the sp is added.

  7. #7
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    The table is there but the Sp is Missing

    I did refresh, the Stored proceedure is not there.

  8. #8
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    I scripted the sp again and it's showing up now

    I scripted the sp again and it's showing up now, I'm going to try saving the DTS again I hope it works now.

  9. #9
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    It worked

    Thanks rmiao. It's working now. Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •