Hello everybody,
I'm in the process of installing my first 4.03.04 DNN site (i have a 3.x version running without a problem). I'm fallowing the install manual but can't seem to get this new version to start. What i have doen:
1) unziped the install files and copied them to a directory on the web/sql server
a) server = 192.168.10.10
2) set the NTFS security on the directory and gave the "Network service" user full controle
3) created a database and created a local SQL user giving this user owen rights on the DB
a) db = ittalks
b) user= ittalks | pw= password (*this is not the actual pw ofcourse)
4) Created the virtula directory
a) dir name= ittalks
b) installed dotnet2.0 | created seporate appl pool | enabled .net 2.0 on the virtual directory
5) edited the web.config file and added the SQL string in 2 locations
<connectionStrings> <!-- 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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;" providerName="System.Data.SqlClient" /> --> </connectionStrings> <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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;"/> --> <add key="InstallTemplate" value="DotNetNuke.install.config" /> <add key="AutoUpgrade" 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--> </appSettings> |
Now the manual tells me i should be able to access http://192.168.10.10/ittalks but when i try to do this i'm prompted with the fallowing error
Error Installing DotNetNuke
Current Assembly Version: 04.03.04
ERROR: Could not connect to database specified in connectionString for |
I have created an ODBC DSN to check and can confirm the DB is there and my "ittalks" user had access to the db but for some reason the site is still not working.
Can anybody help me?
Thanks,
Tom Decaluwé