MS SQL 2005 Express で 'エラー: 18456、重大度: 14、状態: 16'が発生してユーザログインが失敗してしまう

[ハンセン]

$B$*@$OC$K$J$C$F$*$j$^$9!#$I$J$?$+!"3:Ev$N;v>]$KBP$7$F!"8f7P83$b$7$/$O2?$+$*J,$+$j$K$J$j$^$7$?$i2sHr:vEy$N8f65<x$r8f4j$$CW$7$^$9!#(B

[$B4D6-(B]
OS:Windows2003 SP2
SQL Server 2005 Enterprise Edition SP2

[$B%"%W%j%1!<%7%g%s!&%G!<%?%Y!<%94D6-(B]
$B#1!%(BJDBC$B$K$F(BSQL Server$B@\B3$r9T$o$;$k%"%W%j%1!<%7%g%s$,(BWindow$B%5!<%S%9$G5/F0$7$^$9!#(B
$B#2!%(BDB$B$K$O(BSQL$BG'>Z$rMxMQ$7$F@\B3$G$-$k$h$&$K$7$F$*$j!"(BDB$B$K%"%/%;%9$9$k(B
$B!!!!%f!<%6$K$O!"2<5-$N$h$&$J%m!<%k8"8B$r%^%C%W$5$;$?%f!<%6$,Dj5A$5$l$F$$$^$9(B

$B!!!!(B- db_buckupoperator
- db_datareader
- db_datawriter
- db_ddladmin

[$BLdBj;v>](B]
$B#1!%>e5-@_Dj$K$F%"%W%j%1!<%7%g%s$O(BMS SQL $B$***@5>o$K@\B3$G$-$k>uBV$K$J$C$F$*$j$^$9!#(B
$B#2!%<!$K%"%W%j%1!<%7%g%s$N%5!<%S%9:F5/F0$r<B;\$7$^$9!#(B
$B$9$k$H0J2<$N%a%C%;!<%8$,(BSQL Server$B$N(BERROR.LOG$B$K=PNO$5$l!"(B

--ERROR$B%a%C%;!<%8(B--
$B%(%i!<(B: 18456$B!"=EBgEY(B: 14$B!">uBV(B: 16$B!#(B
Login failed for user 'XXXXXX($B%f!<%6L>(B)'. [$B%/%i%$%"%s%H(B: <$B%[%9%H(BIP$B%"%I%l%9(B>]
--

$B$^$?(BWindows$B%[%9%H$N%"%W%j%1!<%7%g%s!&%$%Y%s%H%m%0$K$b0J2<$N%a%C%;!<%8$,(B
$B=PNO$5$l!"(B

--
MSSQLSERVER $B<:GT$N4F::(B (4) 18456 N/A <$B%[%9%HL>(B> $B%f!<%6!<(B 'XXXXXX' $B$O%m%0%$%s$G$-$^$;$s$G$7$?!#(B [$B%/%i(B
$B%$%"%s%H(B: <$B%[%9%H(BIP$B%"%I%l%9(B>]
--

$B7k2LE*$K%"%W%j%1!<%7%g%s$+$i$N@\B3$,A4$/$G$-$J$$;v>]$,H/@8$7$^$9!#(B

$B#3!%$H$3$m$,!"(BManagement Studio$B$K$F>e5-@_Dj:Q$_$N%f!<%6Dj5A$r0lC6:o=|$7!":FDj5A$r9T$J$&$H$^$?%"%W%j%1!<%7%g%s$+$i$N@\B3$,@5>o(B
$B$K9T$o$l$k$h$&$K$J$j$^$9!#(B

$B"(F1MM$J;v>]$,0J2<$N(BURL$B$K$F$b>R2p$5$l$F$$$^$9!#(B
http://slashdot.jp/~noritama2/journal/392321

$BK\;v>]$O!"(BSQL Server 2005 Standard Edition SP2$B4D6-$G$O:F8=$7$F$*$j$^$;$s!#(B
$B%"%W%j%1!<%7%g%s$N:F5/F0$K$h$j!"$3$N;v>]$,H/@8$7$F$7$^$$!"%f!<%6$N:FDj5A$r(B
$B9T$J$o$J$$8B$j!"@\B3$,9T$($J$/$J$k$H$$$&IT2D2r$J;v>]$H$J$C$F$*$j!":$$C$F$*$j$^$9!#(B

$B$I$&$>59$7$/8f4j$$$7$^$9!#(B

[ハンセン]

$BK\7o!"(BSQL Server$B$N%m%0Ey$rD4::$7$?$H$3$m!"<+8J2r7h$G$-$^$7$?!#(B $B$=$N8e!"%f!<%6$N:FDj5A$r$7$?$b$N$N@\B3$,$G$-$J$/$J$k798~$,;G$($?$3$H(B
$B$+$i!"@\B3$9$k%m%0%$%s!J%f!<%6!K$K%m!<%k$,3d$jEv$F$i$l$F$$$J$$$H$$$&LdBj$G$O$"$j$^$;$s$G$7$?!#$I$&$b%"%W%j$N:F5/F0!J:F@\B3!K$9$k%?%$%_%s%0$K$F(B
$***@5>o$K9T$J$o$l$?$j!"$7$J$+$C$?$j$H$$$&798~$+$i!"(BTCP/IP$B@\B3$N>uBV$NLdBj$+$H;W$$%m%0$ND4::$r?J$a!"0J2<$NLdBj$G$"$C$?$3$H$,J,$+$j$^$7$?!#(B

[$BLdBj$N860x(B]
$B!&(BSQL Server$B$,J#?t$N%M%C%H%o!<%/%$%s%?!<%U%'%$%9%+!<%I$rEk:\$7!"$=$l$>$l$N(BNIC$B>e$K$F0[$J$k(BIP$B%"%I%l%9$,%"%/%F%#%V$K$J$C$F$$$k!#(B
$B!&(BSQL Server$B$,J#?t$N(BIP$B%"%I%l%9$K$F!"(BTCP/IP$B@\B3$r%j%9%s$9$k$h$&$***@_Dj$5$l$F$$$k!#(B

[$B2sHrJ}K!(B]
SQL Server$B$N9=@.%^%M!<%8%c$h$j!"0J2<$***@_Dj$r9T$J$&$3$H$G!"@\B3$K;HMQ$9$k(BIP$B%"%I%l%9>e$N$_$G(BTCP/IP$B@\B3$r%j%9%s$G$-$k$h$&$K$J$j(B
$B$^$9!#(B

1.TCP/IP$B%W%m%Q%F%#@_Dj$N!"%W%m%H%3%k%?%V$K$F(B[$B$9$Y$F<u?.BT$A(B]$B$r!V$$$$$(!W$K;XDj!#(B
2.IP$B%"%I%l%9%?%V$K$F!"%"%W%j%1!<%7%g%s$+$i$N@\B3$K;HMQ$9$k(BIP$B%"%I%l%9$N(B[$BM-8z(B]$B$r!V$O$$!W$K;XDj!#(B
$B!!!J$=$NB>$N(BIP$B%"%I%l%9$O(B[$BM-8z(B]$B$r!V$$$$$(!W$***@_Dj!#!K(B
3.$B>e5-@_Dj8e!"(BMSSQL Server$B%5!<%S%9$r:F5/F0!#(B

$B$4;29M$K$J$l$P$H!#(B