Prompt for windows identification when connecting to RS Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fabian - 17 Mar 2005 20:11 GMT

We set up a server running SQL Server 2000 Reporting Services. We map
multiple alias to its IP. If we assign it a name alias without ".", i.e.
rptsrv, we don't get prompted for inputting user name and password for
windows identification. But if we assign a name alias with ".", i.e. rpt.srv,
then we get prompted.

We check the IIS configuration of the virtual directory "Reports" and
"ReportServer", the Authenticated access of Directory Security set to
Integrated Windows authentication and Anonymous access is disabled. These are
default setting after installing Reporting Services.

We also check the file web.config in these two websites. The related
configuration of "Reports" and "ReportServer" as following:

<system.web>
    <authentication mode="Windows"/>
    <identity impersonate="true"/>
    <securityPolicy>
        <trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
    </securityPolicy>
    <trust level="RosettaMgr" originUrl=""/>
</system.web>

<system.web>
    <authentication mode="Windows" />
    <identity impersonate="true" />
    <securityPolicy>
        <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
     </securityPolicy>
    <trust level="RosettaSrv" originUrl="" />
</system.web>

Could anybody help me to figure out what causes the problem and how to fix
it?

Thanks in advance.

Reply to this Message

Fabian - 17 Mar 2005 20:49 GMT

We prefer to use a name alias with ".", but we don't want the prompt for
windows identification when logging in. How can we fix it?

Thanks.

> We set up a server running SQL Server 2000 Reporting Services. We map
> multiple alias to its IP. If we assign it a name alias without ".", i.e.
[quoted text clipped - 32 lines]
>
> Thanks in advance.

Reply to this Message

whisky toting scotsman - 18 Mar 2005 20:13 GMT

Hi fabian

I had a similar problem when we were accessing our report server from remote
sites through our proxy.

Basically I had setup a c-name in the dns but didn't realise that in one of
the config files it actually stores the real name of the server so when you
came through the proxy this redirection in background was casuing
authentication to fail and password boxes to be asked for sometimes when they
shoudn't have been.

I think it was the rsconfig file but I can't access the server to check at
the moment.

hth

regards

David

> We prefer to use a name alias with ".", but we don't want the prompt for
> windows identification when logging in. How can we fix it?
[quoted text clipped - 37 lines]
> >
> > Thanks in advance.

Reply to this Message

Rajesh - 31 Mar 2005 20:31 GMT

Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer:

open the web.config file.
Under appSettings tag change url path like:

        <add key="ReportServer"
value="http://ApplicationServerName.YOurCompanyName.com/ReportServer"></add>
        <add key="ReportServerExternalUrl"
value="http://ApplicationServerName.YOurCompanyName.com/ReportServer"></add>

Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager:

Open RSWebApplication.config:

Under Configuration tag:

    <UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>

        <ReportServerUrl>http://ApplicationServerName.YOurCompanyName.com/ReportServer</ReportServerUrl>
    </UI>

I had the same issue.

Im assuming that you are using Form Authentication Code as in:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/uf
airs.asp

Good luck!
Rajesh

> We prefer to use a name alias with ".", but we don't want the prompt for
> windows identification when logging in. How can we fix it?
[quoted text clipped - 37 lines]
> >
> > Thanks in advance.

Reply to this Message