Logon prompts twice -- sql server reporting services

sql server reporting services : Logon prompts twice

Fabian Cevallos
12/10/2004 6:09:57 PM

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

Fabian Cevallos
12/11/2004 3:25:12 PM

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?

[quoted text, click to view]

Jeff A. Stucker
12/13/2004 11:43:40 AM

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
--------------------------------------
[quoted text, click to view]

Fabian Cevallos
12/13/2004 9:33:57 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn