September 7, 2010 at 7:54 am
Hi all
Our infrastructure team have move a bunch of local machine to a new domain and now the SQL instances won't start. I have changed the services to accounts that will allow the service sot start at least, but no I can't log in because the SA account was an account from the old domain and the SA sql login is disabled.
Anyone any ideas how to get round this?
Thanks
September 7, 2010 at 8:47 am
new domain, new security.
You need to configure some windows account which have the admin permission on domain and then that can be used to run the services.
Later on same account can be configured as SA.
----------
Ashish
September 8, 2010 at 4:55 am
Try Login to SQL Server in Single user mode and add a user from new domain.. or enable the sa login
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply