{"id":1121,"date":"2010-09-18T22:19:06","date_gmt":"2010-09-18T16:49:06","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=1121"},"modified":"2010-09-18T22:19:06","modified_gmt":"2010-09-18T16:49:06","slug":"create-new-user-in-sql-server-2005","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/create-new-user-in-sql-server-2005\/","title":{"rendered":"Create new User in SQL Server 2005"},"content":{"rendered":"<p>Login into SQL Server and right click on <strong>security <\/strong>tab.<\/p>\n<p>Select <strong>New -&gt; Login.<\/strong><\/p>\n<figure id=\"attachment_1122\" aria-describedby=\"caption-attachment-1122\" style=\"width: 288px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-Security-folder.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1122\" title=\"SQL Server Security folder\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-Security-folder.jpg?resize=288%2C273&#038;ssl=1\" alt=\"SQL Server Security folder\" width=\"288\" height=\"273\" \/><\/a><figcaption id=\"caption-attachment-1122\" class=\"wp-caption-text\">SQL Server Security folder<\/figcaption><\/figure>\n<p><!--more--><\/p>\n<p>On Next screen, enter Username and password as shown in below image.<\/p>\n<figure id=\"attachment_1123\" aria-describedby=\"caption-attachment-1123\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-Create-Login.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1123\" title=\"SQL Server Create Login\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-Create-Login-300x257.jpg?resize=300%2C257&#038;ssl=1\" alt=\"SQL Server Create Login\" width=\"300\" height=\"257\" \/><\/a><figcaption id=\"caption-attachment-1123\" class=\"wp-caption-text\">SQL Server Create Login<\/figcaption><\/figure>\n<p>Click on <strong>ok <\/strong>button, a new user with specified credentials will be created.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create new User in SQL Server 2005<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14],"tags":[292],"class_list":["post-1121","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1166,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/get-login-session-count-session-mode-user-name-machine-name-in-sql-server\/","url_meta":{"origin":1121,"position":0},"title":"Get Login Session count, Session Mode, User Name, Machine name in SQL Server","author":"Jitendra","date":"September 29, 2010","format":false,"excerpt":"Get Login Session count, Session Mode, User Name, Machine name in SQL Server","rel":"","context":"In &quot;SQL Server&quot;","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1105,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/install-sql-server-2005-in-windows-xp\/","url_meta":{"origin":1121,"position":1},"title":"Install SQL Server 2005 in Windows XP","author":"Jitendra","date":"September 16, 2010","format":false,"excerpt":"Steps to Install SQL Server 2005 - Standard edition in Windows XP","rel":"","context":"In &quot;SQL Server&quot;","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"SQL Server 2005 Accept License","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/SQL-Server-2005-Accept-License-300x246.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":454,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/drop-stored-procedure-if-exist-in-sql-server\/","url_meta":{"origin":1121,"position":2},"title":"Drop Stored Procedure if exist in SQL Server","author":"Jitendra","date":"June 30, 2010","format":false,"excerpt":"How to drop the stored procedure in SQL Server if exist","rel":"","context":"In &quot;SQL&quot;","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":665,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/execute-dynamic-query-in-sql-server\/","url_meta":{"origin":1121,"position":3},"title":"Execute dynamic Query in SQL Server","author":"Jitendra","date":"July 16, 2010","format":false,"excerpt":"How to execute the dynamic query in microsoft SQL Server 2005.","rel":"","context":"In &quot;SQL&quot;","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":829,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/convert-rows-into-comma-separated-values-column-sql-server\/","url_meta":{"origin":1121,"position":4},"title":"Convert rows into comma separated values column &#8211; SQL Server","author":"Jitendra","date":"October 4, 2010","format":false,"excerpt":"Convert rows into comma separated values column - SQL Server","rel":"","context":"In &quot;SQL Server&quot;","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1184,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/manually-attach-database-in-sql-server\/","url_meta":{"origin":1121,"position":5},"title":"Manually attach database in SQL Server","author":"Jitendra","date":"October 6, 2010","format":false,"excerpt":"Download sample database of SQL server and Manually attach database in SQL Server - AdventureWorksDB","rel":"","context":"In &quot;SQL Server&quot;","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"Select Existing mdb file on system to attach","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/10\/Select-Existing-mdb-file-on-system-to-attach-300x258.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=1121"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1121\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}