March 5, 2009 at 6:48 am
I've installed SQL Server 2005 DE 64-bit with all features on Vista Ultimate 64-bit. I'm trying to get to the Report Manager interface via IE, and initially, 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.
Having done that, I now get the following when I navigate to the /reportserver/ url:
a red circle with a white X in it, followed by "Error", and then a line with:
"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version."
Then there's a link to "Home", which is the same page (/Reports/Pages/Folder.aspx).
I haven't attempted to deploy any reports, but I figured I'd at least see the Report Manager interface. Can someone tell me what I haven't done yet, or have missed?
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 7:02 am
You need to configure IIS7 in IIS6 compatibility mode and make sure you are run aspnet_regiis in your .NET folder in your C drive. And most important VS2005 is not compatible with Vista so you need to disable UAC and run everything with admin permissions. Check below for IIS 7 configurations and permissions in Vista with VS2005.
Kind regards,
Gift Peddie
March 5, 2009 at 7:24 am
See the attached JPG file and let me know if that's a correct configuration:
Steve
(aka smunson)
:):):)
Gift Peddie (3/5/2009)
You need to configure IIS7 in IIS6 compatibility mode and make sure you are run aspnet_regiis in your .NET folder in your C drive. And most important VS2005 is not compatible with Vista so you need to disable UAC and run everything with admin permissions. Check below for IIS 7 configurations and permissions in Vista with VS2005.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 7:25 am
Oh, almost forgot. I'm using VS2008, not VS2005, and disabling UAC was the FIRST thing I did after installing Vista.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 7:29 am
The short answer is no because you don't even have internet access enabled so make sure you enable only what is enabled in that link.
Kind regards,
Gift Peddie
March 5, 2009 at 7:31 am
You cannot develop SQL Server 2005 Reports with VS2008 because SQL Server 2005 can only use VS2005.
So you need to install SQL Server 2008 to use VS2008 for Reports development.
Kind regards,
Gift Peddie
March 5, 2009 at 8:24 am
I do have the necessary items configured based on your link, but I still get the error. Here's the expanded configuration items list based on your link:
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 8:31 am
Again no you did not I cannot understand why you cannot print out the features to enable and do exactly what is in that link. That link is the configuration by the owners of Asp.net in Microsoft. It is so simple why are you not using it as is? For example CGI is for PHP developers not Asp.net required tool like SSRS 2005.
And you also need to run aspnet_regiis in your c drive after you have configured IIS.
Kind regards,
Gift Peddie
March 5, 2009 at 9:16 am
Gift,
First, I am configuring IIS for MORE than just Reporting Services. If that's all I wanted to do was RS, then I would gladly minimize my configuration. However, I discovered that I missed the part of your post about executing a program in my .NET folder.
Which one of these regiis files do I run ?
================================================================
Text-Screen-Shot from DOS command prompt
================================================================
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
K:\>C:
C:\>dir aspnet_regiis*.* /s /p
Volume in drive C has no label.
Volume Serial Number is 3C69-A8C3
Directory of C:\Windows\Microsoft.NET\Framework\v2.0.50727
07/27/2008 01:03 PM 33,288 aspnet_regiis.exe
1 File(s) 33,288 bytes
Directory of C:\Windows\Microsoft.NET\Framework64\v2.0.50727
07/27/2008 01:01 PM 48,136 aspnet_regiis.exe
1 File(s) 48,136 bytes
================================================================
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 9:21 am
Two other questions... What does the aspnet_regiis program do, and why does it need to run?
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 9:39 am
aspnet_regiis is the utility that takes care of Asp.net runtime permission and other things you may be using in your Asp.net application, check below for the docs from Microsoft including where the x64 version is located in a 64bits box.
http://msdn.microsoft.com/en-us/library/k6h9cz8h.aspx
And no that configuration is not just for SSRS it is also for Asp.net, the Asp.net team now own IIS 7 within Microsoft so if you need to enable other features I am not sure you can develop with their runtime which they protect as much as possible.
Good luck.
Kind regards,
Gift Peddie
March 5, 2009 at 9:41 am
I tried to run aspnet_regiis.exe and found it does nothing without options being specified, and when I ran it with -lv, it came back with the following info:
================================================================
C:\Windows\Microsoft.NET\Framework64\v2.0.50727>aspnet_regiis.exe -lv
2.0.50727.0 C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_i
sapi.dll
C:\Windows\Microsoft.NET\Framework64\v2.0.50727>
================================================================
I installed the .NET framework pieces long before I installed SQL Server or much of anything else. I have ASP.NET available to me, so I'm not sure where the grief is. However, I did create an additional website which uses .NET 3.5, so I'm not sure if that matters. Any/all guidance appreciated.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 9:49 am
.NET 3.5 is not relevant because Asp.net 3.5 still builds to 2.0 because the CLR is still 2.0 and VS2008 adds the relevant .NET 3.5 references for you. And you need to use either enable which is what most people use or i which uses the metabase. What you are running is not correct.
Kind regards,
Gift Peddie
March 5, 2009 at 10:34 am
I still have the same problem, despite running the aspnet_regiis -enable, which didn't even appear to do anything except regurgitate the list of options, and despite then trying -i, which said it installed it, and then again trying -enable, which agains just spits out the options.
I'm at a loss as to what to do next, and I'm not even sure I've properly understood exactly what I'm trying to accomplish, beyond getting RS to function. Anyone care to either make/receive a phone call? I can PM my number or vice versa.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 10:51 am
, 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.
Kind regards,
Gift Peddie
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply