SQL Server Renamed >> Error

• Krishna Roopa

  SSC-Addicted

  Points: 423

  More actions

  July 16, 2001 at 2:28 am

  #75907

  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

• Leon Platt

  SSCommitted

  Points: 1921

  More actions

  July 16, 2001 at 8:27 am

  #417086

  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.