
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…
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…
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 of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…
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'.
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 in IIS 7.5 DefaultAppPool settings. Windows 2008 Server with IIS 7 runs DefaultAppPool using NetworkService user: Windows 7 and Windows 2008 Server R2 with IIS 7.5 run the same pool under a different user – ApplicationPoolIdentity: On the picture above from IIS 7.5 you see a correct setting for DefaultAppPool row. All you need to do is to change that setting…
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 it to your future site location. Open IIS Admin Create a new virtual directory pointing to that location Side Notes – Change root password You need to know existing root user password. Login into MySQL Command Line Client. Select database: use mysql; Reset user password: update user set password=PASSWORD(“NewPassword”) where User=’root'; Allpy new password: flush privileges; Create a New Database…
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.
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 your Data directory to a new location Restart MySQL service. You are done. All pages (even if you were in the middle of the editing) continue to work. Amazing!