By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,312 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,312 IT Pros & Developers. It's quick & easy.

Connecting to SQLServer 2000 using DNS alias

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"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
Jul 20 '05 #2

P: n/a
> 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.
:)





Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.