Section 2: Fix SQL Server Login Failed Error Is in suspect mode, or is in single user mode but the only available connection is already being used by someone else or by something else. Has been set to the RESTRICTED_USER state or is set to emergency status.
No longer exists, offline or has been detached. Instead, you receive error 4062/4064 message.ĭefault database becomes unavailable probably because the database: However, if it is unavailable when connected, you may not be able to connect.
And it is used automatically when you connect to computer that is running Microsoft SQL Server, and you do not specify a login database. While you receive SQL Server failed login error 4062/4064, you should look for reason why cannot open default database.Īs is known, each user has a default database. Refer to common error states and their descriptions in following table, you would find the real reason for failed logining SQL Server. View the entry and just need to pay attention to the " State", which the server will accurately set to reflect the source of the problem. To determine the true reason for the SQL Server login failure, the administrator can look in server's error log where a corresponding entry will be written. We should know that the ' State' will always be shown to be ' 1' regardless of the nature of the problem.
Msg 18456, Level 14, State 1, Server, Line 1 While you receive error 18456/18452 message, please check error state in SQL Server error log. Section 1: Check the Error State or Find Reason to This Error
I have read numerous articles on how to resolve Error 18456: none of them reference State 38, and none of them refer to Reporting Services.How to Fix Login Failed to SQL Server - Error 18456/18452/4064/4062Īfter you install Microsoft SQL Server 2016/2014/2012/2008/2005/2000, and you try to connect to server that is running SQL Server, probably you receive one of following error messages. Reporting Services Version: Microsoft SQL Server Reporting Services Version 14.0.600.1453
169 (X64) 17:04:49 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 SQL Server Version: Microsoft SQL Server 2017 (RTM). I assure you, the database, "ReportServer" is there! Error 18456, State 38 translates to "Could not find the database requested". The error only began after I installed Reporting Services. I do not get a similar error from 'DOM\NODE2$'. I cannot tell where this error is coming from, and why it is only generated from NODE1. Regardless of which host is currently functioning as the active server, I get the following error messages in my SQL Server error log: My Failover cluster has two hosts, NODE1 and NODE2. SQL Server and Reporting Services are working fine from a user's perspective. Both are working fine with no known issues. I recently installed SQL Server 2017 in a Failover Cluster and also installed SSRS 2017.