数据库问题 [英] Database problem

问题描述

尊敬的先生，

我已经建立了一个基于家庭的Web服务器，可以从另一台PC访问我的网站.
当我从自己的PC访问数据库时，它工作正常，但是当我尝试
时 从另一个pc数据库部件访问无法正常工作，它显示错误
如下:
对对象"procS_TBL_STUDENT_MARKS_STATUS_BY_SEATNO"，数据库"NatsunEduDB"，模式"dbo"的执行权限被拒绝."
>
请回复我

谢谢与问候
sanju

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

推荐答案

尝试在procS_TBL_STUDENT_MARKS_STATUS_BY_SEATNO上使用GRANT EXECUTE ON [storedProcName] TO [userName] ，以确保您为访问此存储过程的用户提供了适当的权限.

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.

像
一样对您的数据库进行渗透 sysadmin,public,security Admin,serveradmin等.
并尝试访问它.

转到您的数据库->右键单击它->属性->您可以看到权限.

您可以在其中设置用户权限.

如果仍然有问题，请检查访问的系统用户是否具有数据库权限.

问候，
Kiran.

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.

如果您使用的是Windows环境和MSSQL，则很像您是使用Windows身份验证来建立数据库连接的.当您尝试从另一台计算机进行连接时，它将引发错误.

您需要将其更改为SQL Server身份验证.
您必须在MSSQL中创建一个新的登录名，设置用户名和密码，并在连接字符串中使用它.然后，使用哪台计算机访问网站都没有关系.

祝你好运

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

这篇关于数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！