Enabling SQL Server 2008 (R2) access over Network

First: enable SQL Server itself to be accessed over the network

  1. Open SQL Server Configuration Manager
  2. Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER
  3. Doubleclick TCP/IP
  4. Set Enabled to Yes
Open SQL Server Configuration Manager
Open SQL Server Configuration Manager

Secondly: change the Windows Firewall to allow incoming connections on the TCP port of SQL Server

  1. Open Windows Firewall with Advanced Security
  2. Click on New Rule
Open Windows Firewall with Advanced Security
Open Windows Firewall with Advanced Security

Now in the wizard you set the type of the rule to Port.

Choose TCP or UDP port
Choose TCP or UDP port

Hit Next.

On the second window you set the Specific local ports to 1433:

Set the TCP port
Set the TCP port

Hit Next.

Allow the connection.

Allow the connection
Allow the connection

Hit Next.

Now enable the checkboxes you want to. I set mine only to Private. Because I only need to access the SQL on my laptop at home:

When does this rule apply?
When does this rule apply?

Hit Next.

Set a name for the rule
Set a name for the rule

Hit Finish and you’re ready to develop SQL over network 🙂

Web Platform Installer Detection bug

I’ve been using Microsoft Web Platform Installer for a while. It’s a great tool to install everything you need for web development, it installs SQL Server for you without bugging you with difficult questions. (on a side note: if you want to move your SQL DATA folder look at this post).

But there is a small problem when you launch the Web Platform Installer . It suggests you install Microsoft Visual Studio 2008 Web Developer Express Edition:

web pi

But when I check my Visual Studio:

vs.net

It’s already installed.

Better file a bug on Connect 😛

EU wants IE out of Windows. Did they actually think about it?

Probably not. If you, as an outsider you see that Microsoft is sold as a bundle of software.

  • The kernel
  • The GUI
  • Firewall
  • Media Player
  • Browser

The major difference between this setup, and one from Linux. Linux is A LOT more modular. For example if you take a look at Windows’ Help (just press F1 when you are on your desktop.).

It actually IS an Internet Explorer window, with customized properties.

So you can’t just remove Internet Explorer’s engine (Trident) and replace it with Firefox, since Internet Explorer is a lot more versatile, it’s not just a browser to display internet pages, a lot more components in windows depend on that engine to display text and pictures!

It’s not that easy to replace that component, because Firefox does not accept that API.

So I think that the EU should first decide what they want: do they want the icon to be removed, or the whole engine.

If it is the second answer they should force Microsoft to create an API, where other components can plug into so they can have their replacement for the Trident engine.

But they need to do a lot more research before they start screaming that IE has to be removed from Windows.

Software uninstallation: stuff slipping through the mazes.

Or maybe just badly programmed…

I’ve had this experience with multiple hobby programmed uninstallers, they would leave a folder behind. Sure no problem, I’ve got it for free, they can’t help it. You file a bug report and hope they fix it in the next release.

But when we talk about Apple, things are different. Apple is a respected company.

Yesterday I tried installing Quicktime to play my mp4 files. I downloaded the installer from the Apple.com website, and installed it. No problem.

But since the movies were damaged I decided that Quicktime was useless, and so I removed it. Or so I thought…

After inspecting my system multiple Apple related folders where still there. And even Apple Software Updater. I chose to remove Quicktime (the only thing I installed!). Then why must it not remove this application? Because it’s Apple? (that’s what they think probably…).

 

So you might want to watch out with uninstalling programs, they always leave stuff behind. Even with the most respected companies. Maybe they don’t deserve that…

MSDN downloading on Vista

Let’s say you are one of the gifted persons to have MSDN access.

Let’s say you use Vista 64-bit (I don’t know if the problem occurs on 32-bit).

Let’s say you want to download something from MSDN with Microsoft File Transfer Manager.

And it does not work.

Well use this workaround:

First: download the File Transfer Manager from here.

Download and install the MSI. The default path is c:\Program Files (x86)\Microsoft File Transfer Manager”. Remember this.

Then use Firefox to go to the MSDN website, start a download, and it will prompt you to do something with the default.aspx. Well open that file with the File Transfer Manager. And it works!

Woei!

AVG 8 update marks user32.dll as False Positive on XP SP2

DO NOT REMOVE user32.dll, even though AVG 8 states that there is a virus in the file.

Doing so will remove the file, and cause a BSOD, and makes your system unable to boot.

It marks the file as infected with Trojan Horse PSW.BANKER4.APSA.

Possibilities are to wait for an update from AVG, or (preferably) upgrade to XP SP3!