Report Services can't connect to remote DB

I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
The full install was done for SQL 2005 (all features). My report server DB's
are running on the SBS server. The second is a W2k3 R2 server with an app DB
running on SQL 2000.
I have created a report that extracts data from the remote SQL2000 DB. The
report runs fine through Business Intelligence. When I build and deploy
the report, the report can't connect to the DB. I get an error message "
Impossible to create a connection to the DB. This fonction is not supported
in this version of reporting services.(This is a translation since message is
in French).
I have tried using a Windows authentication connection and also with sa.
Do I really need to get SQL 2005 Standard Ed.?
--
Eric Simonneau
Hotel Logistics specialistFound the answer. SQL 2005 Workgroup edition will only permit connection to
the local machine. Remote queries are not permitted.
--
Eric Simonneau
Hotel Logistics specialist
"eric simonneau" wrote:
> I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
> The full install was done for SQL 2005 (all features). My report server DB's
> are running on the SBS server. The second is a W2k3 R2 server with an app DB
> running on SQL 2000.
> I have created a report that extracts data from the remote SQL2000 DB. The
> report runs fine through Business Intelligence. When I build and deploy
> the report, the report can't connect to the DB. I get an error message "
> Impossible to create a connection to the DB. This fonction is not supported
> in this version of reporting services.(This is a translation since message is
> in French).
> I have tried using a Windows authentication connection and also with sa.
> Do I really need to get SQL 2005 Standard Ed.?
> --
> Eric Simonneau
> Hotel Logistics specialist

Report server SQL 2005

For some reason I can't configure that Report server on a SQL 2005
(workgroup) that is part of the Windows 2003 SBS R2 software.
In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
is greyed out.
I tried uninstalling it and reinstalling and applied the patches. Not I
can't even open the CONFIGURE REPORT SERVER program. I get "NO report
servers were found on the machince" Detail, "Invaild namespace"
All I am tring to do get perpare SQL so I can install CRM 3.0.
Did you apply SP2 to your Reporting Services service? This SP solves most
problem.
Ekrem ?nsoy
"support at Marin" <supportatMarin@.discussions.microsoft.com> wrote in
message news:7A0756F0-F3AF-469A-A61C-B9C1C37603E8@.microsoft.com...
> For some reason I can't configure that Report server on a SQL 2005
> (workgroup) that is part of the Windows 2003 SBS R2 software.
> In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
> is greyed out.
> I tried uninstalling it and reinstalling and applied the patches. Not I
> can't even open the CONFIGURE REPORT SERVER program. I get "NO report
> servers were found on the machince" Detail, "Invaild namespace"
> All I am tring to do get perpare SQL so I can install CRM 3.0.

Report server SQL 2005

For some reason I can't configure that Report server on a SQL 2005
(workgroup) that is part of the Windows 2003 SBS R2 software.
In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
is greyed out.
I tried uninstalling it and reinstalling and applied the patches. Not I
can't even open the CONFIGURE REPORT SERVER program. I get "NO report
servers were found on the machince" Detail, "Invaild namespace"
All I am tring to do get perpare SQL so I can install CRM 3.0.Did you apply SP2 to your Reporting Services service? This SP solves most
problem.
Ekrem ?nsoy
"support at Marin" <supportatMarin@.discussions.microsoft.com> wrote in
message news:7A0756F0-F3AF-469A-A61C-B9C1C37603E8@.microsoft.com...
> For some reason I can't configure that Report server on a SQL 2005
> (workgroup) that is part of the Windows 2003 SBS R2 software.
> In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
> is greyed out.
> I tried uninstalling it and reinstalling and applied the patches. Not I
> can't even open the CONFIGURE REPORT SERVER program. I get "NO report
> servers were found on the machince" Detail, "Invaild namespace"
> All I am tring to do get perpare SQL so I can install CRM 3.0.

Report server SQL 2005

For some reason I can't configure that Report server on a SQL 2005
(workgroup) that is part of the Windows 2003 SBS R2 software.
In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
is greyed out.
I tried uninstalling it and reinstalling and applied the patches. Not I
can't even open the CONFIGURE REPORT SERVER program. I get "NO report
servers were found on the machince" Detail, "Invaild namespace"
All I am tring to do get perpare SQL so I can install CRM 3.0.Did you apply SP2 to your Reporting Services service? This SP solves most
problem.
--
Ekrem Ã?nsoy
"support at Marin" <supportatMarin@.discussions.microsoft.com> wrote in
message news:7A0756F0-F3AF-469A-A61C-B9C1C37603E8@.microsoft.com...
> For some reason I can't configure that Report server on a SQL 2005
> (workgroup) that is part of the Windows 2003 SBS R2 software.
> In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
> is greyed out.
> I tried uninstalling it and reinstalling and applied the patches. Not I
> can't even open the CONFIGURE REPORT SERVER program. I get "NO report
> servers were found on the machince" Detail, "Invaild namespace"
> All I am tring to do get perpare SQL so I can install CRM 3.0.