July 22, 2010 at 12:28 pm
System specs
Windows 7 Home Premium x64
SQL server 2005 Express with Advanced Utilities
I have downloaded SQL Server 2005 Express Tool Kit which contains the option to install BIS. On the first time running this, I got a folder in the start menu to appear for BIS under the SQL Server 2005 folder. I tried to click on it and it said that it cannot find devenv.exe.
Also I got some warnings on the initial install of BIS for IIS and .NET framework:
- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
- ASP.Net Version Registration Requirement (Warning)
Messages
ASP.Net Version Registration Requirement
Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
I have tried fooling around with running the %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regIIS -i which is the version I have installed in order to get asp.net to register with IIS and the command works, but the warning is still there. I've tried so many different fixes that I'm completely lost now. Has anyone ever had this problem, know of any solutions?
July 22, 2010 at 12:37 pm
If you checked to install SSRS in SQL 2005, you need to have IIS installed and need to enable ASP.NET via control panel (add/remove apps). Sounds like this is the problem you are having.
You can also just installing SQL, but without SSRS.
Why don't you just download SQL 2008 and install that? It doesn't require IIS any longer.
July 22, 2010 at 12:48 pm
I am using 2005 variants because that is what everyone else on the project is using, the database is being managed with Managment Studio and SQL Server 2005 on a local server running a 2005 R2 version of Windows Server.
I have windows 7, so I go to control panel > add remove programs > Turn off/on features and IIS is checked, so that should mean it is installed. Is there a separate step involved in turning it on?
As for ASP.net I can't even find it in add/remove programs or in turn on/off features. Yet I downloaded a tool from the internet to detect what versions are installed and it says I have:
.Net Framework 2.0 SP2
.Net Framework 3.0
.Net Framework 3.5 SP1
July 22, 2010 at 2:09 pm
Ok, finally after two days of continually deleting and installing things I found out how to make it work, it definitely depends on the order in which things are installed. After deleting all of these, I installed in this order:
1.) .NET Framework
2.) IIS 7
3.) SQL Server 2005 Express with Advanced Utilities
4.) SQL Server 2005 Express Tool Kit
Also, I installed every possible feature of IIS 7 ha, probably bad practise but its running now at least.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply