2008. 11. 3. 17:36
로그인 오류의 경우 상태에 따라 여러가지 원인이 있다.
SQL의 로그파일에 상태코드가 기록되니 참고하여 문제를 돌파하자.
로그파일경로 : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
State: 16. : indicates that the session database could not be determined which maymean that the database is offline or the user does not have permissionsto access the database
출처 : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/747f01b4-288d-49ae-ab85-0fdf34ea2bfa/
SQL의 로그파일에 상태코드가 기록되니 참고하여 문제를 돌파하자.
로그파일경로 : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
ERROR DESCRIPTION | |
2 and 5 | Invalid userid |
6 | Attempt to use a Windows login name with SQL Authentication |
7 | Login disabled and password mismatch |
8 | Password mismatch |
9 | Invalid password |
11 and 12 | Valid login but server access failure |
13 | SQL Server service paused |
18 | Change password required |
State: 16. : indicates that the session database could not be determined which maymean that the database is offline or the user does not have permissionsto access the database
출처 : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/747f01b4-288d-49ae-ab85-0fdf34ea2bfa/