Ok, well I've never used SQL databases before so I'll need some assistance in this as I have no idea as to delete and recreate the database ... Here are the instructions on installing dotnetnuke at my provider DiscountASP This is how I set it up originally so I can follow these to reinstall DotNetNuke:
So from this can you tell me if I have a "test.mdf" file set up on my host providers servers? The database is hosted separately in a different location to my web site so how would I get access to the "test.mdf" to delete it? Otherwise if I have to "delete and recreate the database by yourself and grant permissions to the designated user". Do you have any set by step instructions as to how to do this or is this something that I’ll have to get the provider to hosting perform?
Regards,
Dheat.
----------------------------------
DETAILS
A) Get DotNetNuke 4.x and Uploading to Webserver
- Download DotNetNuke 4.x Install Version from DotNetNuke.com
- Extract the content to your local machine
B) Customizing the web.config file
- Rename release.config file (under root) to web.config.
- Open the Web.config file with any text editor.
- Update the database connection information
1) In the <connectionStrings> section
Change
<!-- Connection String for SQL Server 2005 Express -->
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />
-->
To
<add name="SiteSqlServer" connectionString="Server=<SQL Server Name>;Database=<DB_NAME>;uid=<User_Name>;pwd=<DB_password>;" providerName="System.Data.SqlClient" />
2) In the <appSettings> section
Change
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
-->
To
<add key="SiteSqlServer" value="Server=<SQL Server Name>;Database=<DB_NAME>;uid=<User_Name>;pwd=<DB_password>;"/>
-To avoid any conflicts, we would highly recommend using a fresh database for the application install.
C) Upload all the files to your website account. We recommend uploading DotNetNuke into a subdirectory. We DO NOT recommend uploading DotNetNuke to your document root directory.
D) IIS Configurations
1) Switch the .NET Framework to version 2.0 in the IIS manager in the control panel
- Logon to your control panel (https://my.discountasp.net)
- Navigate to the IIS Manager
- Go to the .NET Framework Tab
- Ensure that the framework version is 2.0
2) Create a Web Application
- Logon to your control panel (https://my.discountasp.net)
- Navigate to the Web Application Tool
- Click on the subdirectory in your account where you uploaded all the DotNetNuke files
- Click Install Application
E) DotNetNuke Setup
- Open your browser and navigate to http://www.YourHostedDomainName.com/DotNetNuke_subdirectory
- DotNetNuke will setup all the database objects when it first loads. This process MAY run for several minutes. DO NOT hit the stop button on the browser
Note:
1) Warning: If you install DotNetNuke in your document root directory, your other .NET applications under the root may fail.
2) For more information on DotNetNuke, you can review the documentation under the /documentation directory/
3) For DotNetNuke support, please visit ASP.NET Forums
4) We tested the installation on a SQL 2005 database server, but the same process should also work with SQL 2000.
------------------------------------