Re: SQL & NT Security

From: Bala Neerumalla[MSFT] (balnee@online.microsoft.com)
Date: 03/15/03 

From: "Bala Neerumalla[MSFT]" <balnee@online.microsoft.com>
Date: Fri, 14 Mar 2003 21:48:12 -0800

What is the error message that you receive??? That might help to find out
the issue.

- Bala.
"Mr McGoo" <DesparateGuy@hotmail.com> wrote in message
news:037801c2df44$d87e9620$3301280a@phx.gbl...
> I have a DTS package that works fine when executed locally.
>
> However, the package fails when executed via ASP.
>
> The package fails at an Active-X script task.
> The script does the following:
>
> It accesses a flat file on a network shared folder with
> full permissions. It uses the FileSystem Object to get the
> file last modified date and appends it to the file name
> after the data is imported.
>
> I believe the problem is security related.
>
> I am running Windows NT Workstation with Service Pack 6a,
> IIS Server 4.0 with updated patches, SQL Server Evaluation
> Edition with security patches.
>
> Sql Server is using Windows Authenication
> IIS is set up to use windows challenge/response, anonymous
> login has been disabled.
>
> A Domain group role has been created on Sql Server with
> appropriate permissions.
>
> Is there a specific admin role or permission that I am
> unware of?
>
> Any help will be greatly appreciated!
>
> TIA

Relevant Pages

  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • RE: Could not open global shared memory to communicate w/ performa
    ... If look at my post titled Permissions Problem and dated 12/13/2008, ... db_ssisoperator and I granted db_ssisoperator the Reader Role via the Package ... On the SQL Server box, open Programs, SQL Server 2008, COnfiguration Tools, ... I am logged in as domain administrator yet still have ...
    (microsoft.public.sqlserver.dts)
  • Re: OT: Old Mozilla to new Thunderbird, how to get emails over?
    ... ownership is a little difficult for someone that uses Windows. ... than permissions alone (even a malicious kernel module can't write to ... E.g. if you upgrade a package, ... software shouldn't rely upon users modifying the ...
    (sci.electronics.design)
  • Re: Setting perm. on stored procedures using windows auth.
    ... windows account and are in the local windows administrators group, ... I support the Professional Association of SQL Server and it community ... I added that 1 user to a database role and I set execute ... > permissions for some stored procedures in my database. ...
    (microsoft.public.sqlserver.security)
  • Re: Security
    ... In the main package properties, you can enable package level logging. ... The connection within the package uses a SQL login for the SQL server it connects to, so even though it is executing using the agent, so using the agents permissions, i presumed that the actual connection will be made using the defined login. ...
    (microsoft.public.sqlserver.server)