CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.getting_started Tags:
Item Type: NewsGroup Date Entered: 4/13/2004 12:18:58 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 10 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
MadMikeMorrison
Asp.Net User
DB User Permissions Question4/13/2004 12:18:58 AM

0/0

It figures...I searched the forums high and low and didn't find a solution. As soon as I post this, I stumble across something that might work...

(I was going to delete my post all together but don't see how).

Thanks,

-Mike
----------------------------------------------------

Okay, here we go.

I am in the process of upgrading to DNN 2.0.3, but I was having a few issues with my new hosting provider so I decided to start with a fresh install and then I'd upgrade later once I have the kinks ironed out.

I am using Vortex/Matrix hosting. I created a blank DB using HSphere (the control panel that they use) called TLDPortal. It created a blank DB with user dbo as the database owner. So far, no problem.

I have a user called TLDUser who has dbo priviliages. In the web.config I set connectionString to point to the DB and set databaseOwner =TLDAdmin (have also set defaultProvider = SqlDataProvider).

I point my web browser to the url and hit enter. I get the follwoing error:

"The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

Could not find stored procedure 'TLDPortal.GetPortals'."

I used the exact DB connection string in a test page and was able to retreive the syscolumns table (just as a test).

I used Enterprise Manager to look at the DB and no tables (just the default system tables where present) or stored procedures where created. Then I changed the web.config file so that the databaseOwner = dbo and received the following exception:

"EXECUTE permission denied on object 'GetDatabaseVersion', database 'TLDPortal', owner 'dbo'.

(plus all the exception stuff)"

I used Enterprise Manager to look at the DB again. No table where created but the following stored procedures where created:

FindDatabaseVersion
GetDatabaseVersion
UpdateDatabaseVersion

I hit refresh and got the original error.

Now, I don't have access to the password for user dbo (for obvious reasons). But, user TLDAdmin has database owner priviliages. I know it connected to the DB because it created the stored procedures.

Do I have to the password for user dbo because user dbo created the blank DB? Or, do i have to create the blank DB with TLDUser (I actually can't do this with HSphere)? Or, should I replace dbo.* with TLDAdmin in all the .sql scripts?

And, after I figure this out, I need to upgrde from my existing DNN DB.

Any help would be appreciated.

Thanks,

-Mike

MadMikeMorrison
Asp.Net User
Re: DB User Permissions Question4/15/2004 6:29:12 PM

0/0

Okay, I have gotten a clean install to work. I followed the insructions at:

http://johnchoi.europe.webmatrixhosting.net/

Thank you John! I really appreciate you sharing your solution.

Now I am working on the best way to get my existing DB to my hosting provider so I can try an upgrade. Actually, I'll probably do the upgrade locally and then figure out the best way to move that DB.

-Mike

2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
MCITP SQL Server 2005 Database Administration Exam Guide: (Exams 70-431, 70-443, And 70-444) Authors: Darril Gibson, Pages: 752, Published: 2007
A Question of Balance: Private Rights and the Public Interest in Scientific and Technical Databases Authors: National Research Council (U.S.). Committee for a Study on Promoting Access to Scientific and Technical Data for the Public Interest, Pages: 142, Published: 1999
MCTS: Microsoft SQL Server 2005 Implementation and Maintenance: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (Exam 70-431) Authors: Joseph L. Jorden, Dandy Weyn, Pages: 634, Published: 2006
SQL Server Security: covers SQL Server 2000 and SQL Server 7 security Authors: Chip Andrews, David Litchfield, David (David William) Litchfield, Bill Grindlay, Pages: 352, Published: 2003
MCAD/MCSD: Developing XML Web Services and Server Components with Visual C# . NET and the . NET Framework Authors: Amit Kalani, Ed Tittel, Pages: 1040, Published: 2003
Portable DBA: SQL Server Authors: Damir Bersinic, Stephen Giles, Pages: 352, Published: 2004
Microsoft SQL Server 2005 Express Edition For Dummies Authors: Robert Schneider, Stephen Giles, Pages: 408, Published: 2006
Beginning PHP and MySQL: From Novice to Professional Authors: W. Jason Gilmore, Pages: 1044, Published: 2008
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442): Exams 70-431, 70-441, and 70-442 Authors: Darril Gibson, Pages: 903, Published: 2008
Creating Database-backed Library Web Pages: Using Open Source Tools Authors: Stephen R. Westman, Pages: 268, Published: 2006

Web:
Managing Users Permissions The public role is a special database role to which each database user belongs. The public role contains default access permissions for any user who can ...
SQL Injection and DB user permissions in ASP Database SQL Injection and DB user permissions in ASP Database ... So this is probably a stupid question and, no doubt, there is a concept that ...
database user permissions ... - Mambo - A PHP & MySQL Content ... database user permissions ... General Questions. ... Wich permissions to the database should I give the user wich is defined in the config.php file ? ...
Database user permissions. - Parallels Server Products Forums Database user permissions. Plesk 8.3 for Linux Installation and "How do I" ... Plesk 8.6 for Linux Installation and "How do I" Questions ...
Database user permission - SQL Server - Tag: Database user permission. 6 · previous month on first day Newbie question. I am using a query that pulls month-to-date data that has the following ...
Scripting user permissions using catalog views in SQL Server 2005 ... Have you ever been asked to copy or clone the database permissions of one user to another database user? Or how about creating a new database role based on ...
LINQ and Database Permissions - Stack Overflow How do I generate a table of permissions granted to database tables for a database user? Multiple permission types (roles) stored in database as single ...
Mysql database permissions questions: msg#01227 ... denied to user xyz@xxxxxxx and xyz can only use the allowed database. help ! ... Next by Date: RES: Mysql database permissions questions, Ray da Costa ...
Shared Network Database User Permissions - Access World Forums Newbie Help - Database shared on a network + user permissions EDIT: .... NET, PHP & MySQL, Windows, Other Software, Hardware Questions and ...
SQL Server programming Default Database and Permissions Questions ... Default Database and Permissions Questions Again - Russell Fields ... Does " migrated all databases" mean "migrated all user databases but not master and ...

Videos:
PKM DB - First Ever Shiny Origin Forme Giratina Encounter ! I always planned on making a video of the Giratina for you guys, and today I decided to do it. So I went up to Giratina, saved, then started recordin...
PKM DB - Guide to making Wonder Card AR Codes! PLEASE READ THE DESCRIPTION Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give yo...
PKM DB - Changing Shaymin's Formes! [HQ] w/ Shiny Shaymin A video showing Shaymin switching from its Original (Land) Forme to its Sky Forme and vice versa. I will show how I got the Glacidia Flower and when ...
PKM DB - 2008 TANABATA DAISUKI CLUB Jirachi ( ジラーチ ) Event - JAP - Mystery Gift & Wondercard PLEASE READ THE DESCRIPTION Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give yo...
PKM DB - Tenimura ( Movie ) Regigigas Event - JAP - Wonder Card Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give you information on .pkm files, ...
video dating With the increase in high bandwidth internet access we are seeing a rise in online dating services that use your high speed capability to a great adv...
PKM DB - Shiny Rotom Forms Revealed ! Due to popular demand, I made a video showing the SHINY Rotom forms. They aren't very exciting, but I hope you guys enjoy it! For questions, comment...
PKM DB - 10th Deoxys Event - JAP - Mystery Gift & Wondercard PLEASE READ THE DESCRIPTION Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give yo...
PKM DB - WORLD08 Lucario Event - USA - Mystery Gift & Wondercard PLEASE READ THE DESCRIPTION Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give yo...
PKM DB - Woolworths ALAMOS Darkrai Event - UK - Mystery Gift & Wonder Card PLEASE READ THE DESCRIPTION Hey guys, welcome to another video brought to you by The Pokémon Database (The PKM DB). These videos are made to give yo...




Search This Site:










gooddogs repository v2.0.5 & dnn v2.1.2

access denied

using profile groups

exception while sending an email in asp.net 1.1

why my hyperlinks don't work correctly in masterpage?

can't delete an ad

hosting requirements on windows 2003 web edition server

hiding subdirectories in file picker drop-down list

smtpclient

global theme

base64encode

bug not in "known issues" list

how to communicate with another page

iis

can i get my other panes to stick around?

loading user control and then removing it

v3.1 fresh installation issue

can't get to dotnetnuke from anywhere bar the host server!!!

how to put a list property in my usercontrol

using password and salt with sha1

defect: filemanger - invalid currentpageindex value

asp.net 3.0 samples???

error when deploy my web site

sectionhead min/max not working after upgrade to 3.0.13

error dll

oledb

users who authenticate are not being redirected as they should

aspx file in sharepoint

problem with nunit & nunitasp

timeout in formsauthentication

 
All Times Are GMT