Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  NOOB DUMMY Login Question

Author  Topic  Jace0228 Starting Member 1 Post Posted - 2010-04-20 : 20:55:37 I am not asking for Dot Net Nuke support, please bear with me to the end... I am running: Windows 7 IIS 7 ASP 2.0 or 4.0 (not sure, i see both of these under the application pool) SQL Server Express 8.0 SQL Server Management Console 10.0 I can log into SQL Server Express with Windows Authentication with no problem. I'm trying to get DotNetNuke installed on my PC. I created a new sql account per their instructions. New DB: DotNetNuke New User: DotNetNukeLogin New PW: DotNetNukePW I first created the user under Databases/Security/Login and made the default DB DotNetNuke. I then went under Databases/DotNetNuke/Security/Users and added that user to this DB, and made it db_owner where it says "Schemas Owned By This User" And "Database Roles Membership" * One odd thing - "Database Roles Membership" has a CHECK MARK, so its checked. But "Schemas Owned By This User" doesnt have a check mark, the box is filled instead, like its partially checked, and I am unable to edit this field. Not sure if this is pertinent. I did all this as per the DNN installation instructions. When I attempt to run the DNN installation Wizard, it says it cannot log in. If I change the DB path name, then it says it cannot locate the server, so I know their login page is seeing the DB but doesn't have rights to log in. I then went back to SQL Server Management Console and attempted to Connect to the DB using the username and PW I created above, instead of my windows authentication and this direct login fails as well. this leads me to believe the error is a SQL Server error not a DNN error. Any questions or thoughts? - JC