Confused about Server Express and Reporting Services

Hi

I am a novice in all Server related aspects, but I want to learn to use SQL server Express in combination with C# Express.

All really worked fined unbtil now: I want to use the Reporting Services and the Analysis Services, but I can't find any?!

I have no idea what to do right now. Also, i am working with Windos Home Edition, is the missing IIS the problem?

Thank you and lots of greetings from Germany

Quattrus

Analysis Services is not included in SQL Express, you will need to purchase a higher Edition of SQL Server 2005 to get that.

Reporting Services does require IIS, so it is not supported on Windows XP Home.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Thank you, Mike.

I now concentrate on Report Viewer.

Regards,

Quattrus

|||

Mike

Can you say whether MSFT plan to later bundle MSAS with SQL Express?

If not, can you explain the rationale for not including MSAS? [I had thought that MSFT had a big push on BI with SQL05 and Office07, and think that MSAS is a key/central part of that BI stack.]

Many thanks

Justin

|||

Hi Justin,

At this time we have no plans to bundle Analysis Services with SQL Express.

Analysis Services is really Enterprise functionaltiy and as such is not included in the features of Express. There are other Enterprise features that we don't include in Express, such as Clustering and Database Mirroring.

Express is targeted at the non-professional developer, hobbyist, student and anyone who is interested in doing smaller scale development, but wants to leverage the security, scalability and reliability of SQL Server. The Express feature set was picked to be useful for this scale of application and customer.

BI certainly is important to Microsoft, and you still have to capability to use the rich capabilities of products such as Excel to analyze data stored in SQL Express, in addition to the ability to create great reports using Reporting Services on top of SQL Express.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

(Excuse me for my English, I am French). You know the hobbyists, are also good doors for the professional solutions. For my part I begined with VB and SQL Express, and now we have several licences SQL processor and Visual Studio professional at my job.

But I continue to use the Express Edition at home for 2 raisons, (1) not to pirate, (2) I have XP Home edition which does not support IIS.

To have a full fonctionnal Express edition with Advanced Services (Reporting services that i use at job), I miss a IIS emulator.

Regards,

Dominique

Confused about Server Express and Reporting Services

Hi

I am a novice in all Server related aspects, but I want to learn to use SQL server Express in combination with C# Express.

All really worked fined unbtil now: I want to use the Reporting Services and the Analysis Services, but I can't find any?!

I have no idea what to do right now. Also, i am working with Windos Home Edition, is the missing IIS the problem?

Thank you and lots of greetings from Germany

Quattrus

Analysis Services is not included in SQL Express, you will need to purchase a higher Edition of SQL Server 2005 to get that.

Reporting Services does require IIS, so it is not supported on Windows XP Home.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Thank you, Mike.

I now concentrate on Report Viewer.

Regards,

Quattrus

|||

Mike

Can you say whether MSFT plan to later bundle MSAS with SQL Express?

If not, can you explain the rationale for not including MSAS? [I had thought that MSFT had a big push on BI with SQL05 and Office07, and think that MSAS is a key/central part of that BI stack.]

Many thanks

Justin

|||

Hi Justin,

At this time we have no plans to bundle Analysis Services with SQL Express.

Analysis Services is really Enterprise functionaltiy and as such is not included in the features of Express. There are other Enterprise features that we don't include in Express, such as Clustering and Database Mirroring.

Express is targeted at the non-professional developer, hobbyist, student and anyone who is interested in doing smaller scale development, but wants to leverage the security, scalability and reliability of SQL Server. The Express feature set was picked to be useful for this scale of application and customer.

BI certainly is important to Microsoft, and you still have to capability to use the rich capabilities of products such as Excel to analyze data stored in SQL Express, in addition to the ability to create great reports using Reporting Services on top of SQL Express.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

(Excuse me for my English, I am French). You know the hobbyists, are also good doors for the professional solutions. For my part I begined with VB and SQL Express, and now we have several licences SQL processor and Visual Studio professional at my job.

But I continue to use the Express Edition at home for 2 raisons, (1) not to pirate, (2) I have XP Home edition which does not support IIS.

