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!
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!