SQL身份validation不在MS SQL Server 2008中进行身份validation
当我尝试使用SQL Server Management Studio中的Windows身份validation连接到在本地主机上运行的SQL Server时,我能够连接,但是当我尝试使用SQL身份validation进行连接时,它表示login失败,即使我知道具有密码的用户在DB上。 这里是错误日志 – =================================== Cannot connect to localhost. =================================== Login failed for user 'admin'. (.Net SqlClient Data Provider) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 —————————— Server Name: localhost Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 —————————— Program Location: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, […]