![sql error 18456 state 1 sql error 18456 state 1](https://i2.wp.com/blog.sqlauthority.com/wp-content/uploads/2015/08/erroricon.png)
![sql error 18456 state 1 sql error 18456 state 1](https://i0.wp.com/supertechman.com.au/wp-content/uploads/2020/04/SQL-Server-Error-18456-4.png)
However when I tried to connect to the SQL instance using SQL Server Management Studio, I received the following error: Cannot connect to .net. on Specify all articles when subscribing to a publication using concurrent snapshot processing. I tested I had basic connectivity with the SQL instance using a ping command. The key to the message is the ‘State’ which the server will accurately set to reflect the source of the problem. khalil on SQL Server Merge Replication Best Practices Replication Error: Specify all articles when subscribing to a publication using concurrent snapshot processing Playing with database servers. Error: 18456, Severity: 14, State: 2 State 2 in SQL Server Error 18456 login failed for user occurs when the user is trying to logged in by wrong login, or you have created a server-level login in which you logged in by wrong username. Date/Time spid7s Skipping the default startup of database DatabaseName because the database belongs to an availability group (Group ID: GroupID ). 00:02:00.34 Logon Login failed for user ''. SQL Server error 18456, State 1 occurs when login is disabled and user is not able to login to the SQL Server. Date/Time spid7s Error: 35262, Severity: 17, State: 1. To determine the true reason for the failure, check the server’s error log where a related entry will be written. The ‘State’ will always be shown to be ’1′ to the client regardless of the nature of the problem – this is to prevent disclosing sensative information to unauthorised clients. Msg 18456, Level 14, State 1, Server, Line 1 If the server encounters an error that prevents a login from succeeding, the client will display the following error message: