I am having trouble getting past the CONFIGURE DATABASE CONNECTION page.  When I click on my TEST DATABASE CONNECTION, I get a Connection Error(s) notificatioin

Select Database: SQL Server 2005/2008 (Express)
Server:  TEST1\SQLEXPRESS
Filename:  dnn494
User ID:  dnn494user
Password:  dnn494pass
Run as db Owner:  (Checked)
--------------------------------------------------------------------------------
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'dnn494user'.

My Connection String looks like this:
 

     <connectionStrings>
    <add
      name="SiteSqlServer"
      connectionString="Server=TEST1\SQLEXPRESS;Database=dnn494;uid=dnn494user;pwd=dnn494pass;"
      providerName="System.Data.SqlClient" />
    </connectionStrings>
    <appSettings>
    <add key="SiteSqlServer" value="Server=TEST1\SQLEXPRESS;Database=dnn494;uid=dnn494user;pwd=dnn494pass"/>
        <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-->
        <!-- set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)
    <add key="UsePortNumber" value="true" /> -->
    </appSettings>

By looking in my MSQL Server Management Studio under TEST1\SQLEXPRESS, under Databases I have dnn494 listed, under SECURITY | LOGINS section, I have dnn494user listed too.  Under that properties, The login name is dnn494user, pasword should be dnn494pass, Default Database is dnn494.  Under User Mapping I have checked Database dnn494, User dnn494user, Default Schema dbo and Database role membership is db_owner and publc.

Can anyone else provide any insight on what I am doing wrong?  Dont worry about what credential I provided, this is a test machine.  This test machine is WinXP Pro using IIS 5.1, SQLEXPRESS 2008, ASPNET 2.0

 

Sebastian, I figured it out.  I was not closely following some documentation, per link below.  It turns out that the web.config file has default parameters for the MSSQL Express 2005, 2008 already set to be used.  I kept taking it out and used the MSSQL 2005, 2008 Server connection parameters instead.

With a couple glitches here and there, I worked it out and finally got it successfully installed.

This link actually provided better instructions to install as it was more detailed.  I was able to figure out what was different in my situation using Windows XP Pro, IIS 5.1 and MSSQL Server 2008 Express with ASP.Net 2.0.  Also using the INSTALL package 4.9.4

http://www.bestwebsites.co.nz/dotnetnuke/easy-dotnetnuke-installation-guide/

I think the DotNetNuke Installation Instructions could use more work.   Regardless, Sebastian, I do appreciate your efforts in trying to answer a multitude of questions for us NEWBS.

Thanks again.