Re: Domain Migration
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Mon, 15 Jan 2007 19:51:39 -0600
Changing Domains wil not create any problems. But do not change the sql
server machine name.
Please do below after chnaging domain:-
1. If you are using Integrated security , the user accounts that the users
use will change.
After changing the domain name the users will be Newdomain\User1 instead of
olddomain\user1.
After that you may need to use sp_chnage_users_login to fix the orphan
users.
2. Change the SQL Server startup account to point to new domain user for SQL
Server and SQL Agent services.
Thanks
Hari
"Gis Bun" <GisBun@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C3549937-2969-4DDE-B588-DC38F8106126@xxxxxxxxxxxxxxxx
Hi,
We will be migrating a SQL Server from one domain to another. In the case
of
our SQL Server (2000) it will be temporaily downgraded to a workgroup
server
and then added to the new domain. Aside from changing the SQL Server
service
accouynts over to the new domain, anything else is required?
Or can this not be done?
Thanks
Gis
.
- Prev by Date: Changing default file location on install - SQL 2005
- Next by Date: RE: Can't access Sql Server Express 2005
- Previous by thread: Changing default file location on install - SQL 2005
- Next by thread: Re: Where is Enterprise Manager???!
- Index(es):
Relevant Pages
|
Loading
