SQL Server Renamed >> Error

  • Hi

    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

  • 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.

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

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

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