MS SQL Server Installation and login Errors 18456, 233.

some common errors we will see here that is either in the installation part of sql server or login part.
The errors are related to either network or login or installation. This errors are logged in the below path.

Windows Installer log file: C:\Program Files\Microsoft SQL Server\110\Setup856Bootstrap\Log\-------.log

 

The following error has occurred:

SQL Server Setup has encountered an error when running a Windows Installer file.

Windows Installer error message: This update package could not be opened. Verify that the update package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer update package.

Windows Installer file: F:\x86\setup\sql_as.msi

Windows Installer log file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20140628_000832\sql_as_Cpu32_1.log

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

Login Error 18456:

 

The main cause of this error is due Authentication problem that is login failed for user, make sure that engine services are running in services.msc and next is check windows user account have proper rights to authenticate, then give correct login id (windows authentication mode) to solve the problem. If it is mixed mode authentication then provide login name with password.

error 233, error 40, error 2:

This errors are occurred when the services are not running and trying to authenticate the server or trying to login using another login id. so start the services by using services.msc in run command and make sure you are using the correct login id.