prompt username/password when using http://localhost:8080/reports

Question

Post reply

prompt username/password when using http://localhost:8080/reports

meikangw

Old Hand

Points: 307
More actions
August 10, 2009 at 8:07 pm

#224730

Hi All,
Today I installed SQL Server 2008 RS on Windows XP SP3, this is the URL.
http://localhost:8080/reports
Whenever I access the above URL it prompts for username/password, does anyone know how to disable or what username/password to enter? I used Admin username/password but it did not work. Basically I can't access the Report Manager. 🙁
When I used SSRS 2005 I could go to IIS to disable the username/password but I could not find anything in RSCM nor in SSMS.
I don't have AD, just local accounts,please help and thanks in advance!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Chirag Prajapati SSC Eights! Points: 914 More actions · Answer 1

Easy and simplest way is make you user as Administrator on that machine.

and other way is use impersonation.

That is login with Administrator and assign your user Content Manager rights on the report Manager UI with URL interface.

Charles Hearn SSCrazy Points: 2680 More actions · Answer 2

Typically you'll need to publish to ReportServer ($ instance name if not on the default instance) and not Reports. To verify the URL open the Reporting Services Configuration manager and check the name for the Report Server Virtual Directory. Also verify that you have the website configured to use IIS configured to use "Integrated Windows Authentication" instead of anonymous access.

unknown_sql Say Hey Kid Points: 661 More actions · Answer 3

In IE, try adding your server to the list of Local Intranet sites. To do this, go to Tools, Internet Options. Then click on the Security tab. Click on Local Intranet, then click on the Sites box. Next, click on the Advanced box, then enter the URL for your server (i.e. http://servername) and click Add. Close out of all windows, Exit out of IE, go back in and re-try the link to your SSRS.

meikangw Old Hand Points: 307 More actions · Answer 4

Thanks, unknown_sql. It worked. Now I can access Report Manager and do other configurations. Thanks once again 🙂

jampa_satish Mr or Mrs. 500 Points: 546 More actions · Answer 5

jampa_satish

Mr or Mrs. 500

Points: 546

September 12, 2009 at 11:56 am

#1052727

Thanks a lot ppl.

vvtt9911 SSC Rookie Points: 27 More actions · Answer 6

Open internet Explorer > Tools > Internet options > Security > Select “Internet” > Click on “Custom Level” button below >(Security settings – internet zone opens, scroll down, check for “User Authentication – Logon” under this, select option “Automatic Logon with Current User Name and Password” and then click ok, ok.

Now close & reopen the internet Explorer and now try, this time Authentication required window will not be shown and it opens the required pages on any browser.

(This setting worked for me in internet Explorer 7)