How to Solved Error: 18456, Severity: 14, State: 38.

If you have installed Windows SharePoint 3.0, “Error: 18456, Severity: 14, State: 38”, caused SQLSERVERAGENT does not start.

Set start mode for SQL Server Agent to automatic, fix this problem

I also encountered the Error 18456 Sev 14 State 16 on our MS Sql Server. At first i try to reset the password for my user but i have no success. But when I try again to look at the users properties having the error i found out that there is no default database assign for that user. I just assign a database and presto I can log on to my database.

My Slotuion:

1. Log on using sa account.

2. Expand secuirity and logins.

3. Right click on the user account with login problem problem and choose properties.

4. On properties genral tab, you will see an drop down option for default database used for the account, choose a database for the account to used and click ok or apply then ok.

5. Log off on sa account and try to log in again.

That solution works for me.


Read More: