all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

License Question



License Question Aussie Rules
5/24/2006 9:50:48 PM
sql server reporting services: Hi,

If I design a report using Reporting Services in SQL 2005 Enterprise, but
then deploy into a SQL2005 workgroup environment, is that ok?

Will the report even work ?

Thanks

RE: License Question weilu NO[at]SPAM online.microsoft.com
5/25/2006 3:02:04 AM
Hi Aussie,

Thank you for your post.

It's will be ok. Report designing isn't related on the edition of SQL
Server. The report created using different edition will be same. You could
deploy it into other edition.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Re: License Question weilu NO[at]SPAM online.microsoft.com
5/25/2006 9:14:33 AM
Hi Aussie,

Thank you for the update.

As I mentioned in the previous post, the Report Definition File (rdl file)
isn't related with the SQL edition.

You could deploy your rdl file to any Report Server (2005).

Since SQL Express does not support the Reporting Services, I don't think
you could deploy the report to SQL Express.

Here is an article for your reference:

Features Supported by the Editions of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms143761(SQL.90).aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Re: License Question Aussie Rules
5/25/2006 9:39:16 AM
Are reports supported in all versions of SQL..

If I develop using enterprise, but then the user users express edition, will
the reports work in express?

Thanks


[quoted text, click to view]

Re: License Question Bruce L-C [MVP]
5/25/2006 9:45:52 AM
Just a quick correction, there is now a version of Express that will work
for reports. There are two versions of Express. But, your data has to be
local. For instance, deploying to Express a report and then having the
report go against Oracle data or SQL Server data on another machine will not
work (at least that is my understanding).

Also, although the report is not version specific and there is very little
difference as far as the reports are concerned there is one area, infinite
click through that is version specific. The other version specific issues
(web farms, data driven subscriptions etc) are not really report specific.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: License Question Aussie Rules
5/25/2006 10:57:46 PM
Hi Bruce,

Thanks for your reply.

My intent is to develop a bunch of reports within our dev environment which
is using SQL2005 enterprise.

Some of these report will be available in our low end software which will be
on SQL 2005 Express. The architecture would be VB.net clients on accessing a
sqlexpress machine with the reports on that same machine. The vb.net2005
will use the reports viewer.

From what I understand from your reply,this should not be a problem..



[quoted text, click to view]

Re: License Question weilu NO[at]SPAM online.microsoft.com
5/26/2006 4:01:33 AM
Hi Aussie,

Thank you for the update and thanks Bruce's correction.

In the article I provided in the previous post, it indicated that the SQL
Express with Advanced Services did support Reporting Services.

You could download it here:

Microsoft SQL Server 2005 Express Edition with Advanced Services
http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-
BC75-3B02B5E48A40&displaylang=en

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button