Connecting to SQLServer 2000 using DNS alias

[rjp]

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

[Simon Hayes]

"rjp" <rj***@laposte.net> wrote in message
news:9b**************************@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

[George]

> 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.
:)