Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL2008 connection error

0 views
Skip to first unread message

Mecn

unread,
Dec 22, 2009, 12:31:35 PM12/22/09
to
Hi,

I just migrated SSRS2005 tp SSRS2008.
My question is,
1. I can't connect to SQL 2008 at all, I tried ODBC and SSRS reports. TCPIP
is enabled.
2. Now the SSRS 2008 url is http://servername /prodreports, How do I change
the URL to reports.company.com

Thnaks,


Klaus Sobel [MS]

unread,
Dec 29, 2009, 10:30:01 AM12/29/09
to
Hi,

can you try outside of SSRS (via ODDB Admin) if you are able to connect to
the ODBC datasource. If you are using SQL 2008 I would recommend the Sql
Server Managed Provider instead of ODBC.

You can change the url reservations in the RS Config Tool (RSCONFIGTOOL.EXE)

Best Regards

Klaus Sobel

"Mecn" wrote:

> .
>

0 new messages