Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 on Windows 7 / Windows server 2008 r2

SQL Server 2008 on Windows 7 / Windows server 2008 r2

  • Comments 2
  • Likes

I haven’t had many problems myself when installing SQL Server 2008 on either Windows 7 or Windows server 2008 r2 but there are a few things to watch out for which I have shamelessly lifted from KB955725:

You should install SQL Server 2008 sp1 as this is the supported verion on htese new operating systems (they included fixes specific to a couple of issues including the fact that Windows 7 doesn’t use the Required Kerberos property to determine if Kerberos is enabled for a network name resource). 

.Net Framework. You’re going to need the .Net framework 3.5 sp1. If it isn’t there then the SQL installer will do it for you in Windows 7 but it will then restart the installation once this has been done which may look a little odd and confuse you.  In Windows Server 2008r2 you should add the application role using server manager, servermangercmd.exe or the new Deployment Imaging servicing & management tool (DISM) prio to installing SQL Server.



I mention this because I know it’s easy to be swamped by KB notifications, a lot of you are trying these new operating systems, and because the SQL Server install is very picky when it runs.  This is not a moan, if it installs properly it’s working and you can rely on it which is what databases are all about.

  • have you tried deploying reports to reporting services on a win7 box to a local instance of reporting services. It fails in my enviroment even when running ie and Visual studio with priveledges elevated to run as administrator. I tried adding domain account to content administrators but it still fails ...

  • Colin - a job for tomorrow, when I get my paws on the RTM (you get your chance on 6th August when it'll be on TechNet.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment