Solved

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

Posted on 2008-10-21
2
425 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

718 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