Could not find stored procedure
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6846
Printed Date: 03 April 2026 at 9:55pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Could not find stored procedure
Posted By: tjack13
Subject: Could not find stored procedure
Date Posted: 30 October 2003 at 7:19am
|
Hello, I am completely new to ASP and need some help. I have created the a SQL database and run msSQL_server_setup.asp. When I try to access the forum/default.asp I get the following error: Error Type: I checked the database and sure enough there are no stored proceedure, or any tables other than the defaults. When I ran the msSQL_server_setup.asp I didn't get any errors, though I didn't get any message that the setup was successful either. Thanks, tj |
Replies:
Posted By: michael
Date Posted: 30 October 2003 at 8:06am
|
Re-run the setup, you should get a message that the database has been
setup successfully. It should also give you an error message if
something failed.
------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: tjack13
Date Posted: 30 October 2003 at 9:00am
|
Hello, I had tried re-running the msSQL_server_setup.asp several times to no avail. I then rebooted the server, and also added the user I was running setup as, to the db_owner roll. Now it is working. Would perfer to not give user this role on a production box, what permissions exactly are required? Thanks, tj |
Posted By: fernan82
Date Posted: 30 October 2003 at 10:17am
|
If you read the msSQL_server_setup.asp page where you enter the password it says that dbo rights it's only required to run the setup..., I think it don't say it exactly like that but it says that the dbo password is not necesarily the passwords that the forums use. If it where the same then you wouldn't need to enter the user and password...
You need permissions to run stored procedures and to insert, update and delete all tables..., db writer/db reader won't doit... ------------- FeRnAN http://www.danasoft.com/"> 
|