Solved

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

Posted on 2007-11-14
5
225 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

734 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