{"id":2831,"date":"2023-06-10T05:01:46","date_gmt":"2023-06-10T05:01:46","guid":{"rendered":"https:\/\/www.sysgeeker.com\/blog\/?p=2831"},"modified":"2023-06-10T05:01:46","modified_gmt":"2023-06-10T05:01:46","slug":"how-to-fix-windows-orphaned-users-on-sql-server","status":"publish","type":"post","link":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html","title":{"rendered":"How to Fix Windows Orphaned Users on Sql Server"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_31 counter-hierarchy counter-disc\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" style=\"display: none;\"><label for=\"item\" aria-label=\"Table of Content\"><i class=\"ez-toc-glyphicon ez-toc-icon-toggle\"><\/i><\/label><input type=\"checkbox\" id=\"item\"><\/a><\/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:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Video_Tutorial\" title=\"Video Tutorial:\">Video Tutorial:<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Why_You_Need_to_Fix_Orphaned_Users_on_SQL_Server\" title=\"Why You Need to Fix Orphaned Users on SQL Server\">Why You Need to Fix Orphaned Users on SQL Server<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Method_1_Using_sp_change_users_login\" title=\"Method 1: Using sp_change_users_login\">Method 1: Using sp_change_users_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:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Method_2_Using_SQL_Server_Management_Studio\" title=\"Method 2: Using SQL Server Management Studio\">Method 2: Using SQL Server Management Studio<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Method_3_Using_PowerShell\" title=\"Method 3: Using PowerShell\">Method 3: Using PowerShell<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#What_to_Do_If_You_Cant_Fix_Orphaned_Users_on_SQL_Server\" title=\"What to Do If You Can&#8217;t Fix Orphaned Users on SQL Server\">What to Do If You Can&#8217;t Fix Orphaned Users on SQL Server<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Bonus_Tip\" title=\"Bonus Tip\">Bonus Tip<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#5_FAQs\" title=\"5 FAQs\">5 FAQs<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\/#Final_Thoughts\" title=\"Final Thoughts\">Final Thoughts<\/a><\/li><\/ul><\/nav><\/div>\n<p>If you have been running a SQL Server for any length of time, chances are you have come across the issue of orphaned users. In simple terms, orphaned users are ones that are associated with logins that no longer exist on the server, making it impossible to authenticate them. This issue not only affects the security of your databases but can also cause errors in your applications. In this blog post, we will take a look at how to fix the orphaned user issue on SQL Server.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Video_Tutorial\"><\/span>Video Tutorial:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<lite-youtube videoid=\"m6BuToHFmrU\" playlabel=\"Play: Keynote (Google I\/O '18)\"><\/lite-youtube>\n <\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_You_Need_to_Fix_Orphaned_Users_on_SQL_Server\"><\/span>Why You Need to Fix Orphaned Users on SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Orphaned users are a problem because they can&#8217;t be authenticated due to a missing login. This means that they can&#8217;t access the databases, which can result in errors in your applications. Additionally, orphaned users can be a security risk if someone gets hold of an orphaned login. It&#8217;s important to regularly check for orphaned users to keep your SQL Server secure and running smoothly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Using_sp_change_users_login\"><\/span>Method 1: Using sp_change_users_login<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The sp_change_users_login system stored procedure is used to map a user in the current database to a login in SQL Server. The steps to use this method are as follows:<\/p>\n<p>1. Open SQL Server Management Studio (SSMS) and connect to your server.<br \/>\n2. Open a new query window.<br \/>\n3. Type the following command in the query window: <\/p>\n<p>\"<strong>`<br \/>\nUSE [YourDatabaseName]\nGO<br \/>\nsp_change_users_login @Action=&#8217;Report&#8217;<br \/>\n\"<strong>`<\/p>\n<p>4. This command will generate a list of all the orphaned users in the database.<br \/>\n5. To fix the orphaned user issue, type the following command in the query window:<\/p>\n<p>\"<strong>`<br \/>\nUSE [YourDatabaseName]\nGO<br \/>\nsp_change_users_login @Action=&#8217;update_one&#8217;, @UserNamePattern=&#8217;YourUserName&#8217;, @LoginName=&#8217;YourLoginName&#8217;<br \/>\n\"<strong>`<\/p>\n<p>Replace `YourDatabaseName` with the name of your database, `YourUserName` with the name of the orphaned user, and `YourLoginName` with the name of the login you want to map it to.<\/p>\n<p><strong>Pros:<\/strong><br \/>\n&#8211; Quick and easy to use.<br \/>\n&#8211; Can map multiple users to the same login.<br \/>\n&#8211; Provides a report of all orphaned users.<\/p>\n<p><strong>Cons:<\/strong><br \/>\n&#8211; Requires some knowledge of SQL Server.<br \/>\n&#8211; Can only map one user to a login at a time.<br \/>\n&#8211; Relies on stored procedures.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Using_SQL_Server_Management_Studio\"><\/span>Method 2: Using SQL Server Management Studio<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL Server Management Studio (SSMS) provides a graphical user interface for managing databases, including fixing orphaned users. The steps to use this method are:<\/p>\n<p>1. Open SSMS and connect to your server.<br \/>\n2. Expand the databases node in the Object Explorer.<br \/>\n3. Right-click on the database that has the orphaned user and select Properties.<br \/>\n4. Click on the Files page on the left-hand side.<br \/>\n5. Take note of the logical name of the database.<br \/>\n6. Click on the User Mapping page.<br \/>\n7. Check the box next to the username that is orphaned.<br \/>\n8. In the Login section of the page, select the login you want to map the user to.<br \/>\n9. In the Default Schema section, select the schema you want the user to be associated with.<br \/>\n10. Click OK to save the changes.<\/p>\n<p><strong>Pros:<\/strong><br \/>\n&#8211; Easy to use for those not familiar with SQL Server.<br \/>\n&#8211; Can map multiple users to a login at once.<br \/>\n&#8211; Provides a graphical interface.<\/p>\n<p><strong>Cons:<\/strong><br \/>\n&#8211; Can be slow for large databases.<br \/>\n&#8211; Limited mapping options compared to sp_change_users_login.<br \/>\n&#8211; Can generate errors if not used correctly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_Using_PowerShell\"><\/span>Method 3: Using PowerShell<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>PowerShell is a powerful scripting tool that can be used to automate common administrative tasks in SQL Server, including fixing orphaned users. The steps to use this method are:<\/p>\n<p>1. Open PowerShell.<br \/>\n2. Type the following command to connect to your SQL Server instance:<\/p>\n<p>\"<strong>`<br \/>\n$serverInstance = New-Object Microsoft.SqlServer.Management.Smo.Server(\"<strong>YourServerName<\/strong>\")<br \/>\n\"<strong>`<\/p>\n<p>3. Type the following command to get the database object:<\/p>\n<p>\"<strong>`<br \/>\n$db = $serverInstance.Databases[\"<strong>YourDatabaseName<\/strong>\"]\n\"<strong>`<\/p>\n<p>4. Type the following command to get the user object:<\/p>\n<p>\"<strong>`<br \/>\n$user = $db.Users[\"<strong>YourUserName<\/strong>\"]\n\"<strong>`<\/p>\n<p>Replace `YourServerName` with the name of your server, `YourDatabaseName` with the name of your database, and `YourUserName` with the name of the orphaned user.<\/p>\n<p>5. Type the following command to assign a new login to the user:<\/p>\n<p>\"<strong>`<br \/>\n$user.Login = \"<strong>YourLoginName<\/strong>\"<br \/>\n\"<strong>`<\/p>\n<p>Replace `YourLoginName` with the name of the login you want to map it to.<\/p>\n<p>6. Type the following command to update the user:<\/p>\n<p>\"<strong>`<br \/>\n$user.Alter()<br \/>\n\"<strong>`<\/p>\n<p><strong>Pros:<\/strong><br \/>\n&#8211; Can be automated and scripted for large databases.<br \/>\n&#8211; Provides more control over mapping options.<br \/>\n&#8211; PowerShell is a powerful tool that can be used for other administrative tasks.<\/p>\n<p><strong>Cons:<\/strong><br \/>\n&#8211; Requires knowledge of PowerShell.<br \/>\n&#8211; Mapping process can be time-consuming for multiple users.<br \/>\n&#8211; Can generate errors if not used correctly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_to_Do_If_You_Cant_Fix_Orphaned_Users_on_SQL_Server\"><\/span>What to Do If You Can&#8217;t Fix Orphaned Users on SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you are unable to fix the orphaned user issue using the methods described above, there are a few things you can do. Firstly, you can restore a backup of the database from a time before the orphaned user issue occurred. Alternatively, you can create a new user and login, map the user to the login, and then transfer the permissions from the orphaned user to the new user.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bonus_Tip\"><\/span>Bonus Tip<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Regularly monitoring your SQL Server for orphaned users can help prevent security risks and errors in your applications. Set up alerts to notify you when orphaned users are detected.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_FAQs\"><\/span>5 FAQs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h4>Q1: What causes orphaned users?<\/h4>\n<p>A: Orphaned users can be caused by a variety of things, including deleting a login that is associated with a user, restoring a database from a backup that was created on a different SQL Server instance, or migrating a database to a new instance.<\/p>\n<h4>Q2: Can orphaned users access my database?<\/h4>\n<p>A: Orphaned users cannot access your database as they are not associated with a valid login.<\/p>\n<h4>Q3: How do I check for orphaned users?<\/h4>\n<p>A: The sp_change_users_login system stored procedure or SQL Server Management Studio can be used to check for orphaned users.<\/p>\n<h4>Q4: Can I use these methods on all versions of SQL Server?<\/h4>\n<p>A: Yes, these methods can be used on all versions of SQL Server.<\/p>\n<h4>Q5: What happens to the user&#8217;s permissions when I map them to a new login?<\/h4>\n<p>A: The user&#8217;s permissions remain intact when mapping them to a new login.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Final_Thoughts\"><\/span>Final Thoughts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Fixing orphaned users on SQL Server is an important task that can help keep your databases and applications running smoothly. Whether you choose to use sp_change_users_login, SQL Server Management Studio, or PowerShell, it&#8217;s important to regularly monitor your databases for orphaned users and take action as necessary.<script type=\"application\/ld+json\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\" What causes orphaned users?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\" Orphaned users can be caused by a variety of things, including deleting a login that is associated with a user, restoring a database from a backup that was created on a different SQL Server instance, or migrating a database to a new instance.\"}},{\"@type\":\"Question\",\"name\":\" Can orphaned users access my database?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\" Orphaned users cannot access your database as they are not associated with a valid login.\"}},{\"@type\":\"Question\",\"name\":\" How do I check for orphaned users?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\" The sp_change_users_login system stored procedure or SQL Server Management Studio can be used to check for orphaned users.\"}},{\"@type\":\"Question\",\"name\":\" Can I use these methods on all versions of SQL Server?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\" Yes, these methods can be used on all versions of SQL Server.\"}},{\"@type\":\"Question\",\"name\":\" What happens to the user's permissions when I map them to a new login?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\" The user's permissions remain intact when mapping them to a new login.\"}}]}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have been running a SQL Server for any length of time, chances are you have come across the issue of orphaned users. In simple terms, orphaned users are ones that are associated with logins that no longer exist on the server, making it impossible to authenticate them. This issue not only affects the [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Fix Windows Orphaned Users on Sql Server<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix Windows Orphaned Users on Sql Server\" \/>\n<meta property=\"og:description\" content=\"If you have been running a SQL Server for any length of time, chances are you have come across the issue of orphaned users. In simple terms, orphaned users are ones that are associated with logins that no longer exist on the server, making it impossible to authenticate them. This issue not only affects the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\" \/>\n<meta property=\"og:site_name\" content=\"SYSGEEKER\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-10T05:01:46+00:00\" \/>\n<meta name=\"author\" content=\"Jacques\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jacques\" \/>\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\":\"Organization\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#organization\",\"name\":\"SYSGEEKER\",\"url\":\"https:\/\/www.sysgeeker.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sysgeeker.com\/blog\/wp-content\/uploads\/2024\/03\/logo-1.png\",\"contentUrl\":\"https:\/\/www.sysgeeker.com\/blog\/wp-content\/uploads\/2024\/03\/logo-1.png\",\"width\":27,\"height\":32,\"caption\":\"SYSGEEKER\"},\"image\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#website\",\"url\":\"https:\/\/www.sysgeeker.com\/blog\/\",\"name\":\"SYSGEEKER\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sysgeeker.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\",\"url\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\",\"name\":\"How to Fix Windows Orphaned Users on Sql Server\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#website\"},\"datePublished\":\"2023-06-10T05:01:46+00:00\",\"dateModified\":\"2023-06-10T05:01:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sysgeeker.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix Windows Orphaned Users on Sql Server\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\"},\"author\":{\"name\":\"Jacques\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/33fcf36b86673f6777f6bd620f409ee5\"},\"headline\":\"How to Fix Windows Orphaned Users on Sql Server\",\"datePublished\":\"2023-06-10T05:01:46+00:00\",\"dateModified\":\"2023-06-10T05:01:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html\"},\"wordCount\":1064,\"publisher\":{\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#organization\"},\"articleSection\":[\"Windows\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/33fcf36b86673f6777f6bd620f409ee5\",\"name\":\"Jacques\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d42e418b03976350ac20f5414ab37883?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d42e418b03976350ac20f5414ab37883?s=96&d=mm&r=g\",\"caption\":\"Jacques\"},\"url\":\"https:\/\/www.sysgeeker.com\/blog\/author\/jacques\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix Windows Orphaned Users on Sql Server","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:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html","og_locale":"en_US","og_type":"article","og_title":"How to Fix Windows Orphaned Users on Sql Server","og_description":"If you have been running a SQL Server for any length of time, chances are you have come across the issue of orphaned users. In simple terms, orphaned users are ones that are associated with logins that no longer exist on the server, making it impossible to authenticate them. This issue not only affects the [&hellip;]","og_url":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html","og_site_name":"SYSGEEKER","article_published_time":"2023-06-10T05:01:46+00:00","author":"Jacques","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jacques","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.sysgeeker.com\/blog\/#organization","name":"SYSGEEKER","url":"https:\/\/www.sysgeeker.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.sysgeeker.com\/blog\/wp-content\/uploads\/2024\/03\/logo-1.png","contentUrl":"https:\/\/www.sysgeeker.com\/blog\/wp-content\/uploads\/2024\/03\/logo-1.png","width":27,"height":32,"caption":"SYSGEEKER"},"image":{"@id":"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.sysgeeker.com\/blog\/#website","url":"https:\/\/www.sysgeeker.com\/blog\/","name":"SYSGEEKER","description":"","publisher":{"@id":"https:\/\/www.sysgeeker.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sysgeeker.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html","url":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html","name":"How to Fix Windows Orphaned Users on Sql Server","isPartOf":{"@id":"https:\/\/www.sysgeeker.com\/blog\/#website"},"datePublished":"2023-06-10T05:01:46+00:00","dateModified":"2023-06-10T05:01:46+00:00","breadcrumb":{"@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sysgeeker.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Fix Windows Orphaned Users on Sql Server"}]},{"@type":"Article","@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html#article","isPartOf":{"@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html"},"author":{"name":"Jacques","@id":"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/33fcf36b86673f6777f6bd620f409ee5"},"headline":"How to Fix Windows Orphaned Users on Sql Server","datePublished":"2023-06-10T05:01:46+00:00","dateModified":"2023-06-10T05:01:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sysgeeker.com\/blog\/how-to-fix-windows-orphaned-users-on-sql-server.html"},"wordCount":1064,"publisher":{"@id":"https:\/\/www.sysgeeker.com\/blog\/#organization"},"articleSection":["Windows"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/33fcf36b86673f6777f6bd620f409ee5","name":"Jacques","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysgeeker.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d42e418b03976350ac20f5414ab37883?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d42e418b03976350ac20f5414ab37883?s=96&d=mm&r=g","caption":"Jacques"},"url":"https:\/\/www.sysgeeker.com\/blog\/author\/jacques"}]}},"_links":{"self":[{"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/posts\/2831"}],"collection":[{"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/comments?post=2831"}],"version-history":[{"count":1,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/posts\/2831\/revisions"}],"predecessor-version":[{"id":3174,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/posts\/2831\/revisions\/3174"}],"wp:attachment":[{"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/media?parent=2831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/categories?post=2831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sysgeeker.com\/blog\/wp-json\/wp\/v2\/tags?post=2831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}