Security Level on SQL -- sql server dts

rwiethorn2002 NO[at]SPAM yahoo.com
8/21/2003 11:17:56 AM

I created a VB.Net appliction that creates and executes a couple of
DTS packages. I use trusted connection in my connection objects.

I then deployed these applictions to a user's machine.

I had to create a login on the SQL server and promote them the the
Serve Administrator role so they could run the package from their
machine.

I would like to know if anybody knows what the minimum settign I can
use but still allow them to run the packages?

Or maybe change the connection properties?

Thanks,

rwiethorn2002 NO[at]SPAM yahoo.com
8/21/2003 2:36:57 PM

In order for the user to use the appliction, I had to create a Login
and Give them SYSTEM ADMIN Server Roles.

I would rather not do that.

We are using mixed mode for security.

ANy ideas on the what roles I need to use other than Sys Admin?

[quoted text, click to view]

Darren Green
8/21/2003 7:54:41 PM

In article <553a0349.0308211017.e3005d1@posting.google.com>, rwiethorn
<rwiethorn2002@yahoo.com> writes
[quoted text, click to view]

If using a trusted connection, and the package is run from the users
desktop then the user must have permissions to do everything, including
run all the SQL that is done in the package.

Using a trusted connection in DTS is just like in a VB program or
similar, the current user is the user that makes the connection, hence
they run the SQL.

Just remember DTS is a client side application.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Security Level on SQL