Database problem

Question

0.00/5 (No votes)

See more:

Dear sir,

I've set up a home-based webserver, I can access my website from another pc .
when i access database from my own pc it is working properly, but when i tried
to accessed from another pc database part is not working,it displayed the error
that are as follow:
"EXECUTE permission denied on object 'procS_TBL_STUDENT_MARKS_STATUS_BY_SEATNO', database 'NatsunEduDB', schema 'dbo'."
>
Kindly response me

Thanks & Regards
sanju

Posted 12-Nov-10 1:36am

vsanju

Add a Solution

Comments

Sunasara Imdadhusen 12-Nov-10 7:49am

Could you able to connect it with SQL Server Management Studio?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2010-11-12T01:42:00

Solution 2

Try using GRANT EXECUTE ON [storedProcName] TO [userName] on 'procS_TBL_STUDENT_MARKS_STATUS_BY_SEATNO' to make sure you give the appropriate permissions to the user accessing this stored procedure.

Posted 12-Nov-10 1:42am

Abhinav S

Kirankumar Ballapalli · Answer 2 · 2010-11-12T01:42:00

Solution 1

Hi,

Give the permision to your database like
sysadmin,public,security Admin,serveradmin etc..
And try accessing it.

Go to your database -> Right click on it -> Properties -> you can able to see the Permissions.

There you can able to set permissions to user.

If still you are having problem, check your accessed system user is having rights for the database.

Regards,
Kiran.

Posted 12-Nov-10 1:42am

Kirankumar Ballapalli

Updated 12-Nov-10 3:40am

v2

Comments

Sandesh M Patil 12-Nov-10 9:41am

Updated for better understanding. Simple solution

Ed Guzman · Answer 3 · 2010-11-12T14:32:00

If you are using windows environment and MSSQL , it very much looks like you set up the database connection using the windows authentication. When you try to connect from a different computer it throws the error.

You need to change it to SQL server authentication.
You have to created a new login into your MSSQL, setup user name and password and use it in your connection string. Then it does not matter which computer you are using to get the website.

Good luck