Solved

Why is it that when the Domain is changed, SQL server won't start?

Posted on 2007-11-14
5
220 Views
Last Modified: 2010-03-19
I have a test server with SQL 2005 loaded on it and 2 applications that utilize the SQL server.  I need to change the domain to a test domain to keep the machine off the main network.  When I change the domain, though, the SQL server refuses to start, and therefore renders the Symantec inoperable.  How can I adjust it so that the SQL server either is domain independent or at least recognizes the new domain instead?
0
Comment
Question by:Angela Pierce
[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
  • 2
5 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20283030
uninstall reinstall. sql server is tied to full computer name, incl domain
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20283403
I've never heard that SQL Server is "tied" to a domain.

It's likely that your SQL Server service is set to start with a domain account vs. a local system account.  It can't see the old domain so it can't start.

Change the service account to a local system account.
0
 

Author Comment

by:Angela Pierce
ID: 20284082
So, where would I go to change this setting?
0
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 125 total points
ID: 20284395
It's recommended to use Enterprise Manager / SQL Server Management Studio, but since you can't get SQL Server to start you have to change it through the Services applet in Control Panel.  On the Log On tab for the SQL Server service, change it to 'Local System Account'.
0
 

Author Comment

by:Angela Pierce
ID: 20284718
I had to change all of the SQL services to local logon but it worked; I can now get into my Symantec and ATTACC installations.  Thank you.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

756 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