在以下情况下尝试批量插入sql时遇到问题:
>在Workstation A上运行管理工作室
>在服务器B上运行的sql
>从位于服务器C上的批量上载文件
- Cannot bulk load because the file <filename> could not be opened. Operating system error code 5(Access is denied.).
现在我知道我们在这里有一个双跃点问题,需要整理委托.已经为sql设置了SPN,如下所示(sql在不同的端口上运行). sql作为域用户运行,SPN在该帐户上.
我还设置了从sql用户帐户到Cifs和HOST的文件服务器的委托,但无济于事.
我已启用Kerberos日志记录,并在事件查看器中看到以下事件:
- A Kerberos Error Message was received:
- on logon session
- Client Time:
- Server Time: 14:44:10.0000 8/9/2011 Z
- Error Code: 0xe KDC_ERR_ETYPE_NOTSUPP
- Extended Error:
- Client Realm:
- Client Name:
- Server Realm: domain.LOCAL
- Server Name: krbtgt/domain.LOCAL
- Target Name: krbtgt/domain.LOCAL@domain.LOCAL
- Error Text:
- File: 9
- Line: efb
- Error Data is in record data.
那么,对于我在这里缺少什么的想法?我之前有过这种委托,但是在默认端口上一直使用sql,这会产生什么影响?
编辑
- A Kerberos Error Message was received:
- on logon session
- Client Time:
- Server Time: 15:4:10.0000 8/9/2011 Z
- Error Code: 0xe KDC_ERR_ETYPE_NOTSUPP
- Extended Error:
- Client Realm:
- Client Name:
- Server Realm: domain.LOCAL
- Server Name: krbtgt/domain.LOCAL
- Target Name: krbtgt/domain.LOCAL@domain.LOCAL
- Error Text:
- File: 9
- Line: efb
- Error Data is in record data.