Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP! Table Permissions.

Status
Not open for further replies.

jcs1953

IS-IT--Management
Nov 28, 2007
53
US
I need some help quick. I have to present my website to the client this afternoon.
IIS on 2000 Server on doc-server
SQL Server 2005 Express on doc-server
ASP.NET 2.0
Visual Web Developer 2005 Express on doc-server
I added a table to an existing SQL database. All tables in the database need read only (select)access except for tempQuery which needs Delete,Update, Insert and Select. When I run the website through Web Developer everything works great. However when I try to it through the internet or intranet (localhost) it works until I need to do something with tempQuery and then gives this error:
Cannot find the object "tempQuery" because it does not exist or you do not have permissions.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot find the object "tempQuery" because it does not exist or you do not have permissions.

Source Error:


Line 99: Dim cmd As New SqlCommand(strSQL, conn)
Line 100: cmd.Connection.Open()
Line 101: cmd.ExecuteNonQuery()
Line 102: End Function
Line 103: Public Shared Function GetSQLTQResults() As DataTable

Line 101 is highlighted. I know I can read from the database because it gets past the login and that data is in the database. So it seems to be a permission problem.
Am I correct in assuming that the user is IUSR_Doc-Server? I added that use to the domain and set permissions in the database but it still won't work.
Any help would be greatly appreciated!
 
Got it figured out. Had to add aspnet user.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top