Posts Tagged ‘ Server ’

Add a FILESTREAM feature to an existing SQL D/B

2017/12/07
By
Modified: 2017/11/05
SQL 2008 SP2 FILESTREAM Problem

SQL Server 2008 allows to store binary data, if Database has a FILESTREAM feature

Read more »


Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

2017/11/13
By
Modified: 2017/11/12
IIS75-ASP-is-not-Installed

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…

Read more »

How to Re-Install SQL Server 2008 Evaluation

2017/10/28
By
Modified: 2017/11/04
Sandy-Beach-2017

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 –…

Read more »

SQL Error 80004005 – “Specified SQL server not found” – Solved

2017/10/08
By
Modified: 2017/09/16
SQL CFG Manager - Enable TCPIP

  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…

Read more »

PHP chokes server with TEMP files – Updated and Solved

2017/08/11
By
Modified: 2017/07/22
FastCGI Settings

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…

Read more »

Synology DiskStation DS1515+ in action – raw power!

2017/08/01
By
Modified: 2017/08/02
DS1515-Plus-InsideView

[ . . . 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…

Read more »

WordPress Error 500 – Internal server error on Empty Comment

2017/05/17
By
Modified: 2017/04/30
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 »

Move WordPress to a new Windows Server 2012 on Amazon AWS

2017/05/11
By
Modified: 2017/04/30
Move WordPress to a new Windows Server 2012 on Amazon AWS

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…

Read more »

Category Pagination with WordPress on Windows 2008 Server and IIS 7

2013/11/06
By
Modified: 2013/10/07
info_PHP_on_XP

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…

Read more »

Movng WordPress Site to a W2K8 Server and IIS7

2010/07/19
By
Modified: 2011/03/15
Movng WordPress Site to a W2K8 Server and IIS7

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…

Read more »