This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]
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 […]
Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]
You have an insert button that inserts a record into a database. If user presses refresh (F5) button immediately after inserting a new record, more and more new records continue to be written into the database. […]
You are trying to jumpstart an existing ASP.NET site on a new IIS 7.5 server under Windows 7 or under Windows 2008 R2, and you are getting this error message: Cannot open database “YourDB” requested by the login. The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’. The problem is […]
Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’. […]
Locate your MySQL installation files and central configuration file basedir=”C:/Program Files/MySQL/MySQL Server 5.1/” Your MySQL configuration is stored in “my.ini” file Locate your MySQL Database location: datadir=”C:/Documents and Settings/All Users/ Application Data/MySQL/MySQL Server 5.1/Data/” Stop MySQL service. Modify My.ini file to point to a new D/B location and Save. Move […]
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 […]