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.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2005-10-25 : 11:27:35
|
| hi all,This question is for SQL Server 2000 Standard running on Windows 2000 Server Standard:I've been asked to look into what the requirements would be to use Reporting Services.About all I know is that IIS must be running on the server where Reporting Services is installed. Lets assume for now that RS will be installed on our SQL Server server.So my questions are:1. Is IIS free$ ?2. As for the development tools... do I need Visual Studio.net 2003 ? Do I need to purchase a VS.net 2003 license for the server - or just a license for each developer? Will Visual Basic.net suffice (that's all we use - no C#, J#)3. How does ASP.net figure into this - is ASP.net part of Visual Studio.net 2003 ?I'm hoping that someone who is using Reporting Services can reply back.Thank You. John |
|
|
jhermiz
3564 Posts |
Posted - 2005-10-25 : 17:55:27
|
quote:
Originally posted by jbates99
hi all,This question is for SQL Server 2000 Standard running on Windows 2000 Server Standard:I've been asked to look into what the requirements would be to use Reporting Services.About all I know is that IIS must be running on the server where Reporting Services is installed. Lets assume for now that RS will be installed on our SQL Server server.So my questions are:1. Is IIS free$ ?2. As for the development tools... do I need Visual Studio.net 2003 ? Do I need to purchase a VS.net 2003 license for the server - or just a license for each developer? Will Visual Basic.net suffice (that's all we use - no C#, J#)3. How does ASP.net figure into this - is ASP.net part of Visual Studio.net 2003 ?I'm hoping that someone who is using Reporting Services can reply back.Thank You. John
Hello John,RS is free if you place reporting services on the same box as your sql install. But, it is not recommended, and personally I would not do it either. Although, anything free is tempting, if you place RS as the web server on the same box as your sql server you may suffer from:-performance delays-hacking / security-space-unhappy usersYour RS box will not only be taking time just to open the report, but it has to pull the data (your datasets / queries) from that same box. Meanwhile, you may be running enterprise applications on the sql box and off in la la land joe schmo is running some huge labor export. This will cause performance delays. You also get into security breaches, you have to make sure the box is fully secure...hackers will nail you if you don't.IIS comes with windows xp professional, and also win2k and 2k3, and yes it is free. It is essentially packaged with the OS.The development tools you will need for creating reports is visual studio.net. You will need to purchase a license for each developer. And yes Visual Basic.net will suffice, you do not have have ot have visual c#...if you dont want it. We have the entire enterpise that includes all the languages including the reporting development toolASP.net is just another language or application like c# or vb.net. It is also found in visual studio.net.You have to understand that vs.net is simply a LARGE application. It can contain VB.net, C#, JSharp, Report Designer, Crystal Designer, ASP.net, etc etc...ASP.net is a web based application allowing you to create static or dynamic web pages. Within asp.net the code pages (the programming) can be vb.net / C# or a combination of both, etc etc...Hope this helps.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
|
|
Licenses Required for Visual Studio 2003.net