Connecting to SQLServer 2000 using DNS alias

Hi all,

I have to move my SQlServer 2000 instance from one server
'actual_server' to another server 'new_server'.
But, the different applications connecting to the actual server can't
easily change their connections address. i.e it connect to
'actual_server' server only.

Is there a risk to declare a DNS alias 'actual_server' pointing to
'new_server' ?
So I could move my databases from 'actual_server' to 'new_server'.
Is the modification transparent to the client ?
I especially thinking about wins...

TYIA
Cordially
RJP"rjp" <rjp.l@.laposte.net> wrote in message
news:9b7a7215.0410130818.317ad44b@.posting.google.c om...
> Hi all,
> I have to move my SQlServer 2000 instance from one server
> 'actual_server' to another server 'new_server'.
> But, the different applications connecting to the actual server can't
> easily change their connections address. i.e it connect to
> 'actual_server' server only.
> Is there a risk to declare a DNS alias 'actual_server' pointing to
> 'new_server' ?
> So I could move my databases from 'actual_server' to 'new_server'.
> Is the modification transparent to the client ?
> I especially thinking about wins...
> TYIA
> Cordially
> RJP

I don't see any big problem, if you're simply adding an alias to an existing
host. It probably isn't a good long-term solution, though, as it may create
management and troubleshooting problems at some point. I don't know about
WINS, as I haven't used it in a while (it's not necessary on an all-Win2K
TCP/IP network) - you might want to check with your network administrators
(if that's not you, of course), or in a networking newsgroup.

Simon|||> I don't see any big problem, if you're simply adding an alias to an
existing
> host. It probably isn't a good long-term solution, though, as it may
create
> management and troubleshooting problems at some point. I don't know about
> WINS, as I haven't used it in a while (it's not necessary on an all-Win2K
> TCP/IP network) - you might want to check with your network administrators
> (if that's not you, of course), or in a networking newsgroup.
> Simon

Thanks Simon.
:)