SQL Server 2005突然不能启动了。察看了一下Event Viewer, log 是这样的。
The SQL Server (MSSQLSERVER) service failed to start due to the following error:
The service did not start due to a logon failure.
The MSSQLSERVER service was unable to log on as INTL\yvli with the currently configured password due to the following error:
Logon failure: unknown user name or bad password.
由于我们的域账号是3个月一次update的，所以当密码登陆不成功，但是很奇怪的是SSIS的Service还是好好的，原来SSIS的账号是用Network Service登陆的。所以，就全都改成使用Built in logon的 Network Service登陆。全部okay.
还有一个小插曲，Via 协议enable以后，果然不能start Server。
今天很忙，先记录在这里，有时间看看为什么。：）
No comments:
Post a Comment