Re: Why save SSIS using integrated security

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Sun, 12 Aug 2007 20:10:30 +0100

Mostly MS are recommending integrated security over SQL Authentication - not
just for DTS. The reasons for this are that the password doesn't need
storing anywhere, and the restrictions that come with Windows passwords can
be applied - complexity, can't use previous passwords, can restrict as soon
as someone leaves, use of windows groups etc....I'd guess that the general
recommendation is to only use SQL Authentication for untrusted situations -
working accross domains, unix clients, working over the internet etc.
HTH,
Paul Ibison

.

References:
- Why save SSIS using integrated security
  - From: JXStern

Prev by Date: Re: Calling Stored Procedure in DTS
Next by Date: Authentication issues vb.net and DTS command line project
Previous by thread: Why save SSIS using integrated security
Next by thread: It keeps appending in excel?
Index(es):
- Date
- Thread

Relevant Pages

Expire passwords
... Is there a way to enforce the users to change their passwords every 90 days ... to delete a login if the user has not login X number of days? ... I am using Windows 2000/ SQL Server 2000/ SQL authentication. ...
(microsoft.public.sqlserver.security)
Single login, multiple passwords
... Is it at all possible to have a single login have multiple passwords? ... We are using sql authentication. ...
(microsoft.public.sqlserver.security)