Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Do I need License

Author  Topic 

CanadaDBA

583 Posts

Posted - 2011-03-02 : 09:50:18
Environment:
SQL Box: Windows Server 2008, SQL Server 2008 Std
App Box: Windows Server 2008

I have one SQL and one App server. I've been asked to install the following on the App server.

1. BIDS (SQL Server Business Intelligence Development Studio)
2. SQL Server Integration Services

Do I need License for the App server, too?

Thanks!

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-02 : 14:08:44
Yes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2011-03-03 : 08:17:53
I assume I need license for the "SQL Server Integration Service"; correct?

I can't undrestand why the vendor has requested to have these two installed on App server. Shouldn't I install the SSIS in SQL box? Then I would save purchasing a license for the App server?

Canada DBA
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-03 : 11:17:47
Yes it's because of SSIS. Separating them like that is the best practice. We never deploy SSIS on the SQL box in production, it always goes on an app box. Yes it costs more due to licensing, but it's a better config.

If you guys don't want to pay for the additional license, then install it on the SQL box but be sure you have a pretty beefy box to handle both. Both can be hogs.



Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2011-03-06 : 08:50:27
Thanks for the advise and sharing your experience. It makes sense. Is this practice (separating SQL DB and SSIS) suggested or documented somewhere like on Microsoft website or other vendors? Do you have a link?

Canada DBA
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-06 : 12:41:59
I don't have any links to share, just general best practices that I have memorized.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -