Category Archives: Software

Enabling SQL Server 2008 (R2) access over Network

Posted on by
3

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

extra info on part one
(click for large size)

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

firewall explanation
(click for large size)

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

Choose TCP or UDP port

Hit Next.

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

Which TCP Port

Hit Next.

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?

Hit Next.

New name for the rule

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

Web Platform Installer Detection bug

Posted on by
Reply

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 :P

Netbeans 6.7M2 JDK Detection Improvements.

Posted on by
1

Back to =< Netbeans 6.5.1, when you updated the JDK, and installed the new version, Netbeans wasn’t able to start due to a missing JDK. You could start Netbeans with –javahome

switch to point to the new JDK to avoid a terminal error.

Or you could open the <NetbeansInstallDirectory>\etc\netbeans.conf, and in there you would modify the netbeans_jdkhome var.

As for Netbeans 6.7M2 this is no longer necessary. It searches for another IDE when it can’t find the original one. Though this is just for THAT session. So if you want a permanent change you still have to edit >blah<\etc\netbeans.conf like stated above.

Good luck :)

Windows Live 2009: File transfer not supported

Posted on by
2

Since I installed an update to my Live Messenger I cannot send any more files to people who use an older version of Live Messenger.

Why?

It costs them more money to remove the code than just leave it in?

Quite useless, now everybody is forced to upgrade to the new version… and how many people know how to do that? …

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

Posted on by
2

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.

Posted on by
Reply

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

Posted on by
Reply

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!