SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Applications cannot login to moved db with Error: 18456 Severity: 14 State: 38 after AG failover
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andrea Floriddia
20
Reputation points
IaaS SQL Server on 2-node cluster with Always On
Manual AG failover was successfull but applications can no longer connect. SQLServer logs report "Error: 18456 Severity: 14 State: 38" and
"Login failed for user 'app_rh_sso'. Reason: Failed to open the explicitly specified database 'RH_SSO'"
Failing back the AG the application reconnect successfully
What could be the causes? I discovered that the login on the other node has a different SID compared to the database user. Could this be the reason?
SQL Server | Other
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more