Posts Tagged ‘ Express ’

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 »


Automate Database Backup with SQL Express

2017/10/02
By
Modified: 2017/09/16
Automate Database Backup with SQL Express

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL Express edition lacks this feature.  But you still need a backup. Backup automation with SQL Express consist of 3 steps: (1) Write the script to backup all your databases. (2) Test the script by initiating it from a command prompt. (3) Schedule the script using Task Scheduler. Here is each step in detail. ` (1) Write the Script This script overwrites…

Read more »

Node.js -understanding callback when you have to wait

2017/09/12
By
Modified: 2017/09/10
Node.js -understanding callback when you have to wait

This post demonstrates: – how to write a callback function so that results from your database are returned by the time you are ready to render; – how to use multi-field LIKE syntax in a SELECT statement. The most important thing to understand in Node.js is a callback mechanism and its purpose.  It is all fine and dandy, when you just type something for the training session, or copying code from an Internet example, but things are different, when you need to write you own function that must rely on a callback function.  Here I will show no-blocking code that would process POST request, call for MySQL to execute a SELECT query and…

Read more »