Well. 6 hour of hard work pays off.

After placing all physical files at Inetpub\wwwroot (not inside umbraco folder). It is opening the Admin screen where you enter user name and password.

But after entering 'umbracouser' and 'password'(same as umbraco db account credentials) it throws below exceptions.

Invalid object name 'umbracoUser'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'umbracoUser'.

Source Error:

Stack Trace:

[SqlException (0x80131904): Invalid object name 'umbracoUser'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:51
   umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:194

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
   umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:198
   umbraco.BusinessLogic.User.getUserId(String query, IParameter[] parameterValues) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\businesslogic\User.cs:500
   umbraco.BusinessLogic.User.getUserId(String lname) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\businesslogic\User.cs:495
   umbraco.BusinessLogic.User..ctor(String Login) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\businesslogic\User.cs:69
   umbraco.providers.UsersMembershipProvider.ValidateUser(String username, String password) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\providers\UsersMembershipProvider.cs:567
   umbraco.cms.presentation.login.Button1_Click(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\presentation\umbraco\login.aspx.cs:71
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Here is Web.config for your help.

<?xml version="1.0"?>
<configuration>
 <configSections>
  <section name="urlrewritingnet" restartOnExternalChanges="true" requirePermission="false" type="UrlRewritingNet.Configuration.UrlRewriteSection, UrlRewritingNet.UrlRewriter"/>
  <!-- ASPNETAJAX -->
  <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
   <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
    <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
    <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
     <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
     <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
     <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
     <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
    </sectionGroup>
   </sectionGroup>
  </sectionGroup>
  <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
   <section name="umbraco.presentation.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
  </sectionGroup>
 </configSections>
 <urlrewritingnet configSource="config\UrlRewriting.config"/>
 <appSettings>
  <add key="umbracoDbDSN" value="datalayer=SqlServer;server=.\sqlexpress;database=umbraco;user id=umbracouser;password=sumee2406"/>
  <add key="umbracoConfigurationStatus" value=""/>
  <add key="umbracoReservedUrls" value="/config/splashes/booting.aspx,/install/default.aspx,/config/splashes/noNodes.aspx"/>
  <add key="umbracoReservedPaths" value="/umbraco,/install/"/>
  <add key="umbracoContentXML" value="/data/umbraco.config"/>
  <add key="umbracoStorageDirectory" value="/data"/>
  <add key="umbracoPath" value="/umbraco"/>
  <add key="umbracoEnableStat" value="false"/>
  <add key="umbracoHideTopLevelNodeFromPath" value="true"/>
  <add key="umbracoEditXhtmlMode" value="true"/>
  <add key="umbracoUseDirectoryUrls" value="false"/>
  <add key="umbracoDebugMode" value="true"/>
  <add key="umbracoTimeOutInMinutes" value="20"/>
  <!-- How often should umbraco check for upgrades (in days) -->
  <add key="umbracoVersionCheckPeriod" value="7"/>
  <add key="umbracoDisableXsltExtensions" value="true"/>
  <add key="umbracoDefaultUILanguage" value="en"/>
  <add key="umbracoProfileUrl" value="profiler"/>
  <add key="umbracoUseSSL" value="false"/>
  <add key="umbracoUseMediumTrust" value="false"/>
 </appSettings>
 <system.net>
  <mailSettings>
   <smtp>
    <network host="127.0.0.1" userName="username" password="password"/>
   </smtp>
  </mailSettings>
 </system.net>
 <system.web>
  <customErrors mode="RemoteOnly"/>
  <trace enabled="true" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
  <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20"/>
  <globalization requestEncoding="UTF-8" responseEncoding="UTF-8"/>
  <xhtmlConformance mode="Strict"/>
  <pages enableEventValidation="false">
   <!-- ASPNETAJAX -->
   <controls>
    <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    <add tagPrefix="umbraco" namespace="umbraco.presentation.templateControls" assembly="umbraco"/>
   </controls>
  </pages>
  <httpModules>
   <!-- URL REWRTIER -->
   <add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter"/>
   <add name="umbracoRequestModule" type="umbraco.presentation.requestModule"/>
   <!-- UMBRACO -->
   <add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule"/>
   <add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule"/>
   <!-- ASPNETAJAX -->
   <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
  </httpModules>
  <httpHandlers>
   <remove verb="*" path="*.asmx"/>
   <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
   <!-- UMBRACO CHANNELS -->
   <add verb="*" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco"/>
   <add verb="*" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco"/>
  </httpHandlers>
  <compilation defaultLanguage="c#" debug="true" batch="false">
   <assemblies>
    <!-- ASPNETAJAX -->
    <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
   </assemblies>
  </compilation>
  <authentication mode="Forms">
   <forms name="yourAuthCookie" loginUrl="login.aspx" protection="All" path="/"/>
  </authentication>
  <authorization>
   <allow users="?"/>
  </authorization>
  <!-- Membership Provider -->
  <membership defaultProvider="UmbracoMembershipProvider" userIsOnlineTimeWindow="15">
   <providers>
    <clear/>
    <add name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="TestType"/>
    <add name="AspNetSqlMemberShipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer"/>
    <add name="UsersMembershipProvider" type="umbraco.providers.UsersMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false"/>
   </providers>
  </membership>
  <!-- added to support membership providers in access layer -->
  <roleManager enabled="true" defaultProvider="UmbracoRoleProvider">
   <providers>
    <clear/>
    <add name="UmbracoRoleProvider" type="umbraco.providers.members.UmbracoRoleProvider" applicationName="umbraco"/>
   </providers>
  </roleManager>
  <!-- Sitemap provider-->
  <siteMap defaultProvider="UmbracoSiteMapProvider" enabled="true">
   <providers>
    <clear/>
    <add name="UmbracoSiteMapProvider" type="umbraco.presentation.nodeFactory.UmbracoSiteMapProvider" defaultDescriptionAlias="description" securityTrimmingEnabled="true"/>
   </providers>
  </siteMap>
 </system.web>
 <!-- ASPNET3.5 CODEDOM-->
 <system.codedom>
  <compilers>
   <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <providerOption name="CompilerVersion" value="v3.5"/>
    <providerOption name="WarnAsError" value="false"/>
   </compiler>
  </compilers>
 </system.codedom>
 <!-- ASPNETAJAX -->
 <system.web.extensions>
  <scripting>
   <scriptResourceHandler enableCompression="true" enableCaching="true"/>
  </scripting>
 </system.web.extensions>
 <!-- IIS 7 Integrated Mode Configuration -->
 <system.webServer>
  <validation validateIntegratedModeConfiguration="false"/>
  <modules>
   <!-- Asp.net 3.5 Modules-->
   <remove name="ScriptModule"/>
   <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <!-- UMBRACO modules-->
   <add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter"/>
   <add name="umbracoRequestModule" type="umbraco.presentation.requestModule"/>
   <add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule"/>
   <add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule"/>
   <remove name="ScriptModule"/>
   <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
  </modules>
  <handlers accessPolicy="Read, Write, Script, Execute">
   <remove name="WebServiceHandlerFactory-Integrated"/>
   <remove name="ScriptHandlerFactory"/>
   <remove name="ScriptHandlerFactoryAppServices"/>
   <remove name="ScriptResource"/>
   <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
   <remove name="Channels"/>
   <remove name="Channels_Word"/>
   <add verb="*" name="Channels" preCondition="integratedMode" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco"/>
   <add verb="*" name="Channels_Word" preCondition="integratedMode" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco"/>
  </handlers>
 </system.webServer>
 <!-- Ajax 1.0 Compatibility -->
 <runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
   <dependentAssembly>
    <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
   </dependentAssembly>
   <dependentAssembly>
    <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
   </dependentAssembly>
  </assemblyBinding>
 </runtime>
</configuration>

Managed to wake up all night and determined to fix this up.

Well, not completely there. But managed to copy database script and create UMBRACO tables.

Now I get Admin console for user name and password. Trying to findout what they are for UMBRACO 4.0.3

Hi, 

you don't need to run the install-script manually. After installing (either with WebPI or manually) the files, you need to open the URL of the site you installed it to (http://localhost/ for example). Umbraco will see that it is not installed yet and will start the install-script.

In those install-steps, you can define the password for the admin-user.

Check here for an install-guide:

http://our.umbraco.org/wiki/install-and-setup/installing-umbraco-4-on-localhost

(NOTE: umbraco 4.0.3 or older CANNOT be installed in a virtual directory)

HTH,

Peter

Thanks alot Peter.

I have been working on this since last 13hrs. My target is to get this working.

Please note that I am using Windows Web app installer. During the installation it asks for where do you want to store physical files. I have chosen inetpub-->wwwroot (Root level). Is that right? What do you mean to say 'CANNOT be installed in virtual directory?

After installing and removing at least 6 times, now I managed to move Umbraco folder to root level of Inetpub-->Inet. It is displaying Admin screen. But where the user name and password? Am I missing something?

Your help and insight is highly appreciated. I have tried creating user account by running the ASP.NET Web configuration tool, but no luck.

You are right to choose the wwwroot. However, during the install with WebPI, leave the  Application Name field blank, otherwise the installer will place Umbraco into a sub folder (which wil not work).

After finishing the installation with WebPI, open http://localhost/ ;

If all has gone well, you will get step 1 of the umbraco-installer. (Note: You should not get the admin-interface yet)

Does this get you further?

Peter

Thanks Peter. Very much appreciated.

Should I enter database admin and user details during installaiton process? (I know it is required, just to make sure).

Could you refer me a step by step guide for this? uisng Web PI?

During installation, the Web PI will automatically fill in the database information in the Umbraco Installer.

If I were you I would create a new website in IIS with a new doc root.

Fire up the Web PI

Choose Umbraco

Remember as Peter says to leave application name field blank

Add a binding.

Choose create a new database and fill in the proper information

Let Web PI install umbraco

After installation go to the site

The Umbraco installer will appear, click next next next and then you should be all good.

If not, I can make a video with it, if that would be helpfull :-)

Thanks Daniel.

At last after waking up all Saturday night, managed to get Web PI up and running.

Now the problem is as out lined below. ASPNET can't get access to number of folders/files. I did google and wasted some time. Why you Umbraco inventors say it is simple? I have been working as ASP.NET Developer for 6 years now and I found it bit harder.

Access to the path 'C:\inetpub\wwwroot\data\packages\ae41aad0-1c30-11dd-bd0b-0800200c9a66.umb' is denied. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.UnauthorizedAccessException: Access to the path 'C:\inetpub\wwwroot\data\packages\ae41aad0-1c30-11dd-bd0b-0800200c9a66.umb' is denied. 

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. 

Your help is appreciated.

Where in the installation process do you get this?

It sounds like a permission problem - try to do this step:

http://umbraco.org/documentation/books/install-umbraco-30-on-windows-vista/configure-iis-for-umbraco

I have to go to the cinema now, but will do a screencast of a umbraco installation using the web pi later or tomorrow - then you can check if you are doing it the same way.

It could also be your win install that is somehow fucked ? Normally using the web pi is working pretty smooth.

You could look in the IIS log to check problems.

Well - hope it gives a bit of help.

Thanks. Of course it is permissions problems, which I had during UMBRACO step by step configuration process.

Enjoy your cinema.

But I like to say that the video links for windows XP or Vista simply redirect to a web page saying 'No available, sorry'. It is not expected as you are aware.

I am aware of trouble shooting the issue. But what I want to make clear is 'until unless there are proper installation guides or tutorials developers like to get pissed off. I agree that UMBRACO is best CMS due to its compatibility with .NET.

I had exceptions saying 'permissions problem with .\css , .\Data folders. But there is no resolution on that step of installation. Crap. Is in't it? win is not fucked up. permissions are fucked up.

Sorry mate, forgot to answer your first query. 'Where in the installaiton process do you get this?'

Answer:- permissions step.

I agree that it sounds stupid.

But changing IIS Application pool to Classic has resolved the issue.

Thanks for all your help during weekend.

Good you made it work - i think that the installation area is OK covered by the tutorials out there.

I've been working with a lot of CMS's and there is always a little hurdle when installing them on different OS's, servers etc. - It seems that your win install isn't totally "fresh".

Have fun with Umbraco ;-)

btw. Green Zone is a nice movie :D

is working on a reply...