up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
feedback

2 Answers

up vote 1 down vote
  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.
link|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
feedback
up vote 1 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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