CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: NewsGroup Date Entered: 10/12/2004 1:35:28 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 29 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
JGriffiths
Asp.Net User
Permissions problem10/12/2004 1:35:28 PM

0/0

I have just installed the eCommerce starter kit (everything installed locally); it was the VB version for Visual Studio, using SQLServer 2000.

It runs fine when I run it from the browser.

However, when I run it through Visual Studio (2003), I get an error message. It's obviously a permissions thing but have given all likely suspects access to my MASTER database but to no avail. Any suggestions?

Error below:
--------------------

EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

Source Error:


Line 63:
Line 64: ' Execute the command
Line 65: myConnection.Open()
Line 66: Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 67:


Source File: C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBVS)\CommerceVBVS\Components\ProductsDB.vb Line: 65

Stack Trace:


[SqlException: EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
System.Data.SqlClient.SqlConnection.IssueSQLDebug(UInt32 option, String machineName, UInt32 pid, UInt32 id, String sdiDllName, Byte[] data)
System.Data.SqlClient.SqlConnection.CheckSQLDebug(SqlDebugContext sdc)
System.Data.SqlClient.SqlConnection.CheckSQLDebugOnConnect()
System.Data.SqlClient.SqlConnection.OpenWithDebugger()
System.Data.SqlClient.SqlConnection.Open()
ASPNET.StarterKit.Commerce.ASPNET.StarterKit.Commerce.ProductsDB.GetProductCategories() in C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBVS)\CommerceVBVS\Components\ProductsDB.vb:65
ASPNET.StarterKit.Commerce.C_Menu.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBVS)\CommerceVBVS\_Menu.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


craigt-from-atl
Asp.Net User
Re: Permissions problem10/20/2004 4:29:01 PM

0/0

Looks like it has something to do with debugging on the SQL server. Do you have SQL Server debugging turned on in the solution? Try turning it off to see what happens.
-Craig

craigtown.com
U-Sports.net - Taking Fantasy Football to School
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Mastering Mac OS X Authors: Todd Stauffer, Kirk McElhearn, Pages: 878, Published: 2003
Apache Security: The Complete Guide to Securing Your Apache Web Server Authors: Ivan Ristic, Pages: 396, Published: 2005
Mac OS X: The Missing Manual Authors: David Pogue, Pages: 712, Published: 2002
The MAC OS X Command Line: Unix Under the Hood Authors: Kirk McElhearn, Pages: 438, Published: 2004
Essential CVS Authors: Jennifer Vesperman, Pages: 320, Published: 2003
Legal Guide to Web & Software Development Authors: Stephen Fishman, Pages: 528, Published: 2007
Mac OS X Power Tools Authors: Dan Frakes, Pages: 656, Published: 2004
The Book of Postfix: State-of-the-Art Message Transport Authors: Ralf Hildebrandt, Patrick Koetter, Pages: 464, Published: 2005
Network+ Exam Cram 2 (Exam Cram N10-002): Exam N10-002 Authors: Mike Harwood, Ed Tittel, Scott Reeves, Pages: 480, Published: 2002

Web:
Troubleshooting permissions problems One of the most common problems is insufficient folder or file permissions. If your database is located on a Windows 2000 or Windows XP computer and you ...
The Permission Problem: Financial Page: The New Yorker The Permission Problem. by James Surowiecki August 11, 2008 ... Or take a problem that bedevils the oil-and-gas industry. When different companies own ...
How To Troubleshoot IUSR_machine Permissions Problem The following information is meant to provide general guidelines for troubleshooting permissions problems with the IUSR_machinename anonymous account and ...
TinyMCE Forum / Auto resize permissions problem Jan 15, 2009 ... TinyMCE is a platform independent web based Javascript HTML WYSIWYG editor control released as Open Source under LGPL by Moxiecode Systems ...
Apache::Session permissions problem Apache::Session permissions problem. Eric Schwartz Fri, 12 Sep 2003 18:45:48 - 0700. I found a pretty useful article at ...
permissions problem - Hackint0sh Hi there, I'm actually getting pretty desperate now so I would appreciate any advice. Please bear in mind that I am not really knowledgeable about.
Import Permissions Problem | Gallery I created a regular user and changed permissions on the album that the user should own. There is only one problem. This change doesn't seem ...
Joomla! • View topic - Error installing component - permissions ... The error message tells me you have a problem with your FTP user. Either it doesn't have the right permissions to change the files under Joomla! root folder ...
Permissions Problem - Mac Forums Permissions Problem Mac Basics and Help. ... Having a weird problem with permissions. An (unknown) group seems to be attached to all of my ~ files. ...
SFTP home folder permissions problem RE: SFTP home folder permissions problem - 9/10/2008 4:10:48 PM ... RE: SFTP home folder permissions problem - 10/30/2008 10:13:44 AM ...

Videos:
Disk permission Bootcamp problem...part1 This is my bootcamp problem please post comments with answers for this problem or question if you have!!!
Disk permission/Bootcamp problem part2 This is my bootcamp problem please post comments with answers for this problem or question if you have!!!
Core Patterns for Web Permissions Google TechTalks July 19, 2006 Tyler Close Visiting Scientist Hewlett-Packard Laboratories Mr. Close is a researcher and developer ...
Teen overcomes stuttering problem, encourages others to do ... The broadcast is from WAVE 3 TV, Louisville, Ky. It is used by the Stuttering Foundation with permission. www.stutteringhelp.org
Velvet Revolver Cancels Tour, Paul McCartney & Death ... www.GetTheDaily.com your daily online video news source. Music news: On the music scene: Velvet Revolver cancels a tour, why Paul McCartney ...
Simple Method: install SNES Emulator & Roms On 2.2 iPhone 1st ... 91 assistant (iPhone PC suite 2.3.0.85) Download location: http://dl.sj.91.com/pcsuite/91assistant.exe?ADBillItemID=5145 Location to put ...
StealthAUDIT Overview Large IT shops everywhere are improving their operations with new technology platform from STEALTHbits Technologies. With just one product, you ...
Some of my pictures and copyright problem I had a little problem trying to get permission to borrow a few songs for a couple of my videos. If you know how to get permission, please feel ...
Mac OS X Dock problem - Icon doesn't stay? Just watch and you'll see. I have custom icons set for a stack of folders. The first icon doesn't seem to want to stay because whenever the dock ...
Vista - deleting files when permission is denied... This fixes problems where the object is not owned by a user on your system. If you are having problems with a locked file/folder try "wholockme ...




Search This Site:










referencing master page - tab like <li><a href

commercial use?

installation issue

error while running project

how can i create trial version of asp.net application ??

currency picker

how do you re-compile the dll

question on how the project deals with connections

error installing. please help!

htm files in vbvs

question about accessing override method in search

exporting the sql db to a production sql server?

converting the nvarchar to ntext. help.

can't install!

ibuyspy store and paypal

admin tool.

ibuyspy emptycart

how can execute the storedb.sql under the msde enviroment?

integrating paypal shopping cart

testing for cookies and javascript

how do u configure cassini web server to view ibuy spy site

cannot see the commercecsvs default page

commerce starter kit - where is the database?

shipping & handling calculation ?

linking actions to images

iis problem

posting an authorized/declined notification to my db

login/build problem

post back to previous page....help..!

foreign username is correct?

  Privacy | Contact Us
All Times Are GMT