Execute permission denied

From: Jon (jsb_at_watersteward.com)
Date: 08/28/04

  • Next message: Gordzilla: "Re: Login failed for user 'sa'." 
    Date: Fri, 27 Aug 2004 16:42:16 -0700

    I am accessing an s2k database from a web app using .net.
    My server died and I had to reinstall s2k and now I am
    getting "Execute permission denied" on my stored
    procedures. The web app has not changed so I infer that
    something's wrong with the setup on the database. The
    connection string is as follows:

    "Password=xxxx;Persist Security Info=True;User
    ID=WebUser;Initial Catalog=ScottWeb;Data
    Source=SRV;Trusted_Connection=Yes"

    WebUser exists and has owner permission on the db.

    Thanks for any help.

  • Next message: Gordzilla: "Re: Login failed for user 'sa'."

    Relevant Pages

    • Re: Host Headers after Migration - Help!!!
      ... Set the Host Header in the table of the WSS2 content database to the URL that you used to Create the WSS3 Web App ... It seems to be a bug in WSS 3.0 admin tools that leaded to this issue. ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: Connection issues between .Net framwok and SQl Express 2005
      ... The problem you are experiencing is the installation of the membership ... database is a destructive "update" that requires an exclusive lock. ... try setting up a desktop app and a web app with the same ... Is there a way to make the the membership database a non destructive ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Requirements to Run ADO.NET Application
      ... Jet database can be used in web app in certain extent, ... So, if you r web app needs database, learning SQL Server is the easiest. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
      ... It's also your job to warn your boss when he asks for something that is just ... > database and the file can't reside elsewhere ... ... >>> In my Web App i have an upload feature and I've discovered that if i ... >>> The second problem with this is that while the upload is still writing ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Using a Web Service for Business Logic BackEnd / Data Layer
      ... If you're talking to your databases via something like nNibernate, there's an initialization phase when setting up nHibernate where it builds an map telling it how objects relate to database objects. ... and to achieve that "just once" scenario in a web app you need to override the Application_Startevent of the global.asax file and make sure you store a thread safe reference to the object map in a static member that is accessible to all the other threads in your web app. ... Alternatively, you can have an NT Service application running a WCF service or something, which takes care of all the DB work and initializes that object map once and only once - when the operating system boots and the service gets loaded. ...
      (microsoft.public.dotnet.framework.aspnet)