SQL Server Renamed >> Error

  • Krishna Roopa

    Old Hand

    Points: 393


    I have SQL server 2000 running on Win2k Advanced server

    I had renamed computer name and the SQL Server was running fine.

    But, In DTS Query Designer, I get the following error

    Server <servername> is not configured for DATA Access.

    What could be the problem.. suggest

  • Leon Platt


    Points: 1921

    Im not an expert on DTS so I can't say if there is some kind of configuration you can do or something but a hack at this would be to go through your registry looking for the old server name and replace it with the new name. WARNING - DO NOT ATTEMPT TO EDIT THE REGISTRY UNLESS YOU ARE EXPERIENCED AT THIS. A REGISTRY BACKUP IS ALWAYS A GOOD IDEA BEFORE MAKING ANY CHANGES.

Viewing 2 posts - 1 through 2 (of 2 total)

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