Nick Hill 
Isle of Man
Member since
3/25/2005
Registered Users
Posts: 416
 |
| 1/24/2006 02:58 PM |
|
I have a user running SBS2003 premium. I have already upgraded them to SBS2003 SP1 but did not run the SQL SP4 patch as they had several packages running on SQL & I did not get confirmation from all the suppliers that their software would still run. The end user now wants me to upgrade to SP4 & also install SQL 2000 Reporting services. Is this a separate product that has to be bought or is it hidden on the SBS2003 Premium disks? |
|
|
|
|
|
Eriq Neale
Texas, USA
Member since
5/3/2005
Microsoft MVP
Posts: 2117
|
| 1/31/2006 02:21 AM |
|
SQL Reporting Services is a separate product, as I recall. It is not included with the SBS media.
-Eriq |
|
Eriq Neale - Small Business Specialist, SBS MVP, Mac Guru
EON Consulting LLC www.eonconsulting.net
Lead Author of Windows Small Business Server 2008 Unleashed
In bookstores December 10, available for pre-order now
Listen to eOnCall at AIRtunZ or visit www.eoncall.com. |
|
|
|
Nick Hill
Isle of Man
Member since
3/25/2005
Registered Users
Posts: 416
|
| 1/31/2006 08:41 AM |
|
Thank you for your reply.
Am I correct in understanding that the user is licensed to use the product? |
|
|
|
|
|
Eriq Neale
Texas, USA
Member since
5/3/2005
Microsoft MVP
Posts: 2117
|
| 1/31/2006 09:07 PM |
|
That one I'm not 100% certain on. This link
(http://www.microsoft.com/sql/prodinfo/previousversions/rs/howtolicensers.mspx)
seems to indicate that a license for SQL Reporting Services is included
wihtthe SQL license on SBS, but I'm not 100% certain. Several Google
searches all seemed to imply the same thing, but I can't find anything
definitive on the MS site.
|
|
Eriq Neale - Small Business Specialist, SBS MVP, Mac Guru
EON Consulting LLC www.eonconsulting.net
Lead Author of Windows Small Business Server 2008 Unleashed
In bookstores December 10, available for pre-order now
Listen to eOnCall at AIRtunZ or visit www.eoncall.com. |
|
|
|
Nick Hill
Isle of Man
Member since
3/25/2005
Registered Users
Posts: 416
|
| 1/31/2006 10:12 PM |
|
Thank you.
I also found from Google searches that SQL users appear to have a licence to use Reporting, but I could find nothing about this on the Microsoft site. |
|
|
|
|
|
Didier Pironet
Belgium
Member since
3/24/2005
Registered Users
Posts: 238
|
| 2/15/2006 11:33 AM |
|
Anyway, the Reporting Service installation doesn't require a key...
At some time in the installation, it will ask you if you use CAL's or CPU type of licensing.
With SBS2003R2 it is 'built in' even with the workgroup edition of SQL2005.
Rgds,
Didier
|
|
MCSE+I, MSCA, MCSE2003, SBS Specialist certified, HP ASE Proliant, ...
http://www.support-team.be |
|
|
|
Nick Hill
Isle of Man
Member since
3/25/2005
Registered Users
Posts: 416
|
| 2/20/2006 12:39 PM |
|
Thank you Didier
Regards
Nick
|
|
|
|
|
|
Julian Sharp
Nottingham, UK
Member since
4/10/2005
Registered Users
Posts: 6
|
| 2/24/2006 05:13 AM |
|
Nick
If you have SBS2003 Premium you are licensed for SQL Reporting Services on your SBS server. You need to get hold of the SQL 2000 Standard Reporting Services Installation CD - if you have MSDN you can download it from there but otherwise you would have to buy a SQL 2000 media kit (~£20). PS. You can find this SQL RS install on the CRM 3.0 Server CD
Be aware that SQL RS likes to install two virtual IIS directories in the default website which is normally OK unless you have messed around with the default website. I normally have to make sure the IP addresses are not restricted in the IIS virtual directories after the install.
Makre sure you download and install SP1 and SP2 for SQL Reporting Services - a lot of fixes and SP2 allows printing of reports.
Julian
|
|
|
|
|
|
Nick Hill
Isle of Man
Member since
3/25/2005
Registered Users
Posts: 416
|
| 2/24/2006 08:38 AM |
|
Excellent info Julian, thank you.
IIS has not been played with too much, other than for WSUS.
Regards
Nick
|
|
|
|
|
|