A. Extract DotNetNuke_Community_04.09.02_Install.zip to new Dir On my own dedicated server. I have about 4 other DNN running & now starting another one.
B. Modified web.config conparing to others that have worked PER the SQL/2005 example,
<!-- Connection String for SQL Server 2000/2005
<add name="SiteSqlServer" connectionString="Server (local);Database=DotNetNuke;uid=;pwd=;"providerName="System.Data.SqlClient" />
-->
also copy past template to D:\URL Dir xxx\Portals\_default\Templates
C. Set NETWORK SERVICE for that Directory Full control
D. In In SQL Server Management Studio login under windows
Documentation\StarterKit\SQLServer2005Config.html followed 1,2 created SQL2005 DB with Owner Default
E. With SQL Server Authorization did step 5 of SQLServer2005Config.html
Indicates db_owner In role Member , and db_owner In role in Schema are selected, and click OK
No screen is show here
but I HAVE DOC CONFLICT with the downloaded doc DotNetNuke Installation Guide.pdf Page 15 has
db_datareader (necessary for dotnetnuke)
db_datawriter (necessary for dotnetnuke)
db_ddladmin (neccessry for MemberRoles)
db_securityadmin (necessary during installation of MemberRoles)
db_owner In role Member , and db_owner In role in Schema are selected, and click OK
F. In Install/InstallWizard.aspx Get error had Run as db Owner: not checked as owner is
Message: Cannot drop the procedure 'dbMYeMarketPlacesCOMGetDatabaseVersion', because it does not exist or you do not have permission.
Found out that once wizard error table Version & SPROC FindDatabaseVersion, GetDatabaseVersion, UpdateDatabaseVersion get created
SO Would assume the PROBLEM is in step E with permissions