Solved

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

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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

623 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