Re: EXECUTE permission denied on object 'sp_sdidebug', database 'm

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Dopierala Jr. (kdopierala2_at_wi.rr.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 09:12:16 -0500

Hi,

It is just your local machine where you are having problems right? Or are
you having the same problem with your production site and database? I think
you need to install SQL Server before installing VS.Net and the .Net
framework. That is the way I've alway done it. You might want to try to
re-install VS.Net and the framework and see if that clears things up now
that SQL is installed. There is probably a way to setup the permissions for
the aspnet account manually but I don't know how to do it. Good luck! Ken. 

-- 
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.
"Ken" <Ken@discussions.microsoft.com> wrote in message
news:202EF8A5-CFD0-46F1-90CE-CF2FC55E6E83@microsoft.com...
> Hi
>
> I'm geting some clues,
>
> > On my local machine I've never had to grant execute permissions for a
SP.
> > Did you have to do that before your restore?
> No
>
> >Did you install VS.Net before SQL Server?do anything to add
> Yes, is it not the order?
>
>  >Or after you
> > setup your machine the first time, way back, did you ever do anything to
add
> > the aspnet account or your Windows login account to the SQL Server
> > permissions list?
>
> Umm I remember I had another problem running the aspnet app (not this
one),
> and the only aditional thing I did was to run the Aspnet_regiis.exe
utility,
> should I have to run it again?
>
> also, I run the  'GRANT EXECUTE ON sp_sdidebug TO dbo' on my local Master
> Database, and nothing happen...the error is stil here
>
> by the way I'dont get why the master DB is involved...
>
> The production environmet is a hosting company, so I have only a user
> account on my Application DB not on Master DB, so I cant run the script...
>
>
> Ken
>
>

Relevant Pages

  • Re: new MSDE install fails with "instance name specified is invalid"
    ... > I am trying to put SQL Server 2000 and MSDE on same local machine. ... in order to install other SQL Server and/or MSDE instancese, ...
    (microsoft.public.sqlserver.security)
  • CAL question
    ... I have a CAL to access a SQL Server that is installed on a local network. ... Can I use this CAL to install the client tools of SQL Server (viz Enterprise ... Query Analyzer) on my local machine to access my MSDE ?? ...
    (microsoft.public.sqlserver.server)
  • CAL question
    ... I have a CAL to access a SQL Server that is installed on a local network. ... Can I use this CAL to install the client tools of SQL Server (viz Enterprise ... Query Analyzer) on my local machine to access my MSDE ?? ...
    (microsoft.public.sqlserver.setup)
  • Re: Accessing data from remote SQL Server.
    ... By default the ASPNET account password is generated per machine, ... the ASPNET password on your local machine does not match the password ... >ASP.NET application on this machine that accesses data from a SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Question related to Service Pack
    ... install phase), one of the aspfaq articles also has a few words on this. ... Tibor Karaszi, SQL Server MVP ... > 1) How do I find out which SP I have installed on my local machine (for ... > 3)I must have done something wrong becuase even after running SP3, ...
    (microsoft.public.sqlserver.setup)