ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Error: 18456 Severity: 14 State: 38

Error: 18456 Severity: 14 State: 38

原创 Linux操作系统 作者:davissun 时间:2009-09-18 17:33:43 0 删除 编辑

"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.


 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13158758/viewspace-615019/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle 9i
请登录后发表评论 登录
全部评论

注册时间:2009-04-27

  • 博文量
    17
  • 访问量
    7397