Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Now I have login problems :)

Author  Topic 

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-02 : 14:25:16
I just set up a new test server and everything looks great. I can get to both the reportmanager and reportserver via (respectively):
http://reports2/TEST_Reports
http://reports2/TEST_ReportServer

Unfortunately when I try to publish to this I get a login dialog asking for credentials for Reporting Services Login. It displays http://reports2/TEST_ReportServer as the erver which it is getting from my Deploy Properties. In my production environment I do not get the login dialog. Compared the prperties of the 2 instances on Reporting Services as well as the IIS and they "appear" to be the same but obviously they are not.

Does anyone have an idea where I can look?

John

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-10-02 : 16:43:48
does your id have rights to publish the report?
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-03 : 20:55:36
Edited Reply: What/where exactly do you mean Do I have rights? Where would I verify?

I have the exact same group of builtin admin as my production environment. I also had my ID added manually on Folder Security with all rights and same error.

John
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-05 : 09:41:43
Resolved. Unfortunately I created a Configuration to deploy to and I had a typo:
http://reports2/TEST-ReportServer
Instead of
http://reports2/TEST_ReportServer

so it was trying to log into something that was never configured (and didn't exist) there for giving me the dialog box.

John
Go to Top of Page
   

- Advertisement -