-
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.
-
Run following on DEVSERVER:
sp_dropserver DEVELOPMENT
sp_addserver DEVSERVER, local
then restart sql service.
-
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?
-
Did you see table RTblVersion there?
-
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.
-
Try refresh display to see if the sp is added.
-
The table is there but the Sp is Missing
I did refresh, the Stored proceedure is not there.
-
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.
-
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
-
Forum Rules
|
|