I have a 18456 error (severity 14) with a state of 38 when trying to install CA Unicenter ServiceDesk application on my computer with SQl Server 2008 Express installed.
The user seems to be granted all required permissions, but the application shows the specified error and installation finishes.
So, the application tries to login to server and create a new database on it.
As far as I know. the 38 state means "Login successful, but database unavailable (or login not permissioned" .
View Complete Post