Monday, March 19, 2012

Logon prompts twice

Any idea why the logon prompts again when clicking on a report after
succesfully logging into the reporting services the first time? The report
opens with no problem. I am using Windows Server 2003, SQL Server 2000
Standard Edition, and IIS 6. Thanks.
FabianStill looking for a solution to this problem with no luck so far. Here is
some additional information that might help pinpoint the problem.
The title of the first logon window is "Connect to www.mywebsite.com" while
the title of the second logon window is "Connect to ServerName"
Any suggestions on how to fix this?
"Fabian Cevallos" <fcevallos@.bellsouth.net> wrote in message
news:ufXbp1w3EHA.2788@.TK2MSFTNGP15.phx.gbl...
> Any idea why the logon prompts again when clicking on a report after
> succesfully logging into the reporting services the first time? The report
> opens with no problem. I am using Windows Server 2003, SQL Server 2000
> Standard Edition, and IIS 6. Thanks.
> Fabian
>|||You need to change the server name in your *.config files (search through
your RS installation folders) to a fully qualified domain name (FQDN). The
authentication cookies aren't crossing domain names.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Fabian Cevallos" <fcevallos@.bellsouth.net> wrote in message
news:OgClS%2373EHA.1260@.TK2MSFTNGP12.phx.gbl...
> Still looking for a solution to this problem with no luck so far. Here is
> some additional information that might help pinpoint the problem.
>
> The title of the first logon window is "Connect to www.mywebsite.com"
> while the title of the second logon window is "Connect to ServerName"
>
> Any suggestions on how to fix this?
>
> "Fabian Cevallos" <fcevallos@.bellsouth.net> wrote in message
> news:ufXbp1w3EHA.2788@.TK2MSFTNGP15.phx.gbl...
>> Any idea why the logon prompts again when clicking on a report after
>> succesfully logging into the reporting services the first time? The
>> report opens with no problem. I am using Windows Server 2003, SQL Server
>> 2000 Standard Edition, and IIS 6. Thanks.
>> Fabian
>|||Thanks Jeff.
It is fixed!
I modified the RSWebApplication.config located at: C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
From: <ReportServerUrl>Server/ReportServer</ReportServerUrl>
To:
<ReportServerUrl>http://www.mywebsite.com/ReportServer</ReportServerUrl>
Fabian Cevallos
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:%235GqrOU4EHA.2192@.TK2MSFTNGP14.phx.gbl...
> You need to change the server name in your *.config files (search through
> your RS installation folders) to a fully qualified domain name (FQDN).
> The authentication cookies aren't crossing domain names.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Fabian Cevallos" <fcevallos@.bellsouth.net> wrote in message
> news:OgClS%2373EHA.1260@.TK2MSFTNGP12.phx.gbl...
>> Still looking for a solution to this problem with no luck so far. Here
>> is some additional information that might help pinpoint the problem.
>>
>> The title of the first logon window is "Connect to www.mywebsite.com"
>> while the title of the second logon window is "Connect to ServerName"
>>
>> Any suggestions on how to fix this?
>>
>> "Fabian Cevallos" <fcevallos@.bellsouth.net> wrote in message
>> news:ufXbp1w3EHA.2788@.TK2MSFTNGP15.phx.gbl...
>> Any idea why the logon prompts again when clicking on a report after
>> succesfully logging into the reporting services the first time? The
>> report opens with no problem. I am using Windows Server 2003, SQL
>> Server 2000 Standard Edition, and IIS 6. Thanks.
>> Fabian
>>
>

No comments:

Post a Comment