can't logon - windows user accounts re-created instance in Windows Authentication mode
Hi, my SQL instance is running in Windows Authentication mode. The windows accounts that had access to SQL have all been deleted and then recreated on a different server, although the name is the same the password has changed. Consequently (I think), I cannot logon to the db engine or any of the databases, none of the accounts work. I can logon to integration services or analysis services. Does anybody now what I could do, other than salvage the database files and re-install SQL server?
OK, you should still be able to logon using the sa account - its a SQL login. Once you are connected you should then be able to give your DBA's windows group the permission they need to connect to the server. Once thats done, log the sa account off , logon as yourself and reinstate the windows groups/accounts. That should be pretty close to as it was ... The logins on the 'other's server wont have passwords as they are windows accounts. If they are SQL logins that have been transferred then they will have random passwords that the DBAs will be able to assign one by one.