Solved

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

Posted on 2007-11-14
5
185 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
  • 2
  • 2
5 Comments
 
LVL 25

Expert Comment

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

Expert Comment

by:Chris Mangus
Comment Utility
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
Comment Utility
So, where would I go to change this setting?
0
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 125 total points
Comment Utility
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
Comment Utility
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now