To have a full fonctionnal Express edition with Advanced Services (Reporting services that i use at job), I miss a IIS emulator.

Regards,

Dominique

Conflict between backup and fulltext catalog

Sometimes the scheduled full backups on MY_DATABASE are not performed,
throwing the following error related with the fulltext catalog (CATALOG_XXX)
that it's used by some tables:
"The backup of the file or filegroup "sysft_CatalogXXX" is not permitted
because it is not online. BACKUP can be performed by using the FILEGROUP or
FILE clauses to restrict the selection to include only online data.
[SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed."
How do I solve this error?
Thanks,
Gaspar.Are you trying to execute a backup while the fulltext catalog is being
rebuilt?
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gaspar" <gaspar@.gaspar.com> wrote in message
news:utLKzokYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Sometimes the scheduled full backups on MY_DATABASE are not performed,
> throwing the following error related with the fulltext catalog
> (CATALOG_XXX) that it's used by some tables:
> "The backup of the file or filegroup "sysft_CatalogXXX" is not permitted
> because it is not online. BACKUP can be performed by using the FILEGROUP
> or FILE clauses to restrict the selection to include only online data.
> [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed."
> How do I solve this error?
> Thanks,
> Gaspar.
>

Conflict between backup and fulltext catalog

Sometimes the scheduled full backups on MY_DATABASE are not performed,
throwing the following error related with the fulltext catalog (CATALOG_XXX)
that it's used by some tables:
"The backup of the file or filegroup "sysft_CatalogXXX" is not permitted
because it is not online. BACKUP can be performed by using the FILEGROUP or
FILE clauses to restrict the selection to include only online data.
[SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally
.
[SQLSTATE 42000] (Error 3013). The step failed."
How do I solve this error?
Thanks,
Gaspar.Are you trying to execute a backup while the fulltext catalog is being
rebuilt?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gaspar" <gaspar@.gaspar.com> wrote in message
news:utLKzokYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Sometimes the scheduled full backups on MY_DATABASE are not performed,
> throwing the following error related with the fulltext catalog
> (CATALOG_XXX) that it's used by some tables:
> "The backup of the file or filegroup "sysft_CatalogXXX" is not permitted
> because it is not online. BACKUP can be performed by using the FILEGROUP
> or FILE clauses to restrict the selection to include only online data.
> [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormal
ly.
> [SQLSTATE 42000] (Error 3013). The step failed."
> How do I solve this error?
> Thanks,
> Gaspar.
>

Configuring SQL Reporting Services for SSL

I've got an issue that is perhaps a bit different than any other
related posting on this topic.
I have successfully installed and configured SSRS for SQL 2005 and now
I'm at the step where I need to require SSL. So I opened the
Reporting Services Configuration, then selected Report Server Virtual
Directory. Then I select the checkbox Require Secure Socket Layer
(SSL) connections. At this step I am required to enter the name of
the certificate. Here is the problem: The server in on 2 seemingly
different domains and the certificate was issued to domain A, but the
server name is listed under domain B, but both domains resolve to the
same IP address. Here are the specifics:
A) The cert was named according to this domain pattern:
<server_name>.orgA.domainA.com
B) The computer name in system properties is:
<server_name>.orgB.xx.domainB.com
When I run the report server web interface, I get this error "The
request failed with HTTP status 401: Unauthorized."
So my question is: Why isn't the certificate for Domain A working?
Should I request a certificate under the domain of option B above? Is
there a configuration that is required? Note - I've modified the file
rsreportserver.config per the installation instructions.
Thanks in advance for your assistance,
-ScottOn Mar 6, 10:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
Anybody thoughts?|||On Mar 6, 11:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
I'm sorry to pester, but I'm running out of things to try on this
issue. Does anyone have thoughts to share on requiring SSL with SQL
2005 Reporting?

Configuring Charts for more than one axis

In Excel it is possible to have a primary and a secondary axis. This would allow for a chart to show to related data sets that have vastly different scales. Is this possible in Reporting Services.Sorry, this is currently not supported out-of-the-box. There are add-on products (e.g. Dundas Chart for Reporting Services) that can plug into RS 2005 and provide that capability.

-- Robert