Re: Connexion to SSIS

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

"l" wrote:

Are you asking why is sql authentication disabled in management studio?
why would you want to use sql authentication anyways? Trying to go from non
domain ws to the ssis engine that is in the domain or from one domain to
another when they do not trust? Or just theoretical curiosity?

Thanks, Liliya

"Cédrick" wrote:

Hi,

thanks for your response, I can now connect to my remote SSIS Server.

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

Thanks for your advices.

Regards.

Cédrick

"Allan Mitchell" wrote:

SSIS and SQL Server are not the same thing and can exist independently
of one another.

You may also want to read here

http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx


--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"Cédrick" <Cdrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A28FB219-6DDA-48B7-B804-C0E8659211A8@xxxxxxxxxxxxx:

Hi all,

I want to connect from a Client workstation to the SSIS engine of my SQL2005
server. But, the only choice of authentication I have is Windows
Authentication. Is it possible to change it and use a sql account to log into
the SSIS engine?

thanks in advance.

Regards
Cédrick B.


.

Relevant Pages

  • Re: How to set SQL Server only accept SQL Server Authentication mode?
    ... Our web project is used VS2003 and Crystal Reports for Visual Studio.NET. ... There have reports that directly call to sql server's stored procedure. ... > and SQL Server and Windows Authentication ... > However it does not o have onyl SQL Server Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)