SQL 2014 SSMS Problem login in RRS feed

  • Question

  • When installing sql 2014 instance, I added domain admin group to sql users with sysadmin privileges.   With a user who is a member of domain admin, I am able to login remotely.  However, not from localhost.   In both cases I am using windows authentication.

    What do I need to do to login locally?

    Thanks in advance

    Tuesday, January 5, 2016 8:45 PM


All replies

  • Hi,

    Make sure the windows accounts that you are using on remote machine and the local host are same. I doubt this is the problem. If you are using same windows accounts, there shouldn't be any problem?

    Also check the SQL Server error logs to see if there are any login failure errors

    Hope this helps



    Tuesday, January 5, 2016 9:17 PM
  • You may have to right-click SSMS and select "Run as Administrator".

    • Proposed as answer by Sebastian vd Putten Wednesday, January 6, 2016 10:27 AM
    • Marked as answer by rgelfand Wednesday, January 6, 2016 9:02 PM
    Tuesday, January 5, 2016 10:32 PM
  • When you say not able to login you must be getting some error message. Please share the error message and below link mught help you more

    troubleshooting connecting to database engine

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles


    Wednesday, January 6, 2016 7:39 AM