In main lines, SQL Server is a relational database management system of Microsoft specifically designed for the enterprise surroundings. The last version of the system was sent year 2016 the past. The main newness of the new version with respect to its predecessors is the processing in real time. This way, the users can realise operative analyses in real time and execute of fast and simple way their analytical processes. In addition, he allows to detect any type them of failure of security in real time without the yield is affected in minimum.
The SQL Server 18456 can be due to an ample fan of reasons. The name of the servant who has introduced the user is correct, but the connection with SQL Server cannot be established.
One of the main reasons that they give rise to the error of servant 18456 is that the authentication of mixed way is qualified; that is to say, that the user is trying to initiate session with the authentication of Windows. Before this error, the user must initiate session with his YOU GO and SQL password. Once he has acceded to the system, he must accede to Security and verify that its account of Directory Assets of Windows ties with its home of session SQL.
The message of error 18456 does not provide too much information on the cause by which session cannot be initiated. The main reason is the security.
In order to increase the security, in the error message that is to them the users is the origin of the same. The states and the descriptions are the following in SQL Server.