{"id":18147,"date":"2024-03-25T06:45:00","date_gmt":"2024-03-25T05:45:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=18147"},"modified":"2022-11-17T11:48:02","modified_gmt":"2022-11-17T10:48:02","slug":"create-sql-server-user-with-ssms","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/","title":{"rendered":"Create SQL Server user with SSMS and set up access rights"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-how-to-create-a-new-sql-server-user-with-sql-server-management-studio-ssms\"><strong><em>How to create a new SQL Server user with SQL Server Management Studio (SSMS)?<\/em><\/strong><\/h4>\n\n\n\n<p>This SQL Server administration tutorial explains how to create a SQL Server user login with SSMS, used to connect to the databases of an instance. The user login can have a Windows security or the SQL Server security. Security management in SQL Server in general and in SQL databases is a task for database administrators. They are called Data Base Administrators (DBA).<\/p>\n\n\n\n<p>In this short SSMS tutorial you will learn how to create a new SQL Server user login without any script. It is also possible to create a login with a SQL script.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#1-open-the-ssms-menu-to-create-a-sql-server-user\" >1. Open the SSMS menu to create a SQL Server user<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#2-configure-the-sql-server-user-with-ssms\" >2. Configure the SQL Server user with SSMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#3-add-roles-to-the-sql-server-login\" >3. Add roles to the SQL Server login<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#4-configure-the-user-login-mapping-to-databases\" >4. Configure the user login mapping to databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#5-finish-the-creation-of-the-sql-server-user\" >5. Finish the creation of the SQL Server user<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#ms-sql-database-administration-tutorials\" >MS SQL database administration tutorials<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-open-the-ssms-menu-to-create-a-sql-server-user\"><\/span>1. Open the SSMS menu to create a SQL Server user<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First step, open SQL Server Management Studio. A database is visible and accessible from the SSMS <a href=\"https:\/\/www.sciencedirect.com\/topics\/computer-science\/software-interface\" target=\"_blank\" rel=\"noreferrer noopener\">interface<\/a>. In our case, the database is named DB-Expert-Only. To create a new user account, follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From <strong>Security<\/strong><\/li>\n\n\n\n<li>Right-click on the <strong>Logins<\/strong> sub-folder.<\/li>\n\n\n\n<li>Now click on <strong>New Login<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"971\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\" alt=\"Create a new SQL Server user login with SSMS\" class=\"wp-image-4383\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg 971w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login-768x555.jpg 768w\" sizes=\"auto, (max-width: 971px) 100vw, 971px\" \/><figcaption class=\"wp-element-caption\">Create a SQL Server user with SSMS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-configure-the-sql-server-user-with-ssms\"><\/span>2. Configure the SQL Server user with SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the Login &#8211; New window enter the credentials, in this case it is US-Expert-Only. Then choose SQL Server authentication and enter the password twice. Then uncheck Enforce password expiration so that the password never expires. This rule should be set up according to your security needs.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password.jpg\" alt=\"Enter the new user name and SQL Server password in SSMS\" class=\"wp-image-4385\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\">Enter the new login name and SQL Server password in SSMS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-add-roles-to-the-sql-server-login\"><\/span>3. Add roles to the SQL Server login<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now, in the Server Roles tab check the sysadmin button, note that the account created will then have full rights to the SQL Server database instance. That is, the new login will have <strong><em>full privileges<\/em><\/strong> on this test database.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles.jpg\" alt=\"Assign the sysadmin role on the SQL Server database\" class=\"wp-image-4387\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\">Assign the sysadmin role on the SQL Server database<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configure-the-user-login-mapping-to-databases\"><\/span>4. Configure the user login mapping to databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To assign the created account to the database, click on User Mapping, all existing databases are displayed. Clicking on a database displays the list of users in the database as below. Click on the master database, check db_owner and public, then validate. Note that the db_owner role is an administrator role with full privileges on these databases.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment.jpg\" alt=\"Check db_owner for the SQL Server login\" class=\"wp-image-4389\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment.jpg 669w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment-300x269.jpg 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><figcaption class=\"wp-element-caption\">Check db_owner for the SQL Server user login<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-finish-the-creation-of-the-sql-server-user\"><\/span>5. Finish the creation of the SQL Server user<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>All the necessary configurations are done, in the <em>Securables<\/em> tab, simply click on OK. This is the last step in creating a new SQL Server user with SSMS.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables.jpg\" alt=\"Finish the user creation in SSMS by the validation\" class=\"wp-image-4391\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\">Finish the user creation in SSMS by the validation<\/figcaption><\/figure>\n\n\n\n<p>The new US-Expert-Only user login now appears in the SQL instance login list. The system lists the new credentials after creating a SQL Server login.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list.jpg\" alt=\"Create a SQL Server user with SSMS and check the New login in the Logins list\" class=\"wp-image-4393\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\">Create a SQL Server user with SSMS and check the New login in the Logins list<\/figcaption><\/figure><\/div>\n\n\n<p>Then, to test the access, log in with the new login as an authorized user. Simply click on <strong>File<\/strong> then <strong>Connect<\/strong>, and enter the <strong>login<\/strong> and <strong>password<\/strong>, then click on <strong>Connect<\/strong> again.<\/p>\n\n\n\n<p>Finally, this tutorial explains how to create a SQL Server user login, step by step from the SSMS GUI. Many other functions are available to check the existence of an object in the scripts generated by SSMS.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"pWajIjayLy\"><a href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\">How To Create a SQL Server Database with SSMS ?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How To Create a SQL Server Database with SSMS ?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/embed\/#?secret=mnxbqRuqHt#?secret=pWajIjayLy\" data-secret=\"pWajIjayLy\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ms-sql-database-administration-tutorials\"><\/span>MS SQL database administration tutorials<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\">Create a SQL Server database with SSMS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/dba\/install-second-instance\/\">Install a second instance of SQL Server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/dba\/clear-transaction-log\/\">Clear the SQL Server transaction log and fix 9002 error<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to create a new SQL Server user with SQL Server Management Studio (SSMS)? This SQL Server administration tutorial explains how to create a SQL Server user login with SSMS, used to connect to the databases of an instance. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\" title=\"Create SQL Server user with SSMS and set up access rights\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5503,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[488],"tags":[627],"class_list":{"0":"post-18147","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-dba","8":"tag-create-en-2"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create SQL Server user with SSMS and set up access rights<\/title>\n<meta name=\"description\" content=\"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance&#039;s databases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create SQL Server user with SSMS and set up access rights\" \/>\n<meta property=\"og:description\" content=\"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance&#039;s databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-25T05:45:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Create SQL Server user with SSMS and set up access rights\",\"datePublished\":\"2024-03-25T05:45:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\"},\"wordCount\":566,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"keywords\":[\"create\"],\"articleSection\":[\"SQL Server DBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\",\"url\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\",\"name\":\"Create SQL Server user with SSMS and set up access rights\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"datePublished\":\"2024-03-25T05:45:00+00:00\",\"description\":\"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance's databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create SQL Server user with SSMS and set up access rights\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create SQL Server user with SSMS and set up access rights","description":"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance's databases.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/","og_locale":"en_US","og_type":"article","og_title":"Create SQL Server user with SSMS and set up access rights","og_description":"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance's databases.","og_url":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-25T05:45:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Create SQL Server user with SSMS and set up access rights","datePublished":"2024-03-25T05:45:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/"},"wordCount":566,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","keywords":["create"],"articleSection":["SQL Server DBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/","url":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/","name":"Create SQL Server user with SSMS and set up access rights","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","datePublished":"2024-03-25T05:45:00+00:00","description":"SQL Server DBA tutorial on how to create a SQL Server user login with SSMS and grant access rights to connect to the instance's databases.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-user-with-ssms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Create SQL Server user with SSMS and set up access rights"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/18147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=18147"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/18147\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5503"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=18147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=18147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=18147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}