In message <B534AB41-EB50-4D9C-A036-2590FBE596D5@microsoft.com>, E.
Davids <anonymous@discussions.microsoft.com> writes
[quoted text, click to view] >Hi All,
>I have created an ASP script at my IIS server according the article at
>
http://www.sqldts.com/default.aspx?207. >I'm using a server Windowns 2003 (!) IIS 6.0, SQL Server 2000 Standard
>Edition.
>I have tried for two days now all kind of options but the DTS doesn't
>function properly. I'm 100% sure it's a Windows NT security issue,
>because I have created a SQL server account instead of Windows
>Authentication account and everythings runs fine.
>The things I have done is: (order of importance)
IWAM_MACHINE permission to SQL Server database (System administrator)
sqlservice account (that starts SQL Server service and Agent) permission
to SQL Server database (System administrator)
IUSR_MACHINE permission to SQL Server database (System administrator)
IIS 5.0 Isolation mode
The SQL Server Agent executes the DTS perfectly. The DTS run from a
client (IE) can be loaded. I'm seeing all tasks. Also the task that's
not approaching SQL Server runs fine, for instance the DTS Dynamic
Properties Task. It's just the moment that a task approaches SQL server
(same server as IIS).
I'm really stucked, if anyone could help me I'll really appreciate it!
Probably someone can tell me what the best way is to trace at the server
site.
Regards,
Esgar
What is the error?
Is the connection inside the package using trusted? Will this have
access to do the work?
There are two "connection" parts here. The first part is how to connect
to SQL to load the package, which you have solved. The second is any
packages inside of the package. They are different things but both need
to be considered.
--
Darren Green (SQL Server MVP)
DTS -
http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
