none
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

Answers

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

    Thanks

    Bhanu

    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

    MVP

    Wednesday, January 6, 2016 7:39 AM
    Moderator