Hi, I'm not quite sure if I understand the problem .. are you saying that you get a message "undefined...success" while installing?  At what point in the install does this occur?  DNN 4.5.3 onto Win2k3 with Sql2k5 and IIS6 is very standard and should be straightforward (of course everything is not always as it should be!)

I have previously written an easy dotnetnuke installation guide .. basically it says to get the prerequsites installed and setup before starting the dotnetnuke install and you should have no problem.

JK.

OK, I am using Microsoft SQL Server Management Studio Express CTP to create my database. I am RDP into that server to do this.

1.  Database name is ... blah  Owner is <default>

2. Then I click OK and the database is created.

3. Under Security, I created a new login, with SQL Server Authentication checked and a password

4. Default database is the one I created.  Clicked OK

5. On the database, I clicked on Users under security to create a new user.

6. Clicked on the elipsis to open the dialog box to select my login name I created

7. Default Schema is grayed out and in the Database Role Membership window, I selected db_owner

8.  I made up a name for the user and clicked OK

9. In the web.config, I set my server, db, and user name

10.  Ran the site from the server, get to the Custom/Typical.Auto Screen

    Auto Errors with:

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

Custom and Typical go to the next screen, I test permissions...good.  Next screen test database with Integrated Security checked....good. 

11. Next screen get the animation and:

Installing Database - Version 4.4.0...

Then I get:

Installing Database - Version 4.4.0...undefined...Success
Installation of Database Complete

12. This happens when Integrated Security is checked and when it's not and I use the password.

13.  Now when I try to get to it from the public side, I get the old

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

but once I try that, I have to copy the release.config back to web.config and reconfigure the settings again.

Any suggestions?

Excellent call Ian,

So I tried to create a table directly on the database....no luck.  So it is definitely a database related issue.

With that knowledge gained, the ...undefined...success   error seems to be when SQL Server allows access but denies authorization but there is no code to handle that type of error, thus "undefined", and the object returns as being completed, thus "success" because the only checking is on the authentication not authorization. 

I will move foward with this new knowledge and poke my DBA in the head with a dull #2 pencil to have him set me up a database correctly.

Thanks all,

Dash