Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to log into SQL Server after joining to Domain (issue is resolved, informational question only!) Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 11:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 961, Visits: 4,981
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.
Post #1357605
Posted Tuesday, September 11, 2012 1:50 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:39 AM
Points: 77, Visits: 425

Wait for it....

in rights what is higher, the domain or the local?




"We never plan to Fail, We just fail to plan":)
Post #1357677
Posted Wednesday, September 12, 2012 10:20 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 961, Visits: 4,981
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
Post #1358101
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse