Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Could not login after changing domain account. Expand / Collapse
Author
Message
Posted Wednesday, February 6, 2013 3:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 153, Visits: 1,003
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,
Post #1416375
Posted Wednesday, February 6, 2013 5:17 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 618, Visits: 456
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


Post #1416427
Posted Wednesday, February 6, 2013 5:40 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 7:20 PM
Points: 85, Visits: 404
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
Post #1416438
Posted Wednesday, February 6, 2013 7:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 153, Visits: 1,003
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
Post #1416503
Posted Wednesday, February 6, 2013 7:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 153, Visits: 1,003
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.
Post #1416505
Posted Wednesday, February 6, 2013 7:44 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 618, Visits: 456
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.
Post #1416508
Posted Wednesday, February 6, 2013 7:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 153, Visits: 1,003
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.
Post #1416517
Posted Wednesday, February 6, 2013 8:21 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 618, Visits: 456
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.
Post #1416537
Posted Wednesday, February 6, 2013 7:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 153, Visits: 1,003
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,
Post #1416784
Posted Wednesday, February 6, 2013 11:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 2, 2014 12:06 AM
Points: 22, Visits: 45
while login,try with your old domain name as server name..it may help you
Post #1416817
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse