Re: Execute permission denied

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/12/04 

Date: Sun, 12 Sep 2004 10:16:13 -0500

To add to Hari's response, note that your connection string has conflicting
security credentials; both standard security (User ID and Password) and
Windows authentication (Trusted_Connection=Yes) are specified. To connect
with SQL authentication using the WebUser login, ensure your SQL Server is
configured to allow both Windows and SQL authentication and remove
Trusted_Connection from the connection string. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Jon" <jsb@watersteward.com> wrote in message 
news:1aa501c48c8f$7c4a42b0$a501280a@phx.gbl...
>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.

Relevant Pages