Microsoft SQL Server 2008 (Express) on Windows 7
As I am working on my senior project in CS for a while now, I had to install MS SQL Server as my DBMS. I have selected it as it allows me to work iwht LINQ and avoid the stored procedures and stuff. Still, when I began installing the server I did not know that I will experience a lot of different problem with it when installing on Windows 7. Now, when not only the RTM is on, but the official launch of W7 was a few days ago, I suppose that some of these problems will be avoided, yet I will share the way that I installed the servr, in order to save some troubles to the ones, that may have to cope with the same problems like me. Here is a brief list of steps to be done if you want to have VS2008 + SQL Server 2008 Express with Management Tools:
- Install Visual Studio 2008 SP1. remove the tick of SQL server 2005 express (you do not need it).
- Install Microsoft SQL Server 2008 Management Studio Express
- Install SQL Server 2008 Service Pack 1
- Install Microsoft SQL Server 2008 Express
You may have to install Powershell in order to proceed with SQL Server’s installation, but this is described on the page of step 2. After the installation, do not forget to allow port 1335 through your firewall software (even if you use windows firewall).
If you need assitance – let me know!