SQL Server 2008. I created an instance of SQL Server. My user domain has since changed. How do I reconfigure SQL for my new user domain?

Question

I created an instance SQL Server on my local machine. Then my login changed and I was assigned a new domain. As a result, I need to reconfigure SQL Server. The owner of the instance is still myself with the old domain. I need to change that to the new domain. Then I need to change my .Net apps so that they can connect to this instance.

How should I go about doing this?

Answer 1

Sql server is 'nothing' more than a windows service. By owner of instance, perhaps you mean the account under which the ms sql server service is running? If so, manage computer, services, choose the service with the instance in question, set the logon name & password.

• Changing the service account
• I just plain don't like this answer here --> Experts Exchange
• If you just like learning stuff, you might enjoy this one: NYC DBA

Your .Net apps --> depends on "how" they are configured now. If they are on the same box and were using something like (local), nothing need be changed. If they were configured to point to the machine name, such as machine.old_domain.com, then simply changing them to machine.new_domain.com. If they are configured to point to machine and the name of the machine didn't change, no configuration changes needed.

This are just starter answers. I've never had this happen to me. Good luck my friend.