RS2005 cant'connect to server

Hi. Like some others here, I'm struggling to get a production install of
RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
database is on a separate SQL 2005 (SP2) server. With the help of some posts
here I finally am able to browse to Report Manager and also deploy reports
from VS2005, but only when local to the report server. On my own
workstation, I get "cannot display the page" when I try to browse to Report
Manager , and "connection could not be made to the report server" when I try
to deploy reports. I checked local intranet sites in IE, and the whole
segment is allowed (set in GP) so that isn't th problem. Do you have any
ideas why I can't connect to RS from a workstation on my network? Thanks.Hi,
"cannot display the page" seems to be an IIS layer problem. To help
identifying your problem, can you
-verify url used to browse reports (http://<yourserver>/Reports)
-verify your web request reach IIS (chek logs at
c:\windows\system32\logfiles\)
-verify Http Status code send back by IIS
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr
"Coop" <Coop@.discussions.microsoft.com> wrote in message
news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
> Hi. Like some others here, I'm struggling to get a production install of
> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
> database is on a separate SQL 2005 (SP2) server. With the help of some
> posts
> here I finally am able to browse to Report Manager and also deploy reports
> from VS2005, but only when local to the report server. On my own
> workstation, I get "cannot display the page" when I try to browse to
> Report
> Manager , and "connection could not be made to the report server" when I
> try
> to deploy reports. I checked local intranet sites in IE, and the whole
> segment is allowed (set in GP) so that isn't th problem. Do you have any
> ideas why I can't connect to RS from a workstation on my network? Thanks.|||If you can browse locally (when logged into the server) then everything is
setup correctly. I think the issue here is that you have not configured
roles properly. By default if you are a member of the local administrators
group then you are in the role that allows you to deploy. RS has its own
roles, totally separate from database security. Add your user for your
workstation to the local administrator group on the server. Then give it all
a try.
Also, try fully qualify your server (I assume when local you just used
localhost). For instance try
http://servername.whatever.com/reports
My guess is this is an issue with RS roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Pierre Riehl" <jean-pierre.riehl@.b-e-w-i-s-e.fr> wrote in message
news:41E3F7CE-1559-41D5-B5BD-26129028BC7B@.microsoft.com...
> Hi,
> "cannot display the page" seems to be an IIS layer problem. To help
> identifying your problem, can you
> -verify url used to browse reports (http://<yourserver>/Reports)
> -verify your web request reach IIS (chek logs at
> c:\windows\system32\logfiles\)
> -verify Http Status code send back by IIS
>
> --
> Jean-Pierre Riehl
> http://blog.djeepy1.net
> http://www.bewise.fr
>
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
>> Hi. Like some others here, I'm struggling to get a production install of
>> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
>> database is on a separate SQL 2005 (SP2) server. With the help of some
>> posts
>> here I finally am able to browse to Report Manager and also deploy
>> reports
>> from VS2005, but only when local to the report server. On my own
>> workstation, I get "cannot display the page" when I try to browse to
>> Report
>> Manager , and "connection could not be made to the report server" when I
>> try
>> to deploy reports. I checked local intranet sites in IE, and the whole
>> segment is allowed (set in GP) so that isn't th problem. Do you have any
>> ideas why I can't connect to RS from a workstation on my network?
>> Thanks.
>

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.)
>