| Groups | Blog | Home |
sql server reporting services : logon window
If You are using a shared datasource then rightclick on the datasource ->open In the credentials tab check what is the option selected it should be "Use Windows Authentication(integrated security)" If you have windows authentication for you Sql server. If the option selected in this tab is "Prompt for credentials" then the report promt for user credentials every time it launches. Incase u are not using shared datasource then u canget the above tab from the data tab of the reportdesigner and then browsing on the datasource dropdown. Leme know if this solves ur problem Thanks, siaj [quoted text, click to view] "Alex" wrote:
> Hi, > > Whenever I click on a report to open it, it asks me for my Windows user ID > and password. I am connected to my desktop using my domain account and > report server is installed on SQL Server (domain controller as well). > The report is using NT authentication method. > Does anybody know how can I get rid of the login information window? > > Thanks > >
Make sure that your IE and IIS settings are correct. Within IE go to tools
internet options and then security. You will want to make sure the RS web site is in your local intranet zone. Once it is there, make sure that the "User Authentication" section of the settings are set to "Automatic logon with current username and password." This tells IE to send the username and password to the server. On IIS make sure that "Integrated Windows authentication" is checked for the web site and uncheck the remaining boxes. [quoted text, click to view] "Alex" wrote:
> Hi, > > Whenever I click on a report to open it, it asks me for my Windows user ID > and password. I am connected to my desktop using my domain account and > report server is installed on SQL Server (domain controller as well). > The report is using NT authentication method. > Does anybody know how can I get rid of the login information window? > > Thanks > >
Hi,
Whenever I click on a report to open it, it asks me for my Windows user ID and password. I am connected to my desktop using my domain account and report server is installed on SQL Server (domain controller as well). The report is using NT authentication method. Does anybody know how can I get rid of the login information window? Thanks
Thanks. This one solved my problem.
[quoted text, click to view] "MAGrimsley" <MAGrimsley@discussions.microsoft.com> wrote in message news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@microsoft.com... > Make sure that your IE and IIS settings are correct. Within IE go to tools > internet options and then security. You will want to make sure the RS web > site is in your local intranet zone. Once it is there, make sure that the > "User Authentication" section of the settings are set to "Automatic logon > with current username and password." This tells IE to send the username and > password to the server. On IIS make sure that "Integrated Windows > authentication" is checked for the web site and uncheck the remaining boxes. > > > "Alex" wrote: > > > Hi, > > > > Whenever I click on a report to open it, it asks me for my Windows user ID > > and password. I am connected to my desktop using my domain account and > > report server is installed on SQL Server (domain controller as well). > > The report is using NT authentication method. > > Does anybody know how can I get rid of the login information window? > > > > Thanks > > > > > >
I have the same problem... and tried your suggestions with no luck.
Administrators and users can browse the Reports application. Administrators can view the reports, but users get an authentication prompt. Both the Reports and ReportServer application use Windows Integrated Auth and have Anonymous disabled. What would the difference be if the user can view Reports but not ReportServer? (I tried https://{server}/ReportServer and still got the prompt) There's got to be some difference between [quoted text, click to view] "Alex" wrote:
> Thanks. This one solved my problem. > > "MAGrimsley" <MAGrimsley@discussions.microsoft.com> wrote in message > news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@microsoft.com... > > Make sure that your IE and IIS settings are correct. Within IE go to tools > > internet options and then security. You will want to make sure the RS web > > site is in your local intranet zone. Once it is there, make sure that the > > "User Authentication" section of the settings are set to "Automatic logon > > with current username and password." This tells IE to send the username > and > > password to the server. On IIS make sure that "Integrated Windows > > authentication" is checked for the web site and uncheck the remaining > boxes. > > > > > > "Alex" wrote: > > > > > Hi, > > > > > > Whenever I click on a report to open it, it asks me for my Windows user > ID > > > and password. I am connected to my desktop using my domain account and > > > report server is installed on SQL Server (domain controller as well). > > > The report is using NT authentication method. > > > Does anybody know how can I get rid of the login information window? > > > > > > Thanks > > > > > > > > > > >
I had to set up the user/group in question with permissions to Reports and
ReportServer in IIS. [quoted text, click to view] "Peter Capazzi" wrote:
> I have the same problem... and tried your suggestions with no luck. > > Administrators and users can browse the Reports application. Administrators > can view the reports, but users get an authentication prompt. > > Both the Reports and ReportServer application use Windows Integrated Auth > and have Anonymous disabled. > > What would the difference be if the user can view Reports but not > ReportServer? (I tried https://{server}/ReportServer and still got the prompt) > > There's got to be some difference between > "Alex" wrote: > > > Thanks. This one solved my problem. > > > > "MAGrimsley" <MAGrimsley@discussions.microsoft.com> wrote in message > > news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@microsoft.com... > > > Make sure that your IE and IIS settings are correct. Within IE go to tools > > > internet options and then security. You will want to make sure the RS web > > > site is in your local intranet zone. Once it is there, make sure that the > > > "User Authentication" section of the settings are set to "Automatic logon > > > with current username and password." This tells IE to send the username > > and > > > password to the server. On IIS make sure that "Integrated Windows > > > authentication" is checked for the web site and uncheck the remaining > > boxes. > > > > > > > > > "Alex" wrote: > > > > > > > Hi, > > > > > > > > Whenever I click on a report to open it, it asks me for my Windows user > > ID > > > > and password. I am connected to my desktop using my domain account and > > > > report server is installed on SQL Server (domain controller as well). > > > > The report is using NT authentication method. > > > > Does anybody know how can I get rid of the login information window? > > > > > > > > Thanks > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |