Re: Connexion to SSIS

it is possible. Some of my production systems work this way, meaning the
windows authentication is used in the ssis package and this package is a
scheduled as a job.
The issue can be related to permissions on the scmanager service if the
server is 2003 SP1. 2003 SP1 changes the scmanager permissions to allow
remote connection from members of the local admins group only.
A way to verify it the account in question to the local admins and try
again. If your account is in, then the issue is most likely the scmanager
permissions.
Then you fix the rights or ask your sysadmins to do so.
reference
http://support.microsoft.com/default.aspx/kb/907460/

Do you want your security this way or not is a different question. You decide.
If you do not want to, can use proxy accounts. Have to set it up, grant
rights to msdb, and maintain your passwords changes if you are under SOX
rules for example for your proxy accounts, because they are stored in ms sql
too now if you choose to use proxy.
I gave my situation a thought and the inner workings of the place where the
security should be implemented and have my second thoughts about using prohy
mostly because of maintenance and the stuff who is going to do it (so you
will not have an impression that using proxy is not a good idea in general :)
).

--
Thanks, Liliya



"Cédrick" wrote:

Hi Liliya,

Well it is just theorical question cause some of my midmarket clients have
specific configurations, and some times it would have been easier to define
only SQL Server authentication and use it to connect my remote client to the
sql server.

Regards

Cédrick


But part of my question was: is it possible to connect to SSIS engine using
SQLServer Account by SQL Server Authentication?

.

Relevant Pages

  • Re: Login Failed For User
    ... Asp.net app runs under aspnet local windows account. ... You are using windows authentication in connection string for sql server. ... You might use sql server authentication, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connexion to SSIS
    ... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
    (microsoft.public.sqlserver.dts)
  • SA password
    ... That's of course if your NT account has SA priveledges. ... you do not, and you did not delete the builtin admins, you ... >Right click on your SQL Server in the Enterprise Manager ... >and then change back to Use SQL Server authentication, ...
    (microsoft.public.sqlserver.security)
  • SQL Server: beginner: "Login failed for user sa."
    ... Could you help me please with SQL Server problem? ... Server in SQL Server Authentication, account sa, password sa. ...
    (comp.databases.ms-sqlserver)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)