create local database sql server management studio 17

This is common when people outside of your organization (for example customers) are connecting to your SQL Server. Select SQL user with password or a SQL user with login based on a SQL Server authentication login, when the person connecting cannot authenticate with Windows. To specify the database in Management Studio, in the Connect to dialog box, click Options, and then click the Connection Properties tab. IMPORTANT! When connecting as a contained database user you must provide the name of the database as part of the connection string. For more information, see Contained Database Users - Making Your Database Portable. To use this option on SQL Server 2016 (13.x), an administrator must first enable contained databases for the SQL Server, and the database be enabled for containment. This is an excellent choice when you want to be able to easily move your database between instances of SQL Server. Also called a contained database user, it is not associated with a login in the master database. If the person or group that needs to access the database does not have a login and if they only need access to one or few databases, create a Windows user or a SQL user with password. For information about how to create a login, see Create a Login This topic assumes that a login already exists in SQL Server. The database user can use the same name as the login, but that is not required. The database user is the identity of the login when it is connected to a database. For this situation, you will create a SQL user with login. First ask yourself, does the person or group that needs to access the database have a login? Logins in the master database are common for the people who manage the SQL Server and for people who need to access many or all of the database on the instance of SQL Server. If you are new to SQL Server, it can be difficult to determine what type of user you want to create. Login or user that is not mapped to a login The following graphic shows the 6 options in the green box, and indicates what they represent. Management Studio presents 6 options when creating a database user. You can create a database user by using SQL Server Management Studio or by using Transact-SQL. All varieties of SQL Server support database users, but not necessarily all types of users. The complete list is provided in the topic CREATE USER (Transact-SQL). This topic describes how to create the most common types of database users.

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Create local database sql server management studio 17