March 5, 2009 at 11:24 am
Can I get a step-by-step for how to do that clr debugger thing? By the way, I just realized that when I run BIDS, it's actually VS2005, despite my install of VS2008, so both of those products are on my machine. The phone call offer still stands as well...
Steve
(aka smunson)
:):):)
Gift Peddie (3/5/2009)
, I got a 403 error, and following MS's help for that, I was able to determine that I needed to configure IIS to allow scripting through the "Handler Mapping" feature permissions
IIS error 403 is permissions problem that is the reason I gave you aspnet_regiis, I also think you have enabled all the features you think you need instead of those in that link so you need to decide if you want to develop reports with SSRS 2005 or do just Asp.net because SSRS 2005 comes with fixed requirements.
You also the option to run the clr debugger with the Asp.net runtime and it will show you all the permissions you need to add.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 11:52 am
Here is how to use the CLR debugger with Asp.net and the second link is a thread where the user did not do many basic things so we talked for a long time you need to make sure SSRS is your default site and enable all that is needed permissions included.
http://support.microsoft.com/kb/893657
http://www.sqlservercentral.com/Forums/Topic650186-147-1.aspx
Kind regards,
Gift Peddie
March 6, 2009 at 9:47 am
All,
Ok, let's solve one problem at a time. That CLR debugger isn't going to help if I can't even connect to an RS instance using SSMS. I think my problem may go deeper than what a debugger is going to help with, and my guess is, understanding the instructions for that requires knowledge I just don't have.
I really can't go back and uninstall anything just yet, as the machine I'm working with is now my main PC, and thus I can't easily just "Start Over". Having read that other thread
Gift pointed me to, I was lost fairly quickly because there are a LOT of gaps in my knowledge of IIS, and I have Vista's IIS 7 with the IIS 6 compatibility, so it appears that anything with instructions based on IIS 6 is not particularly useful, as I can't translate between the two.
The specific problem I'd like to conquer 1st is that attempting to connect to Reporting Services using SSMS fails with an http 404 not found error. I looked in Windows Explorer, and I can't see the Folder.aspx file in the Pages subfolder of the ReportServer folder that IIS says is the root folder for that webpage. I also know that my ID is both an Administrator on the machine and I specifically added my ID with Full Control to the permissions for the ReportServer folder (and subfolders), so I can't see there being a permissions issue from that perspective.
If there's anyone out there with a solid IIS 7 background that can spend a few minutes on a phone call, I'll gladly send my number in a private message, or I can call a number supplied to me that way. I'd like to get on the phone because then I can probably get an answer I can understand a lot quicker, as I have so many gaps in my IIS knowledge, that I may not be able to understand many of the written answers, and could at least ask relevant questions quickly. Thanks in advance for any/all assistance.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 6, 2009 at 1:04 pm
You need to make sure you have SQL Server 2005 SP2 if not SP3 installed, here is another visual configuration. And no you cannot enable what you want because what runs through Asp.net is defined by Microsoft.
Kind regards,
Gift Peddie
March 6, 2009 at 3:46 pm
After much wringing of hands and some additional web searching, I found that the error I was getting just trying to connect to RS was a configuration issue, detailed at the following URL:
Making the suggested fix to the config file resolves the problem of connecting to the Report Server, and I was then able to deploy my first report using BIDS. Problem solved!
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply