Howto configure client alias for SQL Server

This post will show you how to configure client aliases for SQL Server. One of the security hardening measures is configuring non-standard port for SQL Server instances. A default instance of SQL Server listens for connections on TCP port 1433. If a client computer is...

SharePoint: Remove Windows Internal Database

If you have uninstalled Windows SharePoint Services v3, you cannot be sure that the Windows Internal Database (SQL Embedded Edition) has been deleted. Reason: It’s not listed in Add/Remove programs. All you have to do is run this command and it’s all...

SharePoint: Migration from WSSV2 to WSSV3

This is going to be a challening task and I am going to test this over the weekend. I wrote about moving WSSV2 MSDE database to WSSV3 SQL Embedded Edition earlier and step # 1 was to use the pre-scan tool. Quick re-cap of that step: Use the Prescan.exe tool to scan...