Hi all,
i am sorry for posting this in advance since i know there are so many things on this forum related to my question.
the problem is that now i am really confused that i have no idea which user is which and which database is which.
i really need help.
i am trying to install for learning process, DNN4.5.5 on windows 2003 server and i am using MSSQL express edition.
i will tell you exactly what i did and you tell me where i went wrong.
i unziped the dotnetnuke source file on dotnetnuke folder
i created a newdatabase called DotNetNuke
I created a new login user called DotNetNukeUser with the password DotNetNukeUser.
i gave DotNetNukeUser the access privilege to DotNetNuke database setting public and db_owner for it.
i changed the release.config to web.config and i modified the following lines in bold:
<
<!--
<
connectionStrings> Connection String for SQL Server 2005 Express -->add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=False;Database=DotNetNuke;"
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=DotNetNuke.mdf;"/>Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=DotNetNukeUser;pwd=DotNetNukeUser;"/>add key="InstallTemplate" value="DotNetNuke.install.resources" />add key="AutoUpgrade" value="true" />add key="UseInstallWizard" value="true"/>add key="InstallMemberRole" value="true" />add key="UseDnnConfig" value="true" />add key="ShowMissingKeys" value="false" />add key="EnableWebFarmSupport" value="false" />add key="EnableCachePersistence" value="false"/>
<data
defaultProvider="SqlDataProvider">
<providers>
<clear/>
<add
name="SqlDataProvider"
type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionStringName="SiteSqlServer"
upgradeConnectionString=""
providerPath="~\Providers\DataProviders\SqlDataProvider\"
objectQualifier=""
databaseOwner="DotNetNukeUser"/>
</providers>
</data>
now i went like the documentation says to my local folder dotnetnuke and i changed the permission to allow all for ASP.NET user and Network Services also i know i am using windows 2003, therefore only network services is needed.
now in IIS i created a new virtual directory for Dotnetnuke folder and i made sure asp.net 2.0 is selected.
now when i am trying to install it using http://localhost/dotnetnuke/Install/Install.aspx?mode=Install on internet explorer i am getting the following error
Error Installing DotNetNuke
Current Assembly Version: 04.05.05
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
now please tell me, which user should i use and which database, is it my localhost user compname/myname
when i user internet explorer i go to this error straight away
when i use firefox it asks me for username and password.
which username should i use
thank you and sorry for the loing question. the problem is i am stuck and i am still learning.
best regards