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!
Related Posts
- SQL Server 2008 – Database Diagram Support
- Microsoft Is on The Run Again
- Windows 7 to offer XP downgrade option
- How to: Read Kindle books while charging on Vista nd Windows 7
- Java Class Paths and other troubles
Tags: Express, installation, MSSQL Server 2008, Server, SQL, Visual Studio
This page called Unblock Websites also has got some decent information on the topic.
Yep, seems relevant in some ways. Thanks for the link.
Certainly In hand, simply the most suitable option on the net for those expenditure . In which put together exceptional with a good total price. i Unquestionably Advocate that it !
Howdy, I think that you are able to help me. I have a Microsoft SQL .ldf and .mdf file which I have to restore. Any opinions on how to achieve this? Thanks
Hey, hey. I have not coded much since that time, but mdf and ldf are not backup files. They are actually database files, which means that you just have to connect them to your solution. Here I found a good answer, let me know if it helps you, too (As it saves some typing):
http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/