Post reply

MS SQL 2005 and MS SQL 2008

  • October 21, 2010 at 8:56 am

    #230775

    Hi, I'm a domain administrator and I log onto quite a few MS SQL 2005 instances with no issue. A new instance of MS SQL 2008 was recently installed and I tried to log on with my domain account but it refused. I could only log on with the local adminsitrator account and created a login for my domain account to be able to log onto the 2008 instance win and sql authentication. I never had to do this for any 2005 instance. I didn't install the 2008 instance so my question is it because of the way the install was done or is it a 2008 thing? I assumed for domain accounts sql would check rights on the Active Directory ... Domain Admin would have rights to everything ... I would understand if a non domain admin would not be allowed to log onto any sql instance be it 2005 or 2008.

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • October 21, 2010 at 9:29 am

    #1240405

    security is getting tighter and tighter with each iteration of SQL;

    it used to be that the Builtin\Administrators group was automatically added as sysadmins when you installed SQL.

    That is no longer true for SQL 2008 and above...the only sysadmin is "sa" upon installation, i think.

    you have to explicitly add any domain groups now, which is the behavior you are seeing....no rights by default.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 22, 2010 at 12:21 am

    #1240728

    thanks 😉 I thought as much

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply