sqlserver 2008 login failed: error 18456
在嘗試用sql server authentication登入的時候發生18456號錯誤。開始以為是自己建的使用者的密碼短了或者不符合要求,於是把密碼修改複雜,再試,還是不行。
後來把authentification 修改為mixed模式,登入成功。
修改方法:
用其它帳號登入Microsoft SQL Server Management Studio,在Object Explorer中右擊database instance->properties->security->Server authentication,選中SqlServer and Windows Authentication mode.
參考:http://msdn.microsoft.com/en-us/library/cc645917(classic).aspx
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16436858/viewspace-617128/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- SqlServer2008R2用Windows身份登入18456錯誤解決SQLServerWindows
- FAILED_LOGIN_ATTEMPTSAI
- Oracle FAILED_LOGIN_ATTEMPTS 理解OracleAI
- SEC_MAX_FAILED_LOGIN_ATTEMPTS 用途AI
- 【ERROR】OPatch failed with error code 73ErrorAI
- listDatabases failed:{ "errmsg" : "need to login", "ok" : 0 }DatabaseAI
- About login/failed_user_auto_unlock work or notAI
- [ERROR] Failed to open logErrorAI
- OPatch failed with error code 73AIError
- SQLServer 2008 恢復SQLServer
- SQLServer 2008 備份SQLServer
- Error: User gpmon is not allowed to login Command CenterError
- Error: failed PB timebomb checkErrorAI
- Error: User gpmon is not allowed to login Command Center.Error
- aix login shell permission error trouble shooting.AIError
- SQLServer2008概述(一)SQLServer
- maridb Error 'Operation DROP USER failed forErrorAI
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError
- SQLServer映象報錯Connection handshake failedSQLServerAI
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- Android 3.0 DELETE_FAILED_INTERNAL_ERRORAndroiddeleteAIError
- SQLserver2008批次替換字串SQLServer字串
- SQLServer2008 除錯問題SQLServer除錯
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- ERROR: Failed to resolve: org.greenrobot:eventbus:2.4.0ErrorAI
- weblogic報錯: OPatch failed with error code 73WebAIError
- OPatch failed with error code 73(OracleHomeInventory gets null oracleHomeInfo)AIErrorOracleNull
- "OPatch failed with error code 73"故障一例AIError
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- Failed to run 'create login' or 'sp_addsrvrolemeber' in sql Linux using windows authentcationAIVRSQLLinuxWindows
- Sqlserver作業系統使用者Administrator本地登陸SSMS報錯18456的解決方法SQLServer作業系統SSM
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- 解決 yum clean all Error rpmdb open failedErrorAI
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- OPatch failed with error code 73 (These not-installed components)AIError
- oem12c opatchauto failed with error code 135AIError
- Connection to x as user y failed: ERROR: Wrong password for userAIError