How to bakup a MSSQL 2005 database.

Hello,

To backup a mssql 2005 database login to MSSQL management studio with windows authentication or sql server authentication . Expand the databases in the left pane , right click on the database whose backup you want to take ==> tasks ==> backup ==> the source is database and destination is backup to disk ==> click ok to backup the database.

Service unavaliable Message on a website.

To solve the problem restart the IIS

1) c:/> iisreset /restart

or you can even recycle the application pool to solve the issue .

Regards,

Prashant. J.

Install DNN in few easy steps

You can install DNN either in the root folder of the website or under any folder say dnn under your website .

1) Download DNN installtation zip file from DotNetNuke site and extract it under the root folder or any other folder where you want to install dnn .

2) The IUSR should have write as well as modify permission on the folder where you are installing DNN

3) Now create a MSSQL database , database user and password

4) Before browsing the website in the browser and proceeding with the installation make following changes in the web.config file to make the installation easier

Comment the 2 attach database connection strings

Note : Please note that the connection string starts with <>

a) add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Data base.mdf;" providerName="System.Data.SqlClient"

b) add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Data base.mdf;"

Use the following 2 connection strings

a) add name="SiteSqlServer" connectionString="Server=IP of the database server;Database=databasename;uid=databaseuser;pwd= password;" providerName="System.Data.SqlClient"

b) add key="SiteSqlServer" value="Server=IP of database server;Database=databasename;uid=databaseuser;pwd= password;"

5) Now browse the website and select auto installation and click next , DNN will be installed on the website .

Regards,

Prashant J

Start/stop IIS from command prompt

Here are some commands to start stop IIS from command prompt.

C:\>net start w3svc , starts the world wide web service
C:\>net start msftpsvc , starts the ftp service
C:\>net start smtpsvc , starts the smtp service
C:\>net Start HTTPFilter
C:\>iisreset /restart , stops and starts all the services.

Regards,
Prashant.