help

i am trying to use the Samples SQL Server to learn more about db programming in asp.net and I keep getting this error.

Code:

---

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

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 39:
Line 40:    Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 41:        oCon.Open()
Line 42:        Dim oReader As SqlDataReader = oCmd.ExecuteReader()
Line 43:
 

Source File: D:\temp\iis_outside_empty\nsite\ex\html\nw\test.aspx.vb    Line: 41

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()
  nsite.test.Page_Load(Object sender, EventArgs e) in D:\temp\iis_outside_empty\nsite\ex\html\nw\test.aspx.vb:41
  System.Web.UI.Control.OnLoad(EventArgs e) +67
  System.Web.UI.Control.LoadRecursive() +35
  System.Web.UI.Page.ProcessRequestMain() +731

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

---

I don't know what the problem is. The installed sample run fine, but I can't acces the thing from my pages.....?

Help. Thanks.

VB Code:

oCon.ConnectionString = "data source=Z-BOX\NetSDK;initial catalog=pubs;integrated security=SSPI;persi" & _
        "st security info=False;packet size=4096"

It seems that the windows account ASP.NET doesn't have EXECUTE permissions for that database. Add the permissions in SQL Server and you should be all good. Or impersonate an account that already has those permissions.

okay. I understand that. But how do I add the asp.net account to sql server? I don't have the sweet gui that comes with the full version I have the one that comes with the .net framework sdk.

I thought there was a way in the Database Utilities section or around there. If not then try some of these:
http://dbforums.com/t902588.html
http://msdn.microsoft.com/library/de...sderoadmap.asp

I checked that and tried to give aspnet use and it said it had use. I just went ahead and used an access db. Although I wish I knew why it won't work...

Expand SECURITY in the SQL Server Enterprise Manager Tool.

Add a new account under LOGINS

Browse to add the account and make sure your computer is the selected source location.

You should see the ASP.Net account

If you have problems locating it, you can also add it by typing the name directly in like so:

COMPUTERNAME\ASP.Net Account

I don't have the full blown sql server have MSDE I think is what it's called. What I don't understand is that the .net quickstart samples access the data base fine and i see it perfectly well in the IDE in vs.net but my code erros out with that error. Also I don't see why it know why it throw on master and the others when I'm hitting northwind for data.

I wish I did have SQL Server. I would be loving life. Is that the problem that I am using MSDE?

On some level, yes. But, based on the error, I think it is fixable, you will just have to find where those permissions are granted....