Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 18th, 2008, 06:16 PM
Authorized User
 
Join Date: Feb 2008
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default File share website

Can someone tell me how to fix this error? I am trying to put this website in production using SQL server 2005. I even followed the instructions on imar.spaanjaars.com/quickDoeId.aspx?quickdoc=395 but nothing is working right.

I set all the execute permissions on all stored procedures for the ASPNET user in SQL server 2005.

Server Error in '/SendItNow' Application.
--------------------------------------------------------------------------------

The EXECUTE permission was denied on the object 'sprocResourceInsertUpdateItem', database 'FILESHAREDB.MDF', schema '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: The EXECUTE permission was denied on the object 'sprocResourceInsertUpdateItem', database 'FILESHAREDB.MDF', schema 'dbo'.

Source Error:


Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()
Line 46:


Source File: H:\MIS Department\Intranet\SendItNow\App_Code\Dal\Resourc eDB.vb Line: 44

my connection string is :

  <add name="ConnectionString"
       connectionString="Data Source= MISFS;Initial Catalog=FILESHAREDB.MDF;
       Integrated Security=true;"
   providerName="System.Data.SqlClient" />

Any help is appreciated. I have been trying to get this up and running since friday.

  #2 (permalink)  
Old February 18th, 2008, 06:24 PM
Authorized User
 
Join Date: Feb 2008
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I finally got this working now. I had to set execute permissions for the user NT AUTHORITY.



Similar Threads
Thread Thread Starter Forum Replies Last Post
about File share project netdemon BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 April 17th, 2008 08:06 PM
Wrox File Share c# Code b67 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 August 16th, 2007 12:42 PM
Wrox File Share - 1g file size limit b67 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 May 7th, 2007 04:24 PM
file in a share mode m_rajib74 C# 1 January 24th, 2007 03:26 PM
file in a share mode m_rajib74 C# 1 January 24th, 2007 03:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.