Moving a SQL Server 2000 machine to a new domain

Question

Post reply

Moving a SQL Server 2000 machine to a new domain

James DePalma

Grasshopper

Points: 18
More actions
October 26, 2006 at 11:42 am

#61563

I need to move a server running SQL Server 2000 to a new domain. Anyone who has done this before, I could sure benefit from your wisdom and lessons learned.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

No problem

SQLServer publishes itself !

If you don't change the servername, there is no problem.

IPaddress changeing is no problem, as long as your applications do not connect directly using the IPaddress !

If your sqlserver services are served using "local system" there is no problem.

If your sqlserver services are served using a windows domain account, just be sure that account has access rights on the new domain, or gets replaced with an appropriate one of the new domain.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Anonymous SSCrazy Points: 2228 More actions · Answer 2

I will need to move Production, Dev, Staging and local 2000 servers to a new domain, just like James.

We don't have a DBA and I'm the closest we have to anyone with enough nouse to get involved, along with the sysadmins who are non-DB people.

Questions, with regard to the "services served using a windows domain account" point in the prior post:

1. How do I tell if the services on each box are "windows domain account" served?

2. If they are, how does one go about changing the account info?

3. What about Reporting Services? That's on yet another box and the guy who intalled it used MY domain account for the encryption keys (rsconfig), so I have to keep running rsconfig whenever I'm forced to change my Windows password (every 60 days). If I leave, Reporting Services will cease to function unless we can find a way of using a non-volatile-password account and do the rsconfig thing with finality.

I don't think we're changing IP addresses, so that's one less worry.

Any help would be greatly appreciated. Thanks in advance.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

sorry for the late response.

I'm at SQLPass 2006 for the moment and I didn't check my SSC folder in outlook.

1. If you bring up Computer Managent / Services, search for the mssqlserver-service. If on that row there is a windows domain account, you'll see.

2. To change the domainaccount, don't use CM/Services !!! Use Enterprise Manager, richtclick the servername, properties and in the properties pane, you've got a security tab. There you can change the service account ! EM will then set the needed rights for that account within SQLServer !!

3. you'd be better off launching this question in a new threath !! I'm not using RS for the moment.