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.
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.
- How to Solve SQL state [HY000]: general error 2503
- Springboot error: “errorcode 1045, state 28000” [How to Solve]
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- Hive install initialization error: Error: Duplicate key name ‘PCS_STATS_IDX‘ (state=42000,code=1061)
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- How To Change ASM SYS PASSWORD
- How to Solve Nacos startup error
- How to Solve Mysql8 load data error
- How to Fix MySQL error 1005: can’t create table (errno: 150)
- How to Solve Azkaban startup error
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- How to Solve mysql [Err] 1067-Invalid default value for
- How to Solve c3p0 connect mysql8.0 Error
- How to Solve “Out of range value for column” Error
- How to Solve MYSQL into outfile Error13
- Mongoose: How to delete all documents in collection
- How to Solve Error: Rsa Public Key not Find
- [Mybatis] How to Solve the problem of Oracle query processing more than 1000 in conditions
- How to Check the most CPU consuming 50 queries in MYSQL