对数据库的计划任务权限 [英] Scheduled Task permission to for database

问题描述

在我的应用程序中，应用程序服务器和数据库服务器不同.

在数据库服务器上安装了MS-SQL Server2005.

在应用程序服务器上安排了一个程序(.exe)，该程序连接到数据库(在数据库服务器上)并在数据库上进行处理.

当数据库上的操作次数较少时，Pregram(.exe)成功运行.

但是当在数据库上处理大量操作时，应用程序给我以下错误消息:

[DBBETLIB] [ConnectiobOpen(Connect()).] SQL Server不存在或访问被拒绝.

当我在.exe上手动运行(双击)时，它可以成功运行，没有任何错误.
对于Schedular，它会产生上述错误.

在此先感谢

In my application, Application server and database server are different.

MS-SQL Server 2005 installed on Database server.

One program (.exe) scheduled on Application server which connect to database (which is on database server) and process on it.

Pregram (.exe) run successfully when number of operation on database is less.

But when huge number of operation processed on database, application gives me below error msg:

[DBBETLIB][ConnectiobOpen (Connect()).] SQL Server does not exist or access denied.

When I Run manually (double click) on .exe it''s work successfully without any error.
For Schedular it gives above error.

Thanks in advance

推荐答案

我认为它是时间表中的访问权限问题.正如Mika所说，请检查时间表的凭据.

I think it''s window schedular''s access permission issue. As Mika said, Check for the schedulars credential. it may have less access.

如果您使用的是集成安全性，则应在对数据库具有访问权限的凭据(例如您的凭据)下运行计划的任务.如果使用Windows计划，则可以修改任务的凭据.另一种选择是使用SQL Server用户/密码组合.

If you''re using integrated security, you should run the scheduled task under credentials that have access to the database (such as your credentials). If you use windows scheduling, you can modify the credentials for the task. Another option would be to use SQL Server user/password combination.

感谢回复.


存在访问权限问题..

我更改了计划的凭证.
将运行方式"设置为:"DOMAIN \ ADMINISTRATOR"及其"PASSWORD"(域\管理员密码)

谢谢

thanks for reply.


there is access permission issue..

i changed schedular credential.
Set Run as: "DOMAIN\ADMINISTRATOR" and its "PASSWORD" (Domain\Administrator Pwd)

Thanks

这篇关于对数据库的计划任务权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！