Well, after lots of trying to publish my local db to the remote host and failing, I decided to install it remotely on my host. Here's the senario:
My host provides me:
- The IP address of a shared MS SQL 2000 database server: MYIPADR
- A Data Source Name (DSN) for my database applications: MYDSN
- A database name: MYDB
- A database user and password: MYUSER:MYPASSWD
I uploaded the whole extracted dotnetnuke folder to a subdirectory on my host. Now how should I configure the web.config file to make things work? I know I should edit the <appSettings> section, but I don't know how exatcly do it, I tried this but it didn't work, what else should I change?
<appSettings>
<!-- 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=MYIPADR;Database=MYDB;uid=MYUSER;pwd=MYPASSWD;"/>
-->
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<add key="AutoUpgrade" value="true" />
<add key="UseInstallWizard" value="true"/>
<add key="InstallMemberRole" value="true" />
<add key="ShowMissingKeys" value="false" />
<add key="EnableWebFarmSupport" value="false" />
<add key="EnableCachePersistence" value="false"/>
<add key="HostHeader" value="" /><!-- Host Header to remove from URL so
"www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
<add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login
and registration screens-->
<add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in
minutes, and only active if a non-zero figure-->
</appSettings>