[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1071
  • Last Modified:

SQL Server Error message

I am trying to run a stored procedure which may create temporary tables. When I try to run it it gives the following error message:
Executed as user: NT AUTHORITY\SYSTEM. Invalid object name '9b9e4463b6344b849407fc65a21b5d47PolicyResults1'. [SQLSTATE 42S02] (Error 208).  NOTE: The step was retried the requested number of times (1) without succeeding.  The step failed.
Please help!
0
hraja77
Asked:
hraja77
1 Solution
 
Ashish PatelCommented:
Please check the db owner access on the database where you are creating temporary table ie. may be tempdb and provide access create, alter etc rights.
0
 
imran_fastCommented:
That account needs the permission. Give this NT AUTHORITY\SYSTEM read write permission on your user database.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now