informatica连接sqlserver2012的问题

[clxxxdragon]

这两天info抽取数据的时候其中一个表的抽取总是报错，之前没有遇到过，而且报错之后我重新调度有可以成功了，如果有明白的大侠请指导一下小弟，谢谢了
Severity: ERROR
Timestamp: 2012/6/21 0:55:39
Node: node01_DMTM
Thread: READER_1_1_1
Process ID: 10604
Message Code: RR_4036
Message: Error connecting to database [
Microsoft OLE DB Provider for SQL Server: Login failed for user 'user' because the account is currently locked out. The system administrator can unlock it.
SQL State: 42000 Native Error: 18486
State: 1 Severity: 14
SQL Server Message: Login failed for user 'user' because the account is currently locked out. The system administrator can unlock it.


Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [readuser3] and connection string [].

[infatech]

引用 楼主 clxxxdragon 的回复:

这两天info抽取数据的时候其中一个表的抽取总是报错，之前没有遇到过，而且报错之后我重新调度有可以成功了，如果有明白的大侠请指导一下小弟，谢谢了 Severity: ERROR Timestamp: 2012/6/21 0:55:39 Node: node01_DMTM Thread: READER_1_1_1 Process ID: 10604 Message Code: RR_4036 Message: Error connecting to database [ Microsoft OLE DB Provider for SQL Server: Login failed for user 'user' because the account is currently locked out. The system administrator can unlock it. SQL State: 42000 Native Error: 18486 State: 1 Severity: 14 SQL Server Message: Login failed for user 'user' because the account is currently locked out. The system administrator can unlock it. Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [readuser3] and connection string [].

从你贴的报错信息来看是SQL Server的用户的问题。

[灯惉]

数据源没有配置正确，所以报Database driver error... Function Name : Connect 再检查一下数据源是否配置正确，主要是数据库驱动的安装选择上其次就是数据库用户名和密码

[clxxxdragon]

引用 2 楼 x_pohai2010 的回复:

数据源没有配置正确，所以报Database driver error... Function Name : Connect 再检查一下数据源是否配置正确，主要是数据库驱动的安装选择上其次就是数据库用户名和密码

这个确定都没有问题，因为之前已经跑很久了，就今天突然报这个错了

[graysun]

Login failed for user 'user' because the account is currently locked out. The system administrator can unlock it. 看起来是账户被锁定了