Could not login after changing domain account.

Question

Could not login after changing domain account.

Dung Dinh

SSCrazy

Points: 2513
More actions
February 6, 2013 at 3:37 am

#288712

Hi all,
I installed a SQL instance on my computer. Here is info:
Instance name: DTDUNG\MSSQLSERVER
Login Mode: Window Authentication
Domain user: T\dtdung
After that, I changed my account to a new domain within T_new\dtdung. So, I could not login to SQL Server Instance DTDUNG\MSSQLSERVER from my computer.
I also tried to create a new login account to but it was not been successfully.
Please give me advices to fix. Thanks,

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

david.abram SSCommitted Points: 1777 More actions · Answer 1

Hi,

As far as I understand your question, you are trying to login to your SQL instance with an account from a separate domain. As your SQL instance won't have permission to see the new domain and therefore check the credentials of the new user it won't allow you to access it.

The server that the instance is hosted on needs to be on the same domain as the user you are trying to log in with. An option would be to add the server to the new domain (which would remove it off the old domain) or use mixed mode authentication and use a SQL login (which isn't best practice).

Hope that helps.

Dave

SQLAJ Ten Centuries Points: 1359 More actions · Answer 2

Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could also look at this. I ran into a similar issue a few weeks back where the Windows SysAdmin moved the VM from one domain to another without telling me. Oops!

I was able to fix it and it is not all that difficult.

http://sqlaj.wordpress.com/2013/01/25/no-admin-account-on-server/

______________________________
AJ Mendo | @SQLAJ

Dung Dinh SSCrazy Points: 2513 More actions · Answer 3

david.abram (2/6/2013)
Hi,
As far as I understand your question, you are trying to login to your SQL instance with an account from a separate domain. As your SQL instance won't have permission to see the new domain and therefore check the credentials of the new user it won't allow you to access it.
The server that the instance is hosted on needs to be on the same domain as the user you are trying to log in with. An option would be to add the server to the new domain (which would remove it off the old domain) or use mixed mode authentication and use a SQL login (which isn't best practice).
Hope that helps.
Dave

Hi,

My situation is here. I installed SQLServer on my local computer, while installing I used a domain account T\dtdung for security section which I also used to login into my computer. After that, this account was changed within new domain T_new. Now, my account to login the computer is T_new\dtdung.

I agree with you that the new account does not have sysadmin role. I will try to fix it

Dung Dinh SSCrazy Points: 2513 More actions · Answer 4

SQLAJ (2/6/2013)
Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could also look at this. I ran into a similar issue a few weeks back where the Windows SysAdmin moved the VM from one domain to another without telling me. Oops!
I was able to fix it and it is not all that difficult.
http://sqlaj.wordpress.com/2013/01/25/no-admin-account-on-server/

I sure that I selected Windows Authentication Mode. Unfortunately, I dont know pass for SA user. After changing to new domain, I use the new user T_new\dtdung to login my computer. Maybe, I will try to apply your suggestion.

david.abram SSCommitted Points: 1777 More actions · Answer 5

Does the SQL service even start up? If not, you will need to use SQL server configuration manager to change the account that SQL server is using.

Dung Dinh SSCrazy Points: 2513 More actions · Answer 6

david.abram (2/6/2013)
Does the SQL service even start up? If not, you will need to use SQL server configuration manager to change the account that SQL server is using.

Yes, SQL Service is running with new account T_new\dtdung.

david.abram SSCommitted Points: 1777 More actions · Answer 7

I think in that case you will need to log on as SA if you can get the password and add your new login to SQL. Your new user won't be able to identify the new user's SID.

Dung Dinh SSCrazy Points: 2513 More actions · Answer 8

Dung Dinh (2/6/2013)
SQLAJ (2/6/2013)
Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could also look at this. I ran into a similar issue a few weeks back where the Windows SysAdmin moved the VM from one domain to another without telling me. Oops!
I was able to fix it and it is not all that difficult.
http://sqlaj.wordpress.com/2013/01/25/no-admin-account-on-server/
I sure that I selected Windows Authentication Mode. Unfortunately, I dont know pass for SA user. After changing to new domain, I use the new user T_new\dtdung to login my computer. Maybe, I will try to apply your suggestion.

That's so great! I applied the PsExec tool and it worked well 🙂

Thanks so much,

vanapandi SSC Enthusiast Points: 120 More actions · Answer 9

while login,try with your old domain name as server name..it may help you

SQLAJ Ten Centuries Points: 1359 More actions · Answer 10

Cool!. Glad to help.

______________________________
AJ Mendo | @SQLAJ