Re: SQL Server Express with Advanced Services -- ? on limitations

Yes, that's right, but as I illustrate in my book, if you setup a linked
server on SQL Express, you can access data from other data sources in the
report. It's the long way around, but it can be done.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
-----------------------------------------------------------------------------------------------------------------------


Microsoft MVP, Author, Mentor
Microsoft MVP
"Jens" <Jens@xxxxxxxxxxxxxxxx> wrote in message
news:1168901413.097360.190120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

no this just means that you can only report on local data (stored in
the SQL Server Express instance). You cannot access another servers
data. Connectivity to Reporting Services can be done from the clients
to the server.

HTH, Jens K. Suessmeyer.

----
http://www.sqlserver2005.de
----



.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: The following system error occurred: .
    ... For why SQL Browser service is disabled by design, ... SQL Server 2000 instance which will use the UDP port 1434 by default. ... Your SSIS report file that linked to your SSAS database. ... Export the reportserver configuration to a xml file in IIS. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using the ISA reporting from a sql database
    ... I tried to do a report from the reports tab in ISA, ... It comes up empty like it doesnt know where to pull the information from ... since I am logging to another server into sql. ...
    (microsoft.public.isa.configuration)
  • Re: Usage report, Mailbox size: There is no data available for this statistic
    ... I know that when you open the Server Usage Report ... First this issue may be caused by the corrupt Monitoring component. ... This issue occurs when you don't have SQL MSDE 2000 SP4 installed. ...
    (microsoft.public.windows.server.sbs)
Loading