Post reply

cannot login sql server as an administrator

  • December 6, 2010 at 10:24 am

    #143754

    After I install sql server 2005 on a windows 2008 server, I tried login using my admin account, but I cannot. It said access denied.

    When during the setup process, I installed using mix mode of server authentication (this is because some of applications needs the specific users to connect database), I was given a chance to createa an account for sa.

    But now I can only login using sa, but not my admin account.

    I used the admin account install sql server, and my admin account is also a member of local administrator group.

    After I log into SQL server using sa, I can see builtin\administrator is listed in Security-Login and server role is systemadmin.

    But why I cannot login using it when I using windows authentication?

    Thanks

  • December 6, 2010 at 10:59 am

    #1259133

    Did you change anything else? Did you add a deny login for any group?

    Are you sure your Windows account is still a local administrator on the server? Did you verify this? Did you check the security log to verify what account SQL Server is refusing?

    Something must have changed since local administrators, by default, have access to the SQL Server instance.

  • December 6, 2010 at 11:01 am

    #1259134

    When you install SQL Server, there's an option for adding the current login (the one you're using to install it) as an admin. If you don't select that, sa and the actual local admin account will be the only admin logins.

    You'll need to log in as sa (or as the local Administrator account), and add your AD group to the sys admin role.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 6, 2010 at 11:46 am

    #1259146

    Thank you, for my case it turns out it's UCL is enabled on the windows 2008 server, default.

    It will work if I right click managment studio and choose run as an administrator.

    Thanks

  • December 7, 2010 at 6:35 am

    #1259497

    Ann Cao (12/6/2010)

    Thank you, for my case it turns out it's UCL is enabled on the windows 2008 server, default.

    It will work if I right click managment studio and choose run as an administrator.

    Thanks

    Ah. That makes sense.

    I think you can create a shortcut on the desktop that will default to running as an admin.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 7, 2010 at 8:38 am

    #1259580

    Thank you all!

Viewing 6 posts - 1 through 6 (of 6 total)

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