Knowledgebase: MS SQL

Access Denied Errors on Stored Procedures for MSSQL

Posted by on December 13 2013 03:33 PM

If your database has been imported, or you are receiving "ACCESS DENIED" errors on your stored procedures, this is due to the initially-created user permissions not being setup properly on the stored procedures. To correct this, you will need to create a second user.

This article assumes that you are already familiar with how to log in to the customer control panel. If you do not know how to log in or have forgotten your password, please refer to this article first.

  • On the control panel Home tab, click "Databases" under the Databases & Backups section

  • Select the database experiencing the issue

  • Select the Users tab, then click "Add Control Panel User".

  • Enter the new user name and password, then click Submit. Your new user should be created within a few minutes. If you want, you can delete the original user. You may need to update your code with the new user name.

If you have any further questions that were not answered in this article, please contact us.

(4 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Copyright © 2016 HostMySite