Re: Execute permission denied

• Previous message: Steven Xu: "How to get create temp table permission for a user"
• In reply to: Jon: "Execute permission denied"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Sun, 29 Aug 2004 14:47:25 +0530

Hi,

After the reinstall of SQL 2000, did you restore the Master database and
then followed the restore of all user databases. If it is the case then
all the permissions for all Logins and users will be syncronized back.
If you have not resored the Master database then the SID in sysLogins table
will not syncronize with sysusers table. Refer the system procedure
"sp_change_users_login" in books online. This will re-sync the logins and
users.

Thanks
Hari
MCDBA

"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.

• Previous message: Steven Xu: "How to get create temp table permission for a user"
• In reply to: Jon: "Execute permission denied"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]