2005SQL on Windows 7 (again!)
-
I've been trying to get this working and have read just about every post available on the topic.
I've got Win7 Ultimate on a 64 bit platform (non-domainmember) that has SQL2008 Enterprise running on it successfully. I'm now trying to add SQL2005 to the box for development.
I'm seeing the same issues reported by several but the posted remedies are not working for me. The problem I am trying to fix is that during installation the "Select Components" screen greys out all the pieces of sql2005 as choices. I am assuming this is the result of the warnings I get during the system evaluation in the previous step (is this correct?).
The 2005 installer results in two warnings:
1) (no surprise on this one)
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
2) (this is widely reported as well and the one I can NOT resolve)
- 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've read several postings about the remedy and have set 32bit compatibility in the application pools, set several required compatibility settings in the "programs and features" control panel for IIS. I've even tried running aspnet_regiis -ir for the 32 bit v2.0 framework even though several postings caution against doing that for IIS7.
Can anyone confirm the following two questions?
1) Are my greyed out installation options because of the warnings?
2) How can I fix the ASP.Net Version Registration Requirement?
I'm new to IIS 7 so be gentle (complete) on any suggested config changes please?
-
Enterprise edition is not supported on non-server operating systems. It's only supported when running on Server 2003/2008/2008 R2. Not Windows 7.
Why are you using Enterprise edition? If it's for development, then consider developer edition, not the least because of the licencing cost of using Enterprise edition. If it's for production usage, why a desktop OS?
SQL 2005 developer edition does install successfully on Win 7 Ultimate x64. I did it yesterday. It's usually recommended that the versions of SQL be installed in release order (2005 first then 2008). Not sure if that's the cause of your problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
1) Are my greyed out installation options because of the warnings?
2) How can I fix the ASP.Net Version Registration Requirement?
To add to the previous post you need the developer edition and not the Enterprise edition and Windows 7 comes with IIS 7.5 not IIS 7, the greyed out options are related to IIS 7.5 components enabling for SSRS 2005 which require IIS 7.5 to be in IIS 6 compatibility mode. So look for the SQL Server 2005 developer edition and make sure IIS 7.5 is in IIS 6 compatibility mode because if it is not right Windows 7 will leave SSRS disabled in your installer. One more thing your can ignore most installation related warnings but greyed out options most be addressed because you cannot install that feature without the dependent component.
Kind regards,
Gift Peddie -
Depending on your needs (e.g. Reporting Services, etc) microsoft offers two version of SQL Express 2005 (32 and 64 bit) on their website. SQLEXPR.EXE is the 64 bit version and SQLEXPR32.EXE is 32 bit.
Hope this helps - Mark
-
mmathews 87112 (1/2/2010)
Depending on your needs (e.g. Reporting Services, etc) microsoft offers two version of SQL Express 2005 (32 and 64 bit) on their website. SQLEXPR.EXE is the 64 bit version and SQLEXPR32.EXE is 32 bit.Hope this helps - Mark
That is not correct SQL Server 2005 Express only comes in x86 which is 32bits however there is x86 binaries for x64, it is SQL Server 2008 Express that also comes in x64. Check below for SQL Server Express version. I think the OP needs to get the developer edition if SSRS is needed.
http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
Kind regards,
Gift Peddie -
Gents, thanks for the info. Gilamonster was the first with the suscinct answer. The reason for enterprise? Only because it was available in the MSDN subscription and I thought I'd go for the max thinking I might need some features for prototyping. Why windows 7? It's what I have at home and I often spend personal time on work projects. Yeah, sad story...
I'll try loading 2005 developer edition (also available in my MSDN subscription). If any other issues pop up I'll be sure to come back here. Good info from all of you.
Thankee,
JWiley
-
Developer edition is the full enterprise edition features with a non-production licence, so you lose nothing in the way of features by using it.
If you still have problems, some screenshots may help in identifying the cause of the problem.
p.s. Most of the people who answered your question aren't 'gents'. Gift and I are women. 😉 (Ignore the picture. I'm a starwars fan)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
If you follow Gail advice on installing developer edition instead of the enterprise edition, you problem should be solved.
-
Hi everyone!
I'm new in this forum!
I have a similar problem here.
I am using SQL 2005 standard in a windows 7 PRO. I can't get pass the System Configuration Check window. Everything is shown as "Success" except the ASP .NET Version Registration Requirement. I have perform several solutions listed elsewhere in the web but can't get this solve.
The main reason of this is for Reporting Services to be installed in my work stations so I can
create reports from our SQL 2005 database located in a 2003 server. (I check that server but does not have RS installed)
Reading from your comments, I see that some version of SQL are not recommended to be installed on a windows 7 machine; would this be the case for me?
Any suggestions?
Thank you
-
Why standard edition? Unless you have an MSDN subscription, you will have to pay licensing on that and Standard edition isn't cheap.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Thank you for responding so quickly! 🙂
I had only one left license left so I thought to use it. What other version I can use that I don't have to pay for license if I only need to create reports of my database?
As you can see, I am new on the SQL world and I am trying to create reports ultimately from two
different SQL databases. They are each located in separate servers and I want to have the SR somewhere else to take the load and ISS service away from the DATABASE servers. that make sense, right?
-
fflores 21886 (8/31/2011)
Thank you for responding so quickly! 🙂I had only one left license left so I thought to use it. What other version I can use that I don't have to pay for license if I only need to create reports of my database?
Developer edition is for development. It's not free, but it's very cheap
As you can see, I am new on the SQL world and I am trying to create reports ultimately from two
different SQL databases. They are each located in separate servers and I want to have the SR somewhere else to take the load and ISS service away from the DATABASE servers. that make sense, right?
Yes, but that separate location needs to be a server, running server OS, fully licensed SQL (there's your last Standard edition licence), not on a workstation.
Workstations are for development, not to act like servers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
I agree with Gail. Also Developer Edition has all the features of Enterprise Edition.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply