SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Could not login after changing domain account.


Could not login after changing domain account.

Author
Message
Dung Dinh
Dung Dinh
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1231
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,
david.abram
david.abram
SSC Eights!
SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)

Group: General Forum Members
Points: 855 Visits: 715
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
SQLAJ
SSC-Enthusiastic
SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)

Group: General Forum Members
Points: 111 Visits: 410
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
Dung Dinh
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1231
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
Dung Dinh
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1231
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
david.abram
SSC Eights!
SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)

Group: General Forum Members
Points: 855 Visits: 715
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
Dung Dinh
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1231
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
david.abram
SSC Eights!
SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)SSC Eights! (855 reputation)

Group: General Forum Members
Points: 855 Visits: 715
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
Dung Dinh
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1231
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 Smile
Thanks so much,
vanapandi
vanapandi
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 45
while login,try with your old domain name as server name..it may help you
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search