Post reply

How to add Administrator account to SQL?

  • March 7, 2007 at 2:17 pm

    #76669

    Hi,

    I'm trying to log into SSMS. The default is 'windows authentication' with the local administrator account showing in the username box. When I try to connect it says 'Login failed for user ''. The user is not associated with a trusted sql server connection'. Switching to mixed mode and entering the user/pass does not help.

    How do I add the server's local Administrator account to SQL so I can log in using this account?

  • March 7, 2007 at 2:57 pm

    #693670

    you should normally connect using integrated security which does require any user account details. You should be able to connect using sa. on a workgroup you add a user to the server administrators group , this group is sysadmin by default on the sql box.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 8, 2007 at 6:57 am

    #693796

    They will only be sysadmin in sql if the Builtin\Administrators login is there. This usually goes against best practices having this login there though.

  • March 9, 2007 at 3:16 am

    #694023

    In a default installation of SQL 2000/2005 the BUILTIN\Administrators group is a member of the sysadmin server role. So unless it's been removed for security reasons, you should be able to login without any problem.

     

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

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