SQL & RS 2005 General Questions -- sql server reporting services

Jason L Lind
11/3/2005 12:39:03 PM

First one would be no. RS is an add on to SQL Server 2005, including the
Express edition.

And yes it is possible, as far as I am aware the SqlData classes can
interact with SQL Server 2005 as long as the connection string is valid.

[quoted text, click to view]

Bruce L-C [MVP]
11/3/2005 3:36:40 PM

Here is a useful link:
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx

It says local data only. So I guess it depends if the MySQL or PostgresSQL
is on the same box.

Note that you can use RS 2005 reports without a server or a SQL Server
license. Some limitations but pretty full featured. VS 2005 has two
controls: winform, webform. That you can use for reports. In local mode you
provide the reprot and the dataset and away it goes. In server mode they
work with your RS Server.

SQL Server 2005 will have no difficulty with .Net framework 1.1.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
11/3/2005 3:56:43 PM

I believe he was not asking if RS would use one of those as its object/meta
data store, but if he could report against data in it. Not sure of
restrictions of express but RS in general reports against data with oledb
drivers, odbc drivers, managed drives for SQL Server and Oracle.

Now if he is asking if RS could be hosted on those then you are correct.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Tudor Trufinescu (MSFT)
11/3/2005 6:13:01 PM

The express edition of SRS allows to run reports built on top of local SQL
Express datasources only.

Hope that answers your question,
Tudor

[quoted text, click to view]

Bruce L-C [MVP]
11/3/2005 10:04:55 PM

The link was not very clear. Thanks for the clarification.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Tudor Trufinescu (MSFT)" <TudorTrufinescuMSFT@discussions.microsoft.com>
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : SQL & RS 2005 General Questions