Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svibuk
Yak Posting Veteran
62 Posts |
 Posted - 2012-11-21 : 12:15:38
|
| microsoft sql server error 18456 in sql server 2008 r2login failed for user sasql server was working properlyi just restarted the system and then i started getting the above errorhow do i resolve iti am able to login with windows authentication but not sql authentication |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-11-21 : 23:08:46
|
| I found a good Microsoft article on this error, Please read it:http://msdn.microsoft.com/en-us/library/cc645917.aspx |
 |
|
|
HenrikMezei
Starting Member
1 Post |
Posted - 2014-12-03 : 07:26:00
|
| Read something useful om this site unspammed |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-12-05 : 06:34:20
|
| Since you just said you restarted the system. Can it be possible somebody changes authentication mode to windows Only. Please checkHope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
microsoft sql server error 18456 in sql server 200