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



Ah, you would know better than I... as long as it says "local data only" in
the license, then that's what one should access. I stand chided.

--
____________________________________
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:exobA4aPHHA.140@xxxxxxxxxxxxxxxxxxxxxxx
I'm not a lawyer nor do I play one on TV but it would appear to me that
this violates at least the spirit if not the letter of the license
agreement restriction of local data only.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"William (Bill) Vaughn" <billva@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ehluajZPHHA.1756@xxxxxxxxxxxxxxxxxxxxxxx
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

  • SQL Server Compact Edition?
    ... Can Access 2007 work with SQL Server 2005 Compect Edition as the local data ... I'm planning an Access 2007 Runtime FrontEnd with SQL Server 2005 BackEnd ...
    (microsoft.public.access.adp.sqlserver)
  • Re: licensing
    ... SQL Server Reporting Services IS included in the license. ... Report Designer to access a properly licensed SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server Express with Advanced Services -- ? on limitations
    ... no this just means that you can only report on local data (stored in ... the SQL Server Express instance). ... Connectivity to Reporting Services can be done from the clients ...
    (microsoft.public.sqlserver.msde)

Loading