By Lee Sykes
May 2008
In this tutorial we provide a quick start guide to using SQL queries with SQL Server Express. In particular we demonstrate how to set up SQL Server Express so that you can execute SQL queries on your DotNetNuke database, on both a local and a live database.
Using SQL queries with your DotNetNuke installation can really help to speed up the administration tasks. This is especially true if you are managing a DotNetNuke website with a large number of pages, or if you are re-skinning an already established DotNetNuke website.
Think of all the times where you access the DotNetNuke page settings, click on several options, and then make those updates to several pages, by using SQL queries you can update all of those settings across several pages in a matter of seconds.
This tutorial helps you to set up SQL Server Management Studio Express and execute a basic query, following this tutorial you can then progress onto the more advanced SQL query tutorials.
If you are using Windows Vista this tutorial helps you to set up SQL Server Express with Vista and configure the security settings for the administrator user account in Vista.
Tutorial References
Download SQL Server Express with Advanced Services
http://msdn2.microsoft.com/en-gb/express/bb410791.aspx
Once you have downloaded SQL Server Express, follow video tutorials 1 and 2 from either of these tutorials to install and configure SQL Server Express for use with DotNetNuke.
How to install DotNetNuke to Vista
How to install DotNetNuke 4.5 to Windows XP Pro with IIS
The videos contain:
Video 1 - How to Attach a DotNetNuke Database to SQL Server Express using Windows Vista
- Introduction
- How to download SQL Server Express
- How to attach a localhost DotNetNuke database to SQL Server Management Studio Express
- How to find the DotNetNuke installation database
- How to set up Windows Vista so you can attach a database
- Examples of problems encountered with Windows Vista
- How to give administrative rights to a Windows Vista user account
- How to disable UAC (User account control)
Time length: 9min 10secs
Video 2 - How to Create a User Account and set up Permissions
- How to attach the DotNetNuke database
- How to view all the tables within the installation
- How to add a user to the database
- Creating a new user account
- How to add a new user to the DotNetNuke database
- How to set up the database permissions for the new user
Time length: 6min 21secs
Video 3 - How to Edit the Web.config Connection String
- How to open the web.config file with Visual Web Developer Express
- How to change the Connection String
- An example of errors that can occur when altering the Connection String
- How to correct errors in the Connection String
Time length: 5min 57secs
Video 4 - How to Create a SQL Query, How to Connect to a Live Database
- How to create a simple test query on a localhost installation
- How to connect to a live DotNetNuke database using SQL Server Management Express
- How to create a new server group
Time length: 7min 42secs
Total time length: 29min 10secs