?
Solved

SQL2005 EXPR: Moving Server from 1 Domain to another...

Posted on 2008-10-21
2
Medium Priority
?
463 Views
Last Modified: 2012-06-21
Hi Experts,

Just working on a client's site here, which we're planning on upgrading their equipment and moving them all to a new domain name.

Planning on moving a SQL Server 2005 Express machine from Domain A to Domain B... Does anyone forsee any issues occuring with the operation of SQL Server 2005 Express? I can't seem to find much information...

I think authentication will be an issue, but what does everyone else think?

Any info will be great.

Cheers,
Ray.
0
Comment
Question by:RayFrangie
1 Comment
 
LVL 81

Accepted Solution

by:
arnold earned 1500 total points
ID: 22773133
The only issue is if the sqlserver is using a domain account to operate.  These settings can be adjusted through the Sql server configration manager.
You may need to add the new domain administrator account to the security/login.

Note: before making any changes to the domain association, make sure you have the sa password which you can use with the SSMS express to fix issues as they arise.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question