Our SQL admin / DBA guy suddenly quit with no notice. We use SQL 2012. We discovered he documented nothing. So now we don't know the sa password. No other SQL users have the sysadmin role so we have no way of signing in as admin. I went directly to the server where our databases are and tried to login using Windows Authentication but got this error:
TITLE: Connect to Server
Cannot connect to 126.96.36.199.
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
I am afraid we will have to reinstall SQL but it's not something I usually do as I'm a developer. Is there any other way to find the sa password or at least be able to change it? Thanks in advance.