SQL Server error 18456 - possible causes and solutions
The SQL error 18456 referred to an error when the user logs on. Specifically, the message relates to the user name. Why the error message appears, you may have different causes.
- So your user name or your password, for example, is invalid. Therefore, check whether a typographical error.
- The error will also appear if you used an existing Windows user name to SQL user name. Namely, this is not allowed and leads to an error message.
- It may also be that the account is disabled. In this case, you will not be able to login, of course.
- According to the password policy of the SQL server, Change the password required, this Change only make, again without this error message login to.
- A restore operation of the database, the error message also appears when trying to access the database. Here, you'll have to wait and try again later.
- It may also be that during the Installation of the database software is not the correct authentication option has been set. How to solve this Problem, we show in the next section.
SQL Server: error 18456 fix
SQL Server error 18456: authentications check
The default is for the Installation of the SQL Software only Windows authentication. You should therefore check whether, in addition, SQL allows the user, i.e., the so-called "Mixed Mode" is enabled.
- In order to verify this, start the utility program "Microsoft SQL Server Management Studio".
- You have been connected, click with the right mouse button on the server name at the top and select "properties" to open the dialog window "server properties".
- In the next step, click in the left bar, the point of "safety".
- Now you can see in the right window at the very top of the "server authentication". Select the Option "SQL Server and Windows authentication" and confirm your Change with "OK".
- In order for the Change to take effect, you must restart the SQL Server service.
Not quite as easy as under Windows, but still possible, is to Create the SQL databases on the Mac. How to do this, we will show you in the next tip.
