• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

replacing an MS sql server

E

eek1

Gawd
Joined
Jan 8, 2001
Messages
663
Hi, I have two MSsql2k servers right now with identical databases > oldserver and newserver. Oldserver is a win2k secondary DC as well. New server is win2003 and a member server of the domain. I will be removing mssql from oldserver and transfering the task onto the new server. However, my database applications call by the name of "oldserver\dbinstance_name" and I need to fork with active_directory resolution or dns to reroute oldserver sql requests tot he new one. any ideas and or suggestions?

I though about renaming the oldserver to something else and giving the newserver its name. Will this work? what are the implications on active direcory since oldserver is also secondary dc. tia


edit: small chart

server1 (main dc)
||
oldserver - secondary dc and also handles sql. sql to be removed
||
newserver - preconfigured with oldserver's database. to replace sql task of old server.
 
To my knowledge, and I've never tried this, but you could just take the old server out, put in a CNAME pointing to the new server, and things will keep humming along.

I think. Anyone care to back me up on this one?
 
XOR != OR said:
To my knowledge, and I've never tried this, but you could just take the old server out, put in a CNAME pointing to the new server, and things will keep humming along.

I think. Anyone care to back me up on this one?
Click to expand...


I simply cannot do this. the oldserver is a directory server! I need that server and it's only the sql task that will be moved.
 
you cannot rename a DC so your plan will not work either. the best idea may be to move the load, demote the DC, rename it, rename the newserver, promote oldserver back to secondary DC. please allow time between steps for AD changes to replicate.
 
You must log in or register to reply here.
Back
Top