{"id":107890,"date":"2022-09-27T12:17:53","date_gmt":"2022-09-27T12:17:53","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=107890"},"modified":"2026-09-04T09:11:31","modified_gmt":"2026-09-04T09:11:31","slug":"how-to-fix-sql-server-database-error-18456","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","title":{"rendered":"How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p class=\"wp-block-paragraph\">You may encounter the <strong>Microsoft SQL Server error 18456 Severity 14, State 38<\/strong> <strong>Couldn&rsquo;t find database requested by user<\/strong>, when you try to connect to a SQL Server instance. The error indicates that connection attempt is rejected by the server due to an authentication failure. You can face this issue with both SQL Server Authentication (for example, the &lsquo;sa&rsquo; account) and Windows Authentication. <strong>The server displays general messages related to failed user logins, such as invalid credentials, null\/empty users, or anonymous logon \\NT AUTHORITY.<\/strong> It hides the specific details about the error due to security reasons, but you can check the SQL Server Error Log for the exact reason. The error can occur due to several reasons such as incorrect credentials, mismatched authentication modes, or expired passwords.&nbsp; In this article, we will learn what causes the error 18456 in SQL Server and how to fix it.<\/p><h2 class=\"wp-block-heading\" id=\"why-does-sql-server-authentication-error-18456-&nbsp;occur?\">Why does SQL Server Authentication Error 18456 &nbsp;Occur?<\/h2><p class=\"wp-block-paragraph\">This SQL Server error can occur due to one of the following reasons:<\/p><ul class=\"wp-block-list\">\n<li><strong>Default Database is Offline:<\/strong> The explicitly specified database for SQL Server login is offline, unavailable, or corrupted.<\/li>\n\n\n\n<li><strong>Missing User Permissions<\/strong>: The user doesn&rsquo;t have permission to the requested database.<\/li>\n\n\n\n<li><strong>Missing or Incorrect Credentials in Connection String:<\/strong> The connection attempt can fail if the connection string has incorrect syntax, server name, or user credentials. The State 38 means that the database explicitly specified in the connection string or in SSMS is incorrect, offline, or does not exist.<\/li>\n\n\n\n<li><strong>No Admin Privileges<\/strong>: You might not be running the SQL application (SSMS) with admin credentials.<\/li>\n\n\n\n<li><strong>Deleted Login Post-Migration<\/strong>: The Login was deleted after migrating the database to a <a href=\"https:\/\/techcommunity.microsoft.com\/blog\/sqlserver\/contained-database-authentication-introduction\/383696\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">contained database<\/a> user.<\/li>\n\n\n\n<li><strong>Incorrect Password<\/strong>: You&rsquo;re using SQL Server Authentication, but the password you specified for SQL Server login is incorrect<\/li>\n\n\n\n<li><strong>Incorrect SQL Login Account:<\/strong> The SQL instance may reject the connection if it fails to find a login matching the provided name. This usually happens if the account was never created on the server or the username is typed incorrectly.<\/li>\n\n\n\n<li><strong>Disabled Authentication Type<\/strong>: SQL logins are not enabled. For example, you&rsquo;re trying to use SQL Server Authentication when the server instance is configured for Windows Authentication mode only.<\/li>\n\n\n\n<li><strong>Group Membership and Permission Issues<\/strong>: The connection can fail when you try to access the SQL Server via a Windows group. It usually happens if the group lacks server permissions, the user identity cannot be resolved in Active Directory (AD) due to domain controller connection issues, or you might be accessing a cross-domain group located in the wrong domain.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"check-sql-server-logs-for-18456-error\">Check SQL Server Logs for 18456 Error<\/h2><p class=\"wp-block-paragraph\">SQL Server intentionally hides the exact reason and nature of the authentication error 18456 on the client side to keep the system safe. However, it records a specific State number in the logs. You need to check the SQL Server logs for the error state that indicates the cause of failure. For example, 2 or 5 indicates an invalid user ID, 8 or 9 incorrect password, and 38 or 46 fails to find database requested by user. These can help you troubleshoot the authentication issues.<\/p><p class=\"wp-block-paragraph\">To check for the State number in 18456 error, you can use SSMS (if accessible) or the Windows Event Viewer. If you fail to connect to server instance using SA account, try using an alternative administrative account to open SSMS. For example, Windows Authentication.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"526\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-another-method-windows-authentication-to-connect-server-instance.png\" alt=\"Selecting another instance windows-authentication to connect Server Instance\" class=\"wp-image-199853 apply-gradient-on-post-images\" style=\"aspect-ratio:0.9220532319391636;width:485px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-another-method-windows-authentication-to-connect-server-instance.png 485w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-another-method-windows-authentication-to-connect-server-instance-277x300.png 277w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/figure><p class=\"wp-block-paragraph\">After connecting to the server instance, under <strong>Object Explorer,<\/strong> expand <strong>Management<\/strong> section, click <strong>SQL Server Log,<\/strong> and then click <strong>View.<\/strong><\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"971\" height=\"654\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/View_SQL-Server-Log.png\" alt=\"Image showing steps to view SQL Server Log\" class=\"wp-image-199854 apply-gradient-on-post-images\" style=\"aspect-ratio:1.482185273159145;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/View_SQL-Server-Log.png 971w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/View_SQL-Server-Log-300x202.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/View_SQL-Server-Log-768x517.png 768w\" sizes=\"auto, (max-width: 971px) 100vw, 971px\" \/><\/figure><p class=\"wp-block-paragraph\">Search the SQL Server error logs for <strong>&ldquo;18456&rdquo;<\/strong>. You will find the error details, including the state number and reason, listed on the line directly above it.<\/p><figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/checking-error-18456-in-SQL-error-logs-1024x543.png\" alt=\"Checking error 18456 in SQL Error Logs\" class=\"wp-image-199855 apply-gradient-on-post-images\" style=\"aspect-ratio:1.8851963746223566;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/checking-error-18456-in-SQL-error-logs-1024x543.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/checking-error-18456-in-SQL-error-logs-300x159.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/checking-error-18456-in-SQL-error-logs-767x407.png 767w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/checking-error-18456-in-SQL-error-logs.png 1365w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p class=\"wp-block-paragraph\">If you cannot access the SSMS, follow this path to open the SQL Error log:<\/p><pre class=\"wp-block-code command_container\"><code>\nC:\\Program Files\\Microsoft SQL Server\\MSSQL&lt;Version&gt;.&lt;InstanceName&gt;\\MSSQL\\Log\\<\/code><\/pre><p class=\"wp-block-paragraph\">Alternatively, open the Windows Event Viewer to check the error logs. To open <strong>Event Viewer<\/strong>, type eventvwr in Run window and click <strong>OK.<\/strong><\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"402\" height=\"209\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/opening-Event-Viewer-window.png\" alt=\"Opening Event Viewer Window\" class=\"wp-image-199856 apply-gradient-on-post-images\" style=\"aspect-ratio:1.923444976076555;width:402px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/opening-Event-Viewer-window.png 402w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/opening-Event-Viewer-window-300x156.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/figure><p class=\"wp-block-paragraph\">In <strong>Event Viewer<\/strong> window, expand <strong>Windows Logs<\/strong> and select <strong>Application.<\/strong><\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"549\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-application-under-windows-logs-in-event-viewer.png\" alt=\"Searching 18456 error in Event Viewer by selecting application under windows logs\" class=\"wp-image-199857 apply-gradient-on-post-images\" style=\"aspect-ratio:1.4344827586206896;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-application-under-windows-logs-in-event-viewer.png 787w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-application-under-windows-logs-in-event-viewer-300x209.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-application-under-windows-logs-in-event-viewer-767x535.png 767w\" sizes=\"auto, (max-width: 787px) 100vw, 787px\" \/><\/figure><p class=\"wp-block-paragraph\">Go to the right pane. Under Actions<strong>,<\/strong> select <strong>Filter Current Log&hellip;<\/strong><\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"556\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-filter-current-log-under-actions-on-event-viewer.png\" alt=\"Selecting filter current log under actions on Windows Event Viewer\" class=\"wp-image-199858 apply-gradient-on-post-images\" style=\"aspect-ratio:1.4181818181818182;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-filter-current-log-under-actions-on-event-viewer.png 789w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-filter-current-log-under-actions-on-event-viewer-300x211.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-filter-current-log-under-actions-on-event-viewer-768x541.png 768w\" sizes=\"auto, (max-width: 789px) 100vw, 789px\" \/><\/figure><p class=\"wp-block-paragraph\">In the <strong>Filter Current Log<\/strong> window, select <strong>MSSQLSERVER<\/strong> (or your specific instance name) as the Event source, enter 18456 in the Event IDs field, and click <strong>OK<\/strong>.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"555\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-serverinstance-under-filter-current-log-in-event-viewer.png\" alt=\"Selecting Server Instance under Filter Current Log in  Event Viewer window\" class=\"wp-image-199859 apply-gradient-on-post-images\" style=\"aspect-ratio:0.9819819819819819;width:545px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-serverinstance-under-filter-current-log-in-event-viewer.png 545w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-serverinstance-under-filter-current-log-in-event-viewer-295x300.png 295w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/figure><h2 class=\"wp-block-heading\" id=\"troubleshooting-sql-server-login-failed-error-18456\">Troubleshooting SQL Server Login Failed Error 18456<\/h2><p class=\"wp-block-paragraph\">You can follow the methods mentioned below to fix the authentication failure error 18456 in SQL Server.<\/p><h3 class=\"wp-block-heading\"><strong>Method 1- Enable SQL Server Logins<\/strong><\/h3><p class=\"wp-block-paragraph\">The error 18456 Login failed for user may occur when you try to log in with a SQL password, but the server is set to allow &ldquo;Windows Authentication Only.&rdquo; In this case, you can enable the SQL logins. To do this, you can either use an <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/connect\/odbc\/linux-mac\/using-integrated-authentication?view=sql-server-ver17\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Integrated Authentication<\/a> or follow the below steps:<\/p><ul class=\"wp-block-list\">\n<li>In <strong>SQL Server Management Studio<\/strong>, right-click on the <strong>SQL Server name<\/strong> in&nbsp;Object Explorer&nbsp;and select&nbsp;<strong>Properties.<\/strong><\/li>\n\n\n\n<li>Under <strong>Server Properties<\/strong> window, click <strong>Security<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"666\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-security-under-Server-Properties-window.png\" alt=\"Selecting Security under Server Properties window.\" class=\"wp-image-199860 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0348258706467661;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-security-under-Server-Properties-window.png 689w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-security-under-Server-Properties-window-300x290.png 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Select the&nbsp;<strong>SQL Server and Windows Authentication<\/strong>&nbsp;mode. Select&nbsp;<strong>OK.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"664\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-SQL-server-and-Windows-Authentication-mode.png\" alt=\"Selecting SQL Server and Windows-Authentication mode\" class=\"wp-image-199861 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0522765598650927;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-SQL-server-and-Windows-Authentication-mode.png 699w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-SQL-server-and-Windows-Authentication-mode-300x285.png 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Restart SQL Server services for the changes to take effect.<\/li>\n\n\n\n<li>Once you&rsquo;ve enabled SQL logins, you must also enable the login for System Administrator account (sa). In <strong>Object Explorer<\/strong>, expand <strong>Security &gt; Logins<\/strong>, right-click <strong>sa<\/strong>, and select <strong>Properties.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1260\" height=\"723\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/expand-Security-Logins-right-click-sa-and-select-properties.png\" alt=\"Expand Security  Logins right click sa and select Properties.\" class=\"wp-image-199863 apply-gradient-on-post-images\" style=\"aspect-ratio:1.7430167597765363;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/expand-Security-Logins-right-click-sa-and-select-properties.png 1260w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/expand-Security-Logins-right-click-sa-and-select-properties-300x172.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/expand-Security-Logins-right-click-sa-and-select-properties-767x440.png 767w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/expand-Security-Logins-right-click-sa-and-select-properties-1024x588.png 1024w\" sizes=\"auto, (max-width: 1260px) 100vw, 1260px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Under <strong>Select a page<\/strong>, click <strong>Status<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"657\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/Checking-status-under-select-a-page.png\" alt=\"Checking login status  under select a page section\" class=\"wp-image-199864 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0630323679727427;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/Checking-status-under-select-a-page.png 699w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/Checking-status-under-select-a-page-300x282.png 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>In Status window, under <strong>Settings<\/strong>, select <strong>Enabled<\/strong> for the Login option and click <strong>OK<\/strong> to save the applied changes.<\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"662\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/enabling-logins.png\" alt=\"Enabling SQL logins\" class=\"wp-image-199865 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0630323679727427;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/enabling-logins.png 704w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/enabling-logins-300x282.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>If the sa account still shows a red cross, right-click the account and select <strong>Refresh<\/strong> to update its status.<\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"691\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/refreshing-sql-logins.png\" alt=\"Refreshing SQL logins after modifications\" class=\"wp-image-199866 apply-gradient-on-post-images\" style=\"aspect-ratio:0.4905933429811867;width:339px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/refreshing-sql-logins.png 339w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/refreshing-sql-logins-147x300.png 147w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/figure><p class=\"wp-block-paragraph\">Once refreshed, the red icon will disappear, confirming the account is enabled.<\/p><p class=\"wp-block-paragraph\">If you still get the error, check your password again.<\/p><h3 class=\"wp-block-heading\"><strong>Method 2 &ndash; Check and Change the User&rsquo;s Default Database<\/strong><\/h3><p class=\"wp-block-paragraph\">You may encounter the login error 18456, when the SQL Server fails to connect to the default database. It occurs right after authentication, if the database is unavailable due to being dropped, renamed, or offline. You can check and reset the user&rsquo;s default database to master by using the following command:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER LOGIN [Your_Username_Here] WITH DEFAULT_DATABASE = [master]; GO<\/code><\/pre><p class=\"wp-block-paragraph\">Alternatively, you can change default database to master by following these steps:<\/p><ul class=\"wp-block-list\">\n<li>In SSMS, under <strong>Object Explorer<\/strong>, select <strong>Security &gt; New &gt; Login<\/strong>&hellip;<\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1007\" height=\"584\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/under-Object-Explorer-select-Security-New-Login.png\" alt=\"under Object Explorer select Security New Login\" class=\"wp-image-199867 apply-gradient-on-post-images\" style=\"aspect-ratio:1.723756906077348;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/under-Object-Explorer-select-Security-New-Login.png 1007w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/under-Object-Explorer-select-Security-New-Login-300x174.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/under-Object-Explorer-select-Security-New-Login-767x445.png 767w\" sizes=\"auto, (max-width: 1007px) 100vw, 1007px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>In the <strong>Login-New<\/strong> window, under the <strong>General<\/strong> section, change the default database to <strong>Master.<\/strong> Click <strong>OK.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"666\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/changing-default-sql-database-to-master.png\" alt=\"Changing Default SQL database to Master in SQL login-New page\" class=\"wp-image-199868 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0487394957983194;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/changing-default-sql-database-to-master.png 698w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/changing-default-sql-database-to-master-300x286.png 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure><p class=\"wp-block-paragraph\">This method of resetting the database to master only works if the application relies on the server&rsquo;s default settings. However, if the application is specifically looking for a missing explicitly specified database, this command will not fix the error. You can change the application&rsquo;s <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-the-user-connections-server-configuration-option?view=sql-server-ver17\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">connection settings<\/a> instead.<\/p><h3 class=\"wp-block-heading\"><strong>Method 3 &ndash; Verify Username and Password Credentials<\/strong><\/h3><p class=\"wp-block-paragraph\">The SQL Server Error 18456 &lsquo;Login failed for user&rsquo; can also occur if you provide an incorrect username or password, while using SQL Server Authentication. To confirm this, you can check the error log for the reason &ldquo;Password did not match that for the login provided.&rdquo;<\/p><p class=\"wp-block-paragraph\">To fix the issue, try to use the correct password in your application. In case you forgot the password, take the help of a SQL Admin or use Stellar Password Recovery for MS SQL to reset the System Administrator account (SA) and user passwords.<\/p><p class=\"wp-block-paragraph\">You can also verify the credentials outside the application by creating a UDL file. <a href=\"https:\/\/learn.microsoft.com\/en-us\/troubleshoot\/sql\/database-engine\/connect\/test-oledb-connectivity-use-udl-file\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">According to Microsoft document<\/a>ation, the UDL file helps to test the connection by using the SQL Server OLE DB Driver.<\/p><h3 class=\"wp-block-heading\"><strong>Method 4 &ndash; Check and Grant System Admin Permissions<\/strong><\/h3><p class=\"wp-block-paragraph\">You may encounter the error 18456 when you attempt to log into SQL Server using Windows Authentication through an AD group. This indicates that the server instance has rejected your connection request. This connection failure usually occurs if the AD group has not been added as a server login, if cross-domain trust restrictions prevent visibility, or if SQL Server fails to verify the group membership token. To resolve this, you can check the existing login configuration and grant the sysadmin server role directly to that specific Active Directory group. Here&rsquo;s how:<\/p><blockquote class=\"note_alert\">\n<p class=\"wp-block-paragraph\"><strong><em>Note:<\/em><\/strong> <em>Only the authorized admin like security admin can grant<\/em> <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/server-level-roles?view=sql-server-ver17\" id=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/server-level-roles?view=sql-server-ver17\"><em>server-level roles<\/em> <\/a><em>and permissions.<\/em><\/p>\n<\/blockquote><ul class=\"wp-block-list\">\n<li>Open your SQL Server Management Studio (SSMS), expand the <strong>Logins<\/strong> folder, right-click on NewSA, and select <strong>Properties.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"308\" height=\"685\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/right-click-on-NewSA-and-select-Properties-1.png\" alt=\"right-click on NewSA, and select Properties.\" class=\"wp-image-199869 apply-gradient-on-post-images\" style=\"aspect-ratio:0.44963503649635034;width:308px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/right-click-on-NewSA-and-select-Properties-1.png 308w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/right-click-on-NewSA-and-select-Properties-1-135x300.png 135w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Select the <strong>Server Roles<\/strong> and then check the option sysadmin. Click <strong>OK.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"661\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-sql-server-roles.png\" alt=\"Selecting SQL Server Roles\" class=\"wp-image-199870 apply-gradient-on-post-images\" style=\"aspect-ratio:1.0594227504244482;width:624px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-sql-server-roles.png 700w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/09\/selecting-sql-server-roles-300x283.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure><h2 class=\"wp-block-heading\" id=\"check-sql-server-database-for-corruption\"><strong>Check SQL Server Database for Corruption<\/strong><\/h2><p class=\"wp-block-paragraph\">It is good practice to check if all the databases are healthy. You can <a href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-repair-sql-database-using-dbcc-checkdb-command\/?srsltid=AfmBOoqPZOWHuUNLJJa_cNThPbmAOGfFyZS5pUoU8UKDqfGap8dNshH6\" target=\"_blank\" rel=\"noreferrer noopener\">use DBCC CHECKDB command to detect corruption<\/a>. This command displays the integrity issues and helps to resolve database corruption. However, it may cause data loss while repairing severely corrupt databases.<\/p><p class=\"wp-block-paragraph\">To prevent data loss, you can use <a href=\"https:\/\/www.stellarinfo.com\/database-recovery\/restore-sql-database\/buy-now.php\">Stellar Repair for MS SQL Technician.<\/a> It can repair corrupt SQL database including master .mdf files and restore the data, without requiring backup. It allows you to repair a SQL database when corruption is severe.<\/p><p class=\"wp-block-paragraph\">If you forgot the SA account credentials, then use the tool&rsquo;s utility &ndash; Stellar Password Recovery for MS SQL. It resets SA and user passwords, as well as the MDF file&rsquo;s password, ensuring you regain control of your SQL Server environment quickly and securely.<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2><p class=\"wp-block-paragraph\">The error 18456 &ldquo;Login failed for user&rdquo; in Microsoft SQL Server can occur due to various reasons, like incorrect credentials, incorrect server authentication mode, and others. It can lead to downtime if administrator credentials are lost or if database metadata corruption locks users out. You can follow the methods discussed above to check and resolve the error. If your SQL database is corrupted, then you can use Stellar Repair for MS SQL Technician.<\/p><h2 class=\"wp-block-heading\" id=\"faqs\"><strong>FAQs<\/strong><\/h2><p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may encounter the Microsoft SQL Server error 18456 Severity 14, State&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/\">Continue reading <span class=\"screen-reader-text\">How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?<\/span><\/a><\/p>\n","protected":false},"author":15,"featured_media":110239,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[6406,6400,6401,6405,6402,6403,6404,6407],"class_list":["post-107890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","tag-18456-login-failed-for-user","tag-18456-sql","tag-18456-sql-server-authentication","tag-login-failed-for-user-sql-server-windows-authentication","tag-microsoft-sql-18456","tag-sql-server-18456","tag-sql-server-18456-sql-authentication","tag-sql-server-database-error-18456","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Fix SQL Server Error 18456 State 38 (Login Failed)<\/title>\n<meta name=\"description\" content=\"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.\" \/>\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.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix SQL Server Error 18456 State 38 (Login Failed)\" \/>\n<meta property=\"og:description\" content=\"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-27T12:17:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-04T09:11:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Priyanka Chauhan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@priyanka66\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Chauhan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/\"},\"author\":{\"name\":\"Priyanka Chauhan\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/#\\\/schema\\\/person\\\/94fe9ee94eb813d94397deee2b641470\"},\"headline\":\"How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?\",\"datePublished\":\"2022-09-27T12:17:53+00:00\",\"dateModified\":\"2026-09-04T09:11:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/\"},\"wordCount\":1543,\"image\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/How-to-fix-SQL-Server-Database-Error-18456.jpg\",\"keywords\":[\"18456 login failed for user\",\"18456 sql\",\"18456 sql server authentication\",\"login failed for user sql server windows authentication\",\"microsoft sql 18456\",\"sql server 18456\",\"sql server 18456 sql authentication\",\"SQL Server Database Error 18456\"],\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/\",\"url\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/\",\"name\":\"How to Fix SQL Server Error 18456 State 38 (Login Failed)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/How-to-fix-SQL-Server-Database-Error-18456.jpg\",\"datePublished\":\"2022-09-27T12:17:53+00:00\",\"dateModified\":\"2026-09-04T09:11:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/#\\\/schema\\\/person\\\/94fe9ee94eb813d94397deee2b641470\"},\"description\":\"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/How-to-fix-SQL-Server-Database-Error-18456.jpg\",\"contentUrl\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/How-to-fix-SQL-Server-Database-Error-18456.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Sql database error 18456\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/how-to-fix-sql-server-database-error-18456\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/#\\\/schema\\\/person\\\/94fe9ee94eb813d94397deee2b641470\",\"name\":\"Priyanka Chauhan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"caption\":\"Priyanka Chauhan\"},\"description\":\"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyankachouhan\\\/\",\"https:\\\/\\\/x.com\\\/priyanka66\"],\"url\":\"https:\\\/\\\/www.stellarinfo.com\\\/blog\\\/author\\\/priyanka\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix SQL Server Error 18456 State 38 (Login Failed)","description":"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.","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.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix SQL Server Error 18456 State 38 (Login Failed)","og_description":"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.","og_url":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2022-09-27T12:17:53+00:00","article_modified_time":"2026-09-04T09:11:31+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg","type":"image\/jpeg"}],"author":"Priyanka Chauhan","twitter_card":"summary_large_image","twitter_creator":"@priyanka66","twitter_misc":{"Written by":"Priyanka Chauhan","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/"},"author":{"name":"Priyanka Chauhan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"headline":"How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?","datePublished":"2022-09-27T12:17:53+00:00","dateModified":"2026-09-04T09:11:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/"},"wordCount":1543,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg","keywords":["18456 login failed for user","18456 sql","18456 sql server authentication","login failed for user sql server windows authentication","microsoft sql 18456","sql server 18456","sql server 18456 sql authentication","SQL Server Database Error 18456"],"articleSection":["SQL Database Repair"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","url":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","name":"How to Fix SQL Server Error 18456 State 38 (Login Failed)","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg","datePublished":"2022-09-27T12:17:53+00:00","dateModified":"2026-09-04T09:11:31+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"description":"Fix SQL Server Error 18456, Severity 14, State 38, when login fails due to an unavailable default database. Check error states, authentication mode, credentials, and database access to restore login.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/08\/How-to-fix-SQL-Server-Database-Error-18456.jpg","width":1000,"height":600,"caption":"Sql database error 18456"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Fix SQL Server Database Error 18456:Cannot Open Database Requested by the Login?"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470","name":"Priyanka Chauhan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","caption":"Priyanka Chauhan"},"description":"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.","sameAs":["https:\/\/www.linkedin.com\/in\/priyankachouhan\/","https:\/\/x.com\/priyanka66"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/107890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=107890"}],"version-history":[{"count":11,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/107890\/revisions"}],"predecessor-version":[{"id":199876,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/107890\/revisions\/199876"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/110239"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=107890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=107890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=107890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}