SQL Express license hosting for business purpose?

Hot Topic

Is SQL Server 2005 still using Named Pipes ?
Unpublishing an article
Problem with plug-in algorithm in SQL Server 2005
need sample code in vb.net
Data format conversion.
Report Builder Color Pallette
Database Diagram in SQL Server Management Studio Express Help please
Tool from SQL 2000, Missing in SQL 2005?
Object info ?
SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

SQL Server

aggregations on cube dimensions
How to Update or Delete records with a SqlServer Destination
Report Service failed to start
Custom ControlFlow
using DTS within SSRS
raw file destination and environment variables
Question: how to filter records from the output of a Multicast?
CTE in a DSV named query
Help Please... How restrict the parameter values a user sees when using rep svs with a cube?
Cant upload report (rdl-file) in Reporting Services 2005

SQL Express license hosting for business purpose?

Hi every one,

SQL Server 2005 Express License allow hosting for business purpose, as DB size is limited to 4 GB

Any restriction or limitation

regards




Answer this question

SQL Express license hosting for business purpose?

  • Gentia

    Thank you very much for the answer, but I was asking about Reporting Data Sources, that still limited to the relational data only in Express Edition.

    Please, look at http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx,

    under

    Business Intelligence>>>Reporting Data Sources

    If there is any way to revoke this limitation.

    Thank you very much again,

    Alfred.

  • Naive

    There is no restriction on using XML in SQL Express. SQL Server 2005 Express Edition has a new XML datatype so you can store native XML in SQL Express.

  • kuldeept

    Dear Tim Tow,
     
    as a SQL Server Product Manager, would like to ask you this:
     
    SQL Express is limited,(that's why it is free), but would it be wize to give an opportunity to work with XML data source ,- we all know that SQL Express Advanced Edition is restricted to relational data sources.
    XML is a great technology, why Microsoft wants to restrict using it freely in SQL Express
     
    With best regards,
    Alfred Yomtov.

  • Chimme2

    Yes, SQL Server Express limits Reporting Services data sources to local, relational data sources only.

    This limitation is in SQL Server 2005 Express and SQL Server 2005 Workgroup.

    SQL Server 2005 Standard and Enterprise Edition do not restrict data sources for Reporting Services.

    Thanks for your feedback.

    We are constantly evaluating feedback, and this is something that we may consider relaxing in the future.

  • DanieLondon

    No, Tim Tow, there is a restriction:

    This is the answer of your colleague, Robert Bruckner MSFT to my question

    "Yes, SQL Express Advanced Edition is restricted to relational data sources. Check this link for more details: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

    Robert "

    The question was:

    "The reports based on XML is perfectly displayed in development Environment.

    But than uploaded to Server, the following occurs:

    ? An error has occurred during report processing.

    ? An attempt has been made to use a data extension 'XML' that is not registered for this report server.

    Help needed, thank you."

    So, again, as a SQL Server Product Manager, please revoke this limitation,

    So we, developers may use XML technology with such a great tool as Reporting Services.

    Thank you in advance,

    Alfred Yomtov.

  • jez

    SQL Server Express can be used for hosting. There are no limitations or restrictions on using it for business purposes.

    Tim Tow

    SQL Server Product Manager
  • SQL Express license hosting for business purpose?
Answer this question