Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Hi I changed my domain name last week. So the administrator@domainname also changed. Now i am not able to log on windows authentication mode in sql server. I want to change the windows authentication account to new administrator account. can anyone help me to sovw this issue.

Regards Suresh

share|improve this question

2 Answers 2

  1. Log in to SQL Server using SQL Server Authentication (sa account).
  2. Navigate to Security / Logins.
  3. Add the new administrator account and assign it to appropriate server roles.
share|improve this answer
    
+1 Do you think "administrator@oldDomainName" would still work? Just in case OP doesn't know the sa pwd. –  Groo Nov 29 '10 at 9:59
    
@Groo He cannot use the "administrator@oldDomainName" account to access SQL Server, because he cannot log in to Windows using this account. –  Marek Grzenkowicz Nov 29 '10 at 10:02
    
Oh, right, I am talking nonsense, win authentication is just using existing user accounts. –  Groo Nov 29 '10 at 10:05

Start the server in single user mode & you'll be able to set up new accounts. Lots of examples on this site and in TechNet/MSDN of how to work in single user mode.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.