September 11, 2012 at 11:31 am
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.
Some basics:
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?
Second:
How could I have prevented this when I joined the system to the Domain?
Thanks,
Jason A.
September 11, 2012 at 1:50 pm
Wait for it....
in rights what is higher, the domain or the local?
"We never plan to Fail, We just fail to plan":)
September 12, 2012 at 10:20 am
Thanks. I guess what was throwing me was, I would have expected to still be able to logon to the SQL using one of the existing local Windows users.
Jason
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply