Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Basic background: I have an application on an app server (no MSSQL installed) that I want to allow to call an SSIS package.

One Solution: One option seems to be that we can install just SSIS on the app server without needing to install SQL Server itself. The app would be able to run a package while referencing the DB itself on a separate server.

Question: Would this require licensing SQL Server on the app server, even though the core engine is not part of the installation?

share|improve this question
3  
I concur with @mike Walsh's understanding that yes, this will cost you a license. The alternative I often see people taking is to run packages via SQL Agent (assuming concurrent execution is not a need), provide an stored proc which uses xp_cmdshell to call dtexec, or put up a service (windows or web) on the database server that routes your calls to dtexec. One that I haven't played with but seemed intriguing would be to try PsExec to launch dtexec on the remote server. –  billinkc Nov 6 '13 at 18:27
2  
I have the luxury of sitting by four DBAs and they were pointing me down the same SQL Agent route, as well. Thanks! –  John Spiegel Nov 6 '13 at 18:53
    
This question appears to be off-topic because it is about licensing. You should speak to the vendor about licensing. –  Max Vernon Nov 6 '13 at 19:31
    
It's a SQL Server question and there is an architectural component around the answer about licensing and implementation. I think that may make it head towards on topic? –  Mike Walsh Nov 6 '13 at 20:55
    
@MaxVernon I would argue as a general rule, we don't want licensing questions here but in this case, it's a pretty common thought (it's just ssis/ssrs, it doesn't count). I'd like to have an authoritative reference answer around (and thus my star) –  billinkc Nov 7 '13 at 16:53
show 1 more comment

1 Answer

up vote 4 down vote accepted

Yes. Now my disclaimer is I'm not your licensing rep or Microsoft so you should check with them on questions.

But the verbiage in the various license guides is typically "A Server running SQL Server - or any of its core components (SSRS, SSAS, SSIS)".

So if you are using SSIS on a server standalone, by the licensing guidelines you are running one of the core components on another server and that should be licensed separately from any other machine running a core component.

Depending on the load of your SSIS server, I have typically found that in many installations, just running the SSIS server on an already licensed machine - be it your warehouse server or a staging server or even your main production server works.

When you get into complex SSIS workloads with lots of moving parts and pieces and high overhead, you may start considering a separate processing server that perhaps also contains the DB instance for your SSIS logging and reporting type of environment. I'd say that I have to consider that sort of separation for performance rarely lately, though I have in the past.

Microsoft publishes several detailed and overview license guides. This one here is an example for SQL Server 2012.

share|improve this answer
1  
Initial searches were making me wonder. Thanks for the info (including overarching considerations). –  John Spiegel Nov 6 '13 at 18:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.