DNS_HOST_NOT_FOUND on localhost with Adventureworks

Hi, I just installed on XP Pro SP1 - the developer edition for SQL 2000 &
Report Services. The problem I am encountering is that I can not get any
report to render. I can publish/deploy them without error. The report
manager works fine until I click on a report.
Here's the odd part, if I use the reportserver URL such as :
http://localhost/reportserver?%2fSampleReports%2fCompany+Sales&rs:Command=Render
The report renders fine. The issue is rendering in Report Manager. Here is
the full error message:
Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup.
Contact your system administrator if the problem is not found by retrying the
URL.
----
Please contact the administrator.
I would appreciate any help.
Thank you.I found the problem - the config file for RSManager only had the computer
name, but not the entire DSN name.
"Bob" wrote:
> Hi, I just installed on XP Pro SP1 - the developer edition for SQL 2000 &
> Report Services. The problem I am encountering is that I can not get any
> report to render. I can publish/deploy them without error. The report
> manager works fine until I click on a report.
> Here's the odd part, if I use the reportserver URL such as :
> http://localhost/reportserver?%2fSampleReports%2fCompany+Sales&rs:Command=Render
> The report renders fine. The issue is rendering in Report Manager. Here is
> the full error message:
> Bad Gateway
> The following error occurred:
> [code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup.
> Contact your system administrator if the problem is not found by retrying the
> URL.
> ----
> Please contact the administrator.
> I would appreciate any help.
> Thank you.sql

Distributed Transaction

I want to do distributed queries in a transaction, I'm using win XP pro, then I connect to a remote server (win 2003 standard), the remote server has sql server standard edition and my computer has sql server personal edition.
when I try to do this
begin tran
select * from rafael.tcadbcoi.dbo.invlin
commit tran
I get this error
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
without "begin tran" , the sicript works ritght> when I try to do this
> begin tran
> select * from rafael.tcadbcoi.dbo.invlin
> commit tran
> I get this error
> The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to
> begin a distributed transaction. [OLE/DB provider returned message: New
transaction cannot enlist in
> the specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction
> returned 0x8004d00a].
> without "begin tran" , the script works right
--
Error 0x8004d00a is an issue with MSDTC. On the Windows 2003 server, verify
whether "Enable DTC for remote access" is turned on, reboot and try again.
For more information, consult the "Configuring an application server"
documentation of Windows 2003 online help.
Hope this helps,
--
Eric Cárdenas
SQL Server support