database won't give correct permissions

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 374,019 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,757 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 1914 | Replies: 0

•

Join Date: Nov 2004

Location: Ohio

Posts: 24

Reputation: SquirrelProdigy is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

SquirrelProdigy SquirrelProdigy is offline

Offline

Newbie Poster

database won't give correct permissions

May 18th, 2005

Hi, I'm attempting to set up dotnetnuke with Microsoft's SQL MSDE as my database. After getting SQL up and running, I created a database aptly named dotnetnuke, and a login called dnnuser. I set dnnuser's role on dotnetnuke to system administrator and it's role membership to db_owner. After altering the main Default.aspx file for dotnetnuke with the correct name for localhost, the login, and the password. It should allow me to connect, but it doesn't. I get an HTTP 401.3 error saying I'm not autorized to view that page.

What should I check out to fix this?

Squirrel Prodigy