Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 , change domain Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 10:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:43 AM
Points: 17, Visits: 159
SQL Server 2008 R2

Ho guys
I need some help from you:

I have a SQL Server 2008 R2 installation in a domain.

The IT department has decided to change the domain name (keeping same name and IP).

Could you provide me the direction on how to ensure the SQL Server still works after the domain change without any issue?

Many thanks
Post #1469641
Posted Wednesday, July 3, 2013 3:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 3:03 AM
Points: 51, Visits: 351
Hey, speak to the system admins, to add an alias on the DNS pointing to the new server.
Post #1469962
Posted Thursday, July 4, 2013 6:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:43 AM
Points: 17, Visits: 159
Hello,

many thanks.
Your solution looks very interesting but we are sure that an ALIAS in DNS solves our problem?

The domain change should change the <famous> SID for the user? This could affect the entire user access?

Thanks
Post #1470427
Posted Monday, July 15, 2013 7:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:43 AM
Points: 17, Visits: 159
Hi,

Do you have any advise about the change domain?

Kind regards
Post #1473650
Posted Monday, July 15, 2013 8:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:40 AM
Points: 47, Visits: 813
Hi,

There will be impact to the SQL Server when a domain name is changed, you'll have to see the steps below to get back SQL to the new domain.

1. All Logins must be re-added back to the sql server with same global level permission and user level permissions on each databases.
2. Ensure you have at least one SQL account that has sysadmin access so you would have to enough permissions to add back the users.
3. Update the SQL Server's service account to the new domainname\user for all services logon from SQL Server Configuration Manager.
4. If Replication or Logshipping used then you must ensure the shared folders have the same permissions since you'd have to re-add the users.
5. If linked servers then you need to reconfigure them with new credentials.

Regards,
Post #1473673
Posted Wednesday, November 27, 2013 3:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Hi,

Will it log shipping work without interrupt the below points did?

SQL server's service account changed to new domain account and log shipping shared folder permission is re-added to users.

Thanks.


Pradeep
Post #1517974
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse