So I have an SQL Server at home for "playing" with. I recently joined this system to a domain I set as well, and after that, I was unable to log into the SQL.
The SQL Server Service is running under the NT Authority\NetworkService account
It was (and is) running in Windows Authentication mode
I was able to login fine before joining to the domain
After I joined the PC to the domain, I couldn't log in, even when I logged into the server using a local account that had local Admin access, I couldn't log into the SQL, I would get access denied.
Now, I did manage to resolve the problem through the use of the DAC, enabling the SA account, etc.
So, my question is, first:
Why did my local accounts that worked before, lose access?
How could I have prevented this when I joined the system to the Domain?