RE: DTS is blocked by XP

From: Just in time (time_at_discussions.microsoft.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 14:21:03 -0800

When usung XP (extended procedures), the login you use to access the SQL
server instance will require permissions within to run extended procedures.
Look for setting permissiones in SQL. To test this out, try running the
command by connecting to SQL instance with Admin rights (sa, blan) or provide
the login that will execute the command admin rights. From there, you can
play with the Security settings for setting up a DB user and providing the
necessary rights you want that user to have. Normally, it is best to setup a
DB System User and use that user to running extended procedures through a job
or DTS once you get things setup the way you need.

"Douglas M" wrote:

> I have a DTS package that I have had to manually run because it got blocked
> by XP Security.
> Now XP is even blocking the copyfile command step when I manually run it.
>
> How do I turn off the XP Security or how do I change the scripts to run.
>
> thanks.
>
>
>

Relevant Pages

  • Re: Is there any REGEXP library for TSQL?
    ... >> But performance would be awful and the code would be messy. ... > I've never written any extended procedures, ... I'm guessing the main reason is that in SQL 2000, ... SQL 2005 CLR code executes within the same memory space ...
    (comp.databases.ms-sqlserver)
  • Re: replication between 64bit and 32bit
    ... In SQL 2008 there isn't really transformable subscriptions so this isn't an ... the 64-bit and 32-bit environments. ... A backup created on a server instance running ...
    (microsoft.public.sqlserver.replication)
  • RE: How to Determine if a user is a member of the System Admin role?
    ... check if it is of sysadmin role, ... check if it's a server loginon that server instance. ... It'll be a bit different for SQL 2005 and SQL 2000: ... we need to query multiple catalog views in sys schema. ...
    (microsoft.public.sqlserver.security)
  • Re: Another Sql Server 7 Buffer Overflow
    ... A number of people have sent messages regarding Cesar's advisory about ... SQL 7 and the xp_dirtree extended procedure overflow. ... MSKB q280380 they provide a list of the extended procedures that used ...
    (NT-Bugtraq)
  • Sql virtual name and instance name
    ... My understanding of sql2k is as such: You can install only 1 sql ... server instance per virtual server. ... connecting to the instance on the virtual server why do you need to ...
    (microsoft.public.sqlserver.clustering)