Web Wiz Support and Community Forums : MS SQL forum https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 15:20:07 +0000 Mon, 25 Jul 2005 12:10:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15972 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MS SQL forum : done that - SQL server group--...]]> https://forums.webwiz.net/ms-sql-forum_topic15972_post87669.html#87669 Author: SUJO
Subject: 15972
Posted: 25 July 2005 at 12:10pm

done that - SQL server group--LOCAL--databases--forum--stored procedures--wwfxxxx and still nothing...Confused
 
it's weerd that I have to do that manually for so many lines - isn't there some kind of command or click, alowing the user right away that he/she can do that? Question
 
I would like to see the procedure from creating the database and user, that can login into the server, opening the database and doing with it all neccesary stuff - read+write+update+execute etc etc LOL
 
 
 
]]> Mon, 25 Jul 2005 12:10:16 +0000 https://forums.webwiz.net/ms-sql-forum_topic15972_post87669.html#87669 <![CDATA[MS SQL forum : this means the user that is used...]]> https://forums.webwiz.net/ms-sql-forum_topic15972_post87665.html#87665 Author: dj air
Subject: 15972
Posted: 25 July 2005 at 11:33am

this means the user that is used to connect to the SQL server doesn'thave access (execute) permssions enabled within that account

if using Enterprise manager to edit the server, you need to right clickthe stored procedures and then on the line with the connecting usernameallow executing permissions
]]> Mon, 25 Jul 2005 11:33:00 +0000 https://forums.webwiz.net/ms-sql-forum_topic15972_post87665.html#87665 <![CDATA[MS SQL forum : Hi! I have private server running...]]> https://forums.webwiz.net/ms-sql-forum_topic15972_post87648.html#87648 Author: SUJO
Subject: 15972
Posted: 25 July 2005 at 8:04am

Hi!

I have private server running windows server 2003 + MS SQL 2000. I created blank database, installed forum succesfully - BUT - now I get this error when trying to access it:

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'forum', owner 'dbo'.

/forum/common.asp, line 283

I know that probably I did not set up database access correctly - but can somebody tell me where I got it wrong?
Many tnx in advance.]]> Mon, 25 Jul 2005 08:04:30 +0000 https://forums.webwiz.net/ms-sql-forum_topic15972_post87648.html#87648