DTS and permissions

Under what account does a DTS package or SQL Agent job run under?
Is it the Service Startup Account for SQL Agent?
A DTS package under a scheduled job needs to access a network share and I
need to know which account I should give share access permissions to.
Thanks
Yes...the service account for SQL Agent.
-Sue
On Tue, 1 Mar 2005 14:40:25 -0800, "Dave" <dave@.nospam.ru>
wrote:

>Under what account does a DTS package or SQL Agent job run under?
>Is it the Service Startup Account for SQL Agent?
>A DTS package under a scheduled job needs to access a network share and I
>need to know which account I should give share access permissions to.
>Thanks
>

DTS and permissions

Under what account does a DTS package or SQL Agent job run under?
Is it the Service Startup Account for SQL Agent?
A DTS package under a scheduled job needs to access a network share and I
need to know which account I should give share access permissions to.
ThanksYes...the service account for SQL Agent.
-Sue
On Tue, 1 Mar 2005 14:40:25 -0800, "Dave" <dave@.nospam.ru>
wrote:
>Under what account does a DTS package or SQL Agent job run under?
>Is it the Service Startup Account for SQL Agent?
>A DTS package under a scheduled job needs to access a network share and I
>need to know which account I should give share access permissions to.
>Thanks
>

DTS and permissions

Under what account does a DTS package or SQL Agent job run under?
Is it the Service Startup Account for SQL Agent?
A DTS package under a scheduled job needs to access a network share and I
need to know which account I should give share access permissions to.
ThanksYes...the service account for SQL Agent.
-Sue
On Tue, 1 Mar 2005 14:40:25 -0800, "Dave" <dave@.nospam.ru>
wrote:

>Under what account does a DTS package or SQL Agent job run under?
>Is it the Service Startup Account for SQL Agent?
>A DTS package under a scheduled job needs to access a network share and I
>need to know which account I should give share access permissions to.
>Thanks
>

DTS and permissions

I'm developing a DTS package which will be scheduled and will write files out to a LAN share. When I execute the package manually from enterprise manager it works just fine. But when scheduled..fails with a access denied. Can someone point me towards the area I need to fix this? I'm running the SQL server under the System account.

Thanks,
EYeah...when you run the DTS package from your client, it runs under the context of your id (not to mention the mapped paths that you have).

When it's scheduled it runs under the context of the sql server service account (not to mention it's mapped drives)

Drove me NIUTS when I installed 7

What Id di was to map one of my drive to look exactly as the servers D:\ Drive

That way If I ran it or scheduled a package it would run fine...

If your problem is that you're trying t write from the server to another server, you'll need permissions for the sql server service account to that other server...

Why not write it out to the server itself if that's the case...

Good Luck|||Hi, lil_elvis2000

You should configure a domain user account to run SQL Server Service and SQL Server Agent Service.
You also have to grant write permission to that account on the lan share.

Regards,

Originally posted by lil_elvis2000
I'm developing a DTS package which will be scheduled and will write files out to a LAN share. When I execute the package manually from enterprise manager it works just fine. But when scheduled..fails with a access denied. Can someone point me towards the area I need to fix this? I'm running the SQL server under the System account.

Thanks,
E

dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possible.
When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.

dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possible.When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.

dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possibl
e.When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.