Geeks With Blogs
Mike Huguet I'm just talking out loud
While http://en.wikipedia.org/wiki/SQL_Server_Express outlines some limitations of SQL Server Express, there are some specifics that are missing for Reporting Services.  One such example is what I discovered today while at a client that uses DB2 for its RDBMS.  SSRS that comes with the Express Edition only supports creating reports against the local SQL Server data source.  Be aware of this when considering SQL Server Express in your system design. 

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx outlines a feature matrix for the SQL Server 2005 editions.  http://msdn.microsoft.com/en-us/library/ms365166.aspx outlines the limitations for SSRS within SQL Server 2008 Express.

Posted on Wednesday, January 21, 2009 9:30 PM SQL Server | Back to top


Comments on this post: Limitations of SQL Server 2005/2008 Reporting Services Express Edition

# re: Limitations of SQL Server 2005/2008 Reporting Services Express Edition
Requesting Gravatar...
One work around (if you really wanted to use SSRS Express with another datasource type) is to create a linked server in the SQL Server Express instance then pass your queries through the SQL connection. I do this at work to run SSRS 2005 Express reports against Oracle. You can either create stored procedures in MSSQL that will construct the SQL statement then make the call or construct the SQL in the report itself:


-- create the DB2 linked server (from: http://blogs.msdn.com/dotnetinterop/archive/2006/01/20/defining-a-db2-as-a-linked-server.aspx)
EXEC sp_addlinkedserver
server='LINKEDDB2',
@srvproduct='Microsoft OLE DB Provider for DB2',
@catalog='DB2',
@provider='DB2OLEDB',
@provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'
go

-- create the datasource in your report to point to your SQL Server Express instance; then make the SQL calls as follows from your report:

exec( 'Your query here') at LINKEDDB2;
Left by Bill on May 15, 2009 8:37 AM

# re: Limitations of SQL Server 2005/2008 Reporting Services Express Edition
Requesting Gravatar...
Hi,
I have a very Basic doubt.Microsoft has mentioned that "SSRS that comes with the Express Edition only supports creating reports against the local SQL Server data source". does this means I can generate reports only from the machine where SQL server express 2008 is installed.I cannot generate reports from a client machine which connects to this db through the network
Left by Anandarajeshwaran.J on Jun 22, 2009 8:25 AM

# re: Limitations of SQL Server 2005/2008 Reporting Services Express Edition
Requesting Gravatar...
This is quite useful because now I can compare the reports from the 2005 edition against the ones from 2008 and find out where some of the previous problems were and not do them again.
Left by best motivational speakers on Jul 19, 2010 3:44 PM

# Hi,
Requesting Gravatar...
I have created a table, closed it and connected back to the server to insert values into the table I have created ,the server result shows that
'the string or binary is truncated ',
'the statement is terminated' and
(0 row affected)
will you please help me solve this problem ?.
Left by O.A.K on Jun 01, 2011 7:59 AM

# re: "the string or binary is truncated"
Requesting Gravatar...
"the string or binary is truncated" error is showing because you are trying to insert a string value with more characters than its field size.
Left by Sunny on Aug 02, 2011 4:22 AM

Your comment:
 (will show your gravatar)


Copyright © Mike Huguet | Powered by: GeeksWithBlogs.net