Also having problem with install - database connection. Attempting DNN 4.0.2 and using Windows XP SP2; SQL Server 2005. Installation Guide is vague on setting up database permissions, have to follow DNN3 and then attempt to modify to details regarding DNN4 in web.config
1) Unzipped files in in new virtual directory DotNetNuke_2 as instructed
2) Created database DotNetNuke
3) Created new user (qustion as to use of existing Windows login - i.e., Windows authentication vs. SQL login with password - tried both). Assigned new user to DNN database (question as to user "dbo" - has properties of my system login - and it won't let me add my system login as a database user because it says it already exists)
3a) Set Windows file pemissions (Re "sharing": The Installation Guide reflects file permissions for Windows 2000 but not Windows XP - the screens aren't the same)
4) Edited web.config to reflect possible users as detailed in #3
5) Message: "The user is not associated with a trusted SQL Server connection. "
6) Read many messages in Forums - none too helpful.
7) The problem obviously seems to be in setting SQL permissions. Need a clean newbie walkthrough for DNN 4, Windows XP, SQL 2005.
Thank you.