RS on SQL Server 2005 Express

I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL Server
2000 and RS.
I need to move it to a new dedicated server that will have Windows Server
2003 Web Edition with SQL Server 2005 Express with RS.
The scaled down version of RS is fine for the application except -
http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
"Report data sources must be SQL Server relational databases that run
locally in SQL Server Express."
All of the data for my reports come from a remote server via stored
procedures. Is there any way that I can still use the data from the remote
server?
Maybe a VPN connection so that RS sees a local IP address'
TIA
--
AG
Email: discuss at adhdata dot comYou are asking how to cheat the system. The reporting services is free with
a free database if you are getting the data from that database. Otherwise,
you are essentially asking how to break your license. Even if possible
no-one should be telling how to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL Server
>2000 and RS.
> I need to move it to a new dedicated server that will have Windows Server
> 2003 Web Edition with SQL Server 2005 Express with RS.
> The scaled down version of RS is fine for the application except -
> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
> "Report data sources must be SQL Server relational databases that run
> locally in SQL Server Express."
> All of the data for my reports come from a remote server via stored
> procedures. Is there any way that I can still use the data from the remote
> server?
> Maybe a VPN connection so that RS sees a local IP address'
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>|||Bruce,
Thanks for the quick reply.
I am not looking to 'cheat' or 'break' anything. I want to make sure I
understand it correctly and keep it legal. I maintain an MSDN Premium
subscription (not cheap) and always make sure I have valid software
licenses. Sometimes there are different ways of looking at things and
something may be allowed under some circumstances and not others. I haven't
used 2005 yet and there is so much info out there, it saves a lot of time to
ask in this forum.
So, don't take issue if my explanation was less than eloquent. I was trying
to be concise.
It seems like an unusual restriction to not allow any connection to another
database for something that comes with a web server.
Also, in this case, the amount of data, number of users, other features
needed, etc. does not warrant full SQL Server - except for this one item.
Would it be ok to copy the data from the remote server to Express? Assuming,
of course, that Express itself allows linked servers.
--
AG
Email: discuss at adhdata dot com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uGYmnCwuGHA.1272@.TK2MSFTNGP05.phx.gbl...
> You are asking how to cheat the system. The reporting services is free
> with a free database if you are getting the data from that database.
> Otherwise, you are essentially asking how to break your license. Even if
> possible no-one should be telling how to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL
>>Server 2000 and RS.
>> I need to move it to a new dedicated server that will have Windows Server
>> 2003 Web Edition with SQL Server 2005 Express with RS.
>> The scaled down version of RS is fine for the application except -
>> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
>> "Report data sources must be SQL Server relational databases that run
>> locally in SQL Server Express."
>> All of the data for my reports come from a remote server via stored
>> procedures. Is there any way that I can still use the data from the
>> remote server?
>> Maybe a VPN connection so that RS sees a local IP address'
>> TIA
>> --
>> AG
>> Email: discuss at adhdata dot com
>>
>>
>|||OK.
I'm afraid I don't know about linked servers being available or not (which
is different from copying the data).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23lCz$5xuGHA.976@.TK2MSFTNGP05.phx.gbl...
> Bruce,
> Thanks for the quick reply.
> I am not looking to 'cheat' or 'break' anything. I want to make sure I
> understand it correctly and keep it legal. I maintain an MSDN Premium
> subscription (not cheap) and always make sure I have valid software
> licenses. Sometimes there are different ways of looking at things and
> something may be allowed under some circumstances and not others. I
> haven't used 2005 yet and there is so much info out there, it saves a lot
> of time to ask in this forum.
> So, don't take issue if my explanation was less than eloquent. I was
> trying to be concise.
> It seems like an unusual restriction to not allow any connection to
> another database for something that comes with a web server.
> Also, in this case, the amount of data, number of users, other features
> needed, etc. does not warrant full SQL Server - except for this one item.
> Would it be ok to copy the data from the remote server to Express?
> Assuming, of course, that Express itself allows linked servers.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uGYmnCwuGHA.1272@.TK2MSFTNGP05.phx.gbl...
>> You are asking how to cheat the system. The reporting services is free
>> with a free database if you are getting the data from that database.
>> Otherwise, you are essentially asking how to break your license. Even if
>> possible no-one should be telling how to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
>> news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL
>>Server 2000 and RS.
>> I need to move it to a new dedicated server that will have Windows
>> Server 2003 Web Edition with SQL Server 2005 Express with RS.
>> The scaled down version of RS is fine for the application except -
>> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
>> "Report data sources must be SQL Server relational databases that run
>> locally in SQL Server Express."
>> All of the data for my reports come from a remote server via stored
>> procedures. Is there any way that I can still use the data from the
>> remote server?
>> Maybe a VPN connection so that RS sees a local IP address'
>> TIA
>> --
>> AG
>> Email: discuss at adhdata dot com
>>
>>
>>
>|||AG,
The SQL Express support Linked server.
Althought it support Linked Server, I strongly recommend you to copy the
data to the SQL Express. If you wants to use the linked server in the
reporting services as your data source, you need to configure to use a
specified account to connect to the linked server.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Sounds good, thank you!
--
AG
Email: discuss at adhdata dot com
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOfQPn3uGHA.492@.TK2MSFTNGXA01.phx.gbl...
> AG,
> The SQL Express support Linked server.
> Althought it support Linked Server, I strongly recommend you to copy the
> data to the SQL Express. If you wants to use the linked server in the
> reporting services as your data source, you need to configure to use a
> specified account to connect to the linked server.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>