| Author |
Topic |
|
b.lammens
Starting Member
6 Posts |
 Posted - 2007-12-03 : 09:28:04
|
| I can't deploy reports from VS2005 anymore (Reporting Services). Before, this did work well.When I try to deploy, a popup-windows appears asking for a "Reporting Services Login" ( a username and password ). I have no idea which username/password I have to enter ( I tried with my domain username/password). For each answer, the popup box reappears again. There are no error messages.The ReportServer runs on IIS 5.1 with Integrated Windows Authentication checked. (ReportServer > Properties > Directory Security).SQL server 2005 (SP2), Reporting sevices and VS2005 are running on the same machine, that receives the automatic updates from Microsoft.In SQL Server 2005 Surface Area Configuration, when I try to select Windows Integrated Security under Reporting Services, I get a "request failed .../ Access Denied (SQLSAC). Can anyone help me with this ? As I said : it used to work before ( 4 months ago).b.lammens |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-03 : 11:19:39
|
| Have you looked at "Reporting Services Configuration">>"Windows Service Identity". How is this setup?You can also look if integration is still checked in IIS. I have default setup therefore I would go to IIS>>Reports>>Properties>>Directory Security>>Edit>> Integrated Windows Authentication (checkbox should be checked)Also for Reports Server .. IIS>>ReportServer>>Properties>>Directory Security>>Edit>> Integrated Windows Authentication (checkbox should be checked) |
 |
|
|
b.lammens
Starting Member
6 Posts |
Posted - 2007-12-06 : 05:58:50
|
| In IIS : Integrated Windows authentication is checked for ReportServer and for Reports.In Report Server Configuration : the Windows Account is checked. It is the same as the Service Account ( a Windows domain user).b.lammens |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-06 : 09:15:53
|
| If you are using the Windows Account in Reporting Services Configuration did the password get changed recently and this password have not been reset in Report Services Configuration?Can you get into Report Manager using IE? or does this give you an error too? |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-06 : 09:19:40
|
Have you tried saving the rdl to your pc and uploading it from report Manager?Once you have done that all you need to do is link the rdl file to the correct datasource (This too can be done from report Manager)Edit: Oh and another thing - is it possible that your windows password has expired today?Duane.  |
|
|
|
b.lammens
Starting Member
6 Posts |
Posted - 2007-12-06 : 10:30:50
|
| I can't connect via my browser to the ReportServer with my Windows Login. Only as an unauthenticated user I get a connection butof course no administration rights.My password did not change nor expire.In the mean time, I changed ( via Report Server Configuration) the Windows Service Identity. When I want to reset it to my Windows User account, I now get the message that there is a problem with the Encryption Key Backup.The sentence : "ReportingServicesService!ResourceUtilities ..:INFO: Evaluation Copy 0 days left" in the log file of ReportServerService worries me. Maybe, this has something to do with my problems ?b.lammens |
|
|
|
tm
Posting Yak Master
160 Posts |
|
|
b.lammens
Starting Member
6 Posts |
Posted - 2007-12-07 : 03:57:17
|
quote:
Originally posted by tm
Found this on one of the forums (Add line authentication mode="Windows" in Report server Web.confing file) ..Refer to:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164895&SiteID=1...<pages validateRequest="false" /> <authentication mode="Windows" /> <identity impersonate="true" />
I verified this. The web.config is configured with authentication mode ="Windows"So, this is not the cause of my problems.b.lammens |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-07 : 09:50:24
|
| What error message do you get when you try to connect to Reporting Services using IE?Since you mentioned windows updates have you checked IIS>>Web Site>>ASP.NET version is using 2.0.5727 (version 2).Another question is when you initially installed MS SQL started with SP2 and installed SSRS with SP2 and did not install SQL SP2 after you had installed SSRS?If it will help I can send you my Web.Config file for you to check if there is anything that you may find different as I have SSRS running on my local machine. |
|
|
|
munipalle
Starting Member
2 Posts |
Posted - 2007-12-07 : 14:40:20
|
| Try thisGo to IIS>>Reports>>Properties>>Directory Security>>Edit>> and see if the "Enable anonymous access" is checked if not check it and the same for ReportServer also.Of course you have to consider the security vulnerabilities of doing the above so you might have to contact you admin and make the changes.Praveen |
|
|
|
b.lammens
Starting Member
6 Posts |
Posted - 2007-12-10 : 05:50:06
|
quote:
Originally posted by munipalle
Try thisGo to IIS>>Reports>>Properties>>Directory Security>>Edit>> and see if the "Enable anonymous access" is checked if not check it and the same for ReportServer also.Of course you have to consider the security vulnerabilities of doing the above so you might have to contact you admin and make the changes.Praveen
It is true that I can attain ReportServer via my browser when Anonymous Access is checked - but I can't deploy when this is checked.b.lammens |
|
|
|
b.lammens
Starting Member
6 Posts |
Posted - 2007-12-10 : 05:57:43
|
quote:
Originally posted by tm
What error message do you get when you try to connect to Reporting Services using IE?Since you mentioned windows updates have you checked IIS>>Web Site>>ASP.NET version is using 2.0.5727 (version 2).Another question is when you initially installed MS SQL started with SP2 and installed SSRS with SP2 and did not install SQL SP2 after you had installed SSRS?If it will help I can send you my Web.Config file for you to check if there is anything that you may find different as I have SSRS running on my local machine.
I don't remember when I installed SP2. I think it was installed after the installation of SQL Server and SSRS.I do use the ASP.NET version 2.0.5727What annoys me most is that it used to work, but anyway I would be glad to compare the config file. I suspect that the fact that it does not work anymore has to do with changed security settings, installed via automatic updates.If anonymous acces is checked, I now get the error : Keyset does not exist. This error came forth after changing for the x-th time the Reporting Services Configuration. This problem has for the rest nothing to do with the fact that I don't have the right to access RSS.As a Windows domain user and anonymous access unchecked : I get the error Internet cannot display the webpage.b.lammens |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-10 : 09:27:22
|
| If you installed SQL SP2 after you already installed SSRS then you will have to uninstall SSRS and reinstall.This was what I had to do as SSRS database version is does not match due to SQL SP2.I looked for an easier way to adjust the SSRS database version but I could not find a solution and had to uninstall/reinstall SSRS. |
|
|
|
munipalle
Starting Member
2 Posts |
Posted - 2007-12-10 : 10:49:01
|
quote:
Originally posted by b.lammens
In IIS : Integrated Windows authentication is checked for ReportServer and for Reports.In Report Server Configuration : the Windows Account is checked. It is the same as the Service Account ( a Windows domain user).b.lammens
Do you still have the windows domain user as the Windows Service Identity account under Reporting Services Configuration? If so, does this user have "Publish" permissions to the Report server?PraveenPraveen |
|
|
|
|
Deploy reports from VS2005 : authorisation