I don't understand why my login keeps failing.

4.5.1 is running on an IIS Server called Total

SQL 2005 is on a server called aop1

The name of the database is TotalWeb

I created a user in the database with an ID of DNNuker

I associated that with a domain user DotNetNuker

I gave DNNuker db_owner for the schema and the role membership

I gave DotNetNuker NTFS permissions to the website folders (as well as Network Service)

I specified DotNetNuker's password in the wizard

I've tried all combinations of check boxes

I've no hair left to pull out

The password I used was for the domain user. Is there a separate password for the SQL user? I don't see one. 

When I copied the table from the wizard, the ****** from the password pasted as blank into the post below.

I don't know where to find a query analyzer window in SQL 2005 Management Studio or how to otherwise test the connection.

I appreciate your help with this, believe me, but I just don't know how to do that.

The SQL Server is running on a domain controller (SBS 2003 R2 Premium), so there aren't local user accounts.

For my database, when I go to Create New User ... it requires a SQL User ID and an account from the domain... or am I missing some important concept? Is there a place in the Management Studio to specify a password for the SQL User ID? I don't see it in the user properties anywhere.

This has got to be something simple, I'm overlooking.