Tag Archives: 2008

Windows 2008 and MSSQL Server 2005 not allowing remote connections

Posted on by
Reply

If you think you checked every setting in MSSQL Server that allows remote connections, you may have missed the Windows firewall setting. I have installed MSSQL 2005 many times on Windows 2000 Server, 2003, and 2008 and never ran into the remote connection problem. What’s happening is I’m unable to connection using the Management Studio on another machine into the server.

  • Checked the Configuration Tools/SQL Server Configuration Manager
  • Checked SQL Browser service is running
  • Pinged the IP address
  • Checked the Surface Area Configurations and made sure it allowed local and remote connections using TCP/IP only

It turns out that Windows firewall didn’t add MSSQL to the exceptions list. So here’s how you do it. Run firewall.cpl to bring up the Windows Firewall settings. On the left click on “Allow a program through Windows Firewall”. Make sure you are on the “Exceptions” tab and click on “Add program…”. If it’s not on the list, browse for the sqlservr.exe. You will find this in [INSTALL_DIR]\MSSQL.1\MSSQL\Binn\sqlservr.exe.

I never had this issue before. Not sure what caused it. Maybe Windows 2008 SP2. The versions I’m using are Windows Server 2008 RC2 and MSSQL Server 2005 Standard.

My first YouTube videos

Posted on by
Reply

After having an account for more than a year, I finally uploaded my first YouTube video. It was pretty easy using MPEGStreamclip to encode it into DV format then import it to iMovie. Once in iMovie, you can do your basic edits and share it in Quicktime. Then you can upload it onto YouTube. If you have iMovie 08, there’s a built in share to YouTube which is very easy to use. It will ask for you account information and it will upload everything for you. Only thing is I hate how they designed iMovie 08. So for my first video, I uploaded the on-site video slideshow created by Ariel Javelosa’s crew during our wedding.

Â

After playing with that I Tivo’d the Liliw Tsinelas festival 2008 special during Unang Hirit. This is when I found it that you can only have up to about 10 minutes per video. So I had to split it up. Here they are.

Â

It was fun and easy. I may start uploading more videos.