Re: Connexion to SSIS

Hello Liliya,

Thanks for all the information you provided to me! Well I need to go deeper
in SQL Server Administration to really understand better the constraints
about the differents authentications!
Thanks

Cedrick

"Liliya Huff" wrote:

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: 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)
  • 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)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
Loading