SQL Server 2008 allows to store binary data, if Database has a FILESTREAM feature
It was time to move many sites from W2K3 Server (Windows 2003 Server) and SQL 2000 Server to a new W2K8 Server (Windows 2008 Server) and SQL 2008 Server. And if I ever have to do it again, I will check with these notes. The greatest secret in technical life (and may be wider) is to change before you have to. Anticipate and change before circumstances force you. For a long time I was planning this migration, but I didn’t expect to go through so many hurdles and error messages. Luckily, I found solutions that seem logical and clean. So, let’s go into step-by-step details. COPY DATABASE AND SITES – Backup…
You have 180 days to evaluate. You can check number of days till expiration: open your SQL Server Management Studio and widen first line in Help — About box. What if your trial is about to expire, and you need just a few more days to evaluate? You can switch to a free Express edition, or you can follow this cumbersome procedure. =01= Un-Install SQL Server 2008 Drop all your custom databases Run your Maintenance Plan one last time Save all your maintenance plans (this step was not tested) Go to Control Panel – Programs and Features Uninstall Microsoft SQL Server 2008 – Remove Check Rules – Next Select Features –…
Environment ASP or ASP.NET site is running on IIS 7.5. SQL Server 2008 R2 Express (10.50.1600.1) running on Windows 2008 Server R2 (W2K8 R2) x64. Problem You will see one of two errors depending on whether you dealing with ASP or ASP.NET sites. On ASP.NET sites you will see “Server Error – Error: 26 – Error Locating Server/Instance Specified” Server Error in '/YourApps' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26…
I am running PHP on IIS 7.5. This is a Windows 2012 Server. Fresh clean install every time. The only way to access and delete these TEMP files are by using a command prompt. And this deletion procedure will run for several DAYS . . . The Problem The story goes like this. Fresh new instance of a Windows 2012 Server is great. It runs fast and smooth. But after 5 or 6 months MySQL service having hard times to start up. And a little later – couldn’t start at all. The only way I can make it run is to start it from a command prompt. And finally the whole server just slows…
[ . . . always in progress . . . ] Everybody who uses little-known in US, but powerful Synology network storage boxes can’t help but fall in love with them. I was thinking to replace my old 2008 Windows server with a new one, but pain of maintaining and configuring stopped me. Is there a better choice out there? Yes. Something called NAS – network attached storage. To begin with, I almost bought Western Digital My Cloud box, but reading comments about slowness of performance stopped me there. On the contrary, reading Synology reviews made me salivating. And reality was even better than expectations. The main purpose of Synology is to be a…
This article is about moving your Windows-based WordPress and other sites (some ASP, some ASP.NET) from older to a newer instance using AMAZON cloud server instances. Procedures described here do not involve any installation. Just copy files and edit CONFIG files. We do not manipulate Registry as well (except to change inbound RDP port). Sample installation in this article was tested on Amazon Small instance. Image used was Windows 2012 Server x64 with SQL Server2012 Express. This article can be used to create you own check list while preparing to migrate to a new Amazon server. Why would you decide to upgrade or move to a new instance/server? Here are some driving reasons: Something is no…
First – The Problem I can’t get my hands around this problem with WordPress (3.0.1) on Windows 2008 Server. I need to solve this, because it keeps me from registering with Google AdSense. They are saying that “Site Navigation is Broken”. And this is only a problem on Windows 2008 Server and IIS 7. The exact same site with exact same data works properly on Win XP and IIS 5.1. If I select posts by category (or by month), pagination links at the bottom of the page do not have category loaded in their HREF(s). So, if user tries to go to next pages, he gets to page 2, or 3, or 4…
If you like to be in control of all your servers, you would love the gentle nature of WordPress installation. Installation includes PHP, MySQL and WordPress components. All steps can be done manually. Instead of running install, you can just copy files and directories, and make manual configurations adjustments. It is like labyrinth of DLL(s) meets the non-DLL world for the first time. Check IIS7 Installed Components Windows Server 2008 comes with IIS 7. Windows 7 and Server 2008 R2 come with IIS 7.5. Check that CGI is installed under IIS Roles (Windows Features). Installing PHP Download and install latest PHP. Warning 1: Pick “nts” (non-thread-safe) package, if you are…
WordPress Error 500 – Internal server error on Empty Comment
Problem – Embarrassing Error 500 I am running latest Word Press 3.0.1 on IIS 7.0. If visitor tries to leave an empty comment or forgets to enter name or email, an ugly 500 – Internal server error will appear on the screen. This is extremely embarrassing for the host and for the site. I approximately know that I have three ways to approach this problem: – Disable error 500 on IIS side to allow WordPress to handle it; – Lower level of error generated in WordPress code (IIS will not catch it then) or – Write a local JavaScript to prevent user from posting with empty fields. Solution – One click in…
Read more »