October 23, 2007 at 4:13 pm
I was having problems with Sql 2005 Sp1,sp2 versions were conflecting.i got that figured out but now in reporting services Report executes in Designer but when i try to deploy i get a login screen.Asking for a username and password.i have spent a lot of time on this but could not find an answer your are my last resort.
When i 1st installed SQL 2005 the instance was Workstation\SQL2005Local
When i reinstalled i named the instance Workstation\SQL2005
And also when i try to open "http://localhost/Reportserver" i get a Page not found, http://localhost --- says Local host not found. my IIS is running.
kindly HELP 🙂
SR
October 23, 2007 at 10:31 pm
How did you setup security for the web service identity and reporting services database? It sounds like you are using windows credentials.
When you deploy a report it must add values to the reporting database inside the instance. It is probably asking you for a login and password because the account you are using does not have rights to make changes to the database.
Also, you should be trying to hit the reports virtual folder, like
You should look in IIS for the virtual directory reports and it may look like reports$instancename. If it does, you should try http://localhost/reports$instancename.
October 30, 2007 at 9:23 am
Thanks adam,
Your suggestions did set me in the right direction. I was having trouble with the instances, the frist time i installes SQL RS 2005 (did not name a instance) it was http://localhost/reports then the 2nd time around it was taking http://localhost/reports$SQL2005. so i just copied the .mdf file from my network drive and this time did not give any instances so its back to http://localhost/reports again.
Although now i have two databases for reporting services one is
1 a)ReportServer$SQL2005
b)ReportServer$SQL2005TempDB and
2 a)ReportServer
b)ReportServerTempDB (using the 2nd one)
=============================================
i had a couple of new questions
1) can i deleted?
a)ReportServer$SQL2005
b)ReportServer$SQL2005TempDB
2) Cannot delete Reports says i need to be a sysadmin.i get this erro!!
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login. Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
And it goes on.
Can someone help me with this please ... i logged in as admin on my local machine to do installation. Then i use my windowsNT login to do Reports.
October 30, 2007 at 1:03 pm
sr,
If I were you I would not just delete things but rather go to add/remove programs and uninstall unnecessary instances of reporting services.
I am not quite sure what you mean by can't delete reports? Are you trying to delete the virtual directory "Reports" or are you trying to delete reports that are on the report server? If you are trying to delete uploaded or saved reports, have you granted your nt login rights to do so?
Adam
October 31, 2007 at 8:31 am
thanks for replying adam,i really appriciate it.
yes you got me right. i am tring to do both.
First i want to delete the reports in the reporting services.This is were i get the ERROR (not a sysadmin cannot delete the reports).
In my SQL2005 i have four databases for reporting services ie
a)ReportServer$SQL2005
b)ReportServer$SQL2005TempDB and
c)ReportServer
d)ReportServerTempDB
i want to delete the first one (ReportServer$SQL2005 and ReportServer$SQL2005TempDB) cause i am not using them.
i was wondering if it would be ok to do so?
October 31, 2007 at 12:53 pm
Yes you can remove any of the reporting service instances at your leisure.
The reason your nt login cannot delete reports is because you have not given your login access to do so. You either have to be part of the sysadmin group or login to the report server and go to site management and create a group for users, add nt login to this group, and then give this group the delete ability.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply