July 16, 2001 at 2:28 am
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
July 16, 2001 at 8:27 am
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.
December 18, 2020 at 9:57 am
This was removed by the editor as SPAM
December 18, 2020 at 9:58 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply