First: enable SQL Server itself to be accessed over the network
- Open SQL Server Configuration Manager
- Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER
-
Doubleclick TCP/IP
-
Set Enabled to Yes

(click for large size)
Secondly: change the Windows Firewall to allow incoming connections on the TCP port of SQL Server
- Open Windows Firewall with Advanced Security
- Click on New Rule

(click for large size)
Now in the wizard you set the type of the rule to Port.

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

Hit Next.
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:

Hit Next.

Hit Finish and you’re ready to develop SQL over network
No Comments »
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:
But when I check my Visual Studio:
It’s already installed.
Better file a bug on Connect
No Comments »
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
1 Comment »
Apparently you can browse your history in Firefox by holding Shift and then scroll the wheel.
Didn’t know that
2 Comments »
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? …
2 Comments »
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.
2 Comments »
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…
No Comments »
An update for Windows Live Messenger has just been released, it includes an updated GUI, and it finally displays custom emoticons
Messenger itself notifies you of the update
1 Comment »
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!
No Comments »
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!
11 Comments »