Fairly general question RRS feed

  • Question

  • What is the difference between SQL Server Log-ins, local server admins, and database users.
    Monday, January 26, 2015 8:41 PM

All replies

  • Hello Anonymous 10300.

    A login is a security principal, or an entity that can be authenticated by a secure system. Users need a login to connect to SQL Server. You can create a login based on a Windows principal (such as a domain user or a Windows domain group) or you can create a login that is not based on a Windows principal (such as an SQL Server login).
    A user is a database level security principal. Logins must be mapped to a database user to connect to a database. A login can be mapped to different databases as different users but can only be mapped as one user in each database
    If you have any other questions like these about SQL Server, I suggest you to ask them in the Getting started with SQL Server Forum.


    Luigi Bruno

    Monday, January 26, 2015 10:48 PM