Ok I am at complete loss on this one, I've done everything I can think of, changed file permissions, even gave everyone full permissions to the app_data folder. The site works fine on my local box, the error occurs when I put it up at webhost4life.com. They
seem to have no clue. I even went to the trouble of taking all the aspnetdb.mdf tables/sprocs/views etc and moving them into my personal.mdf and I renamed the personal.mdf, etc. I still get the error posted below, if anyone has a clue please let me know, and
thanks.
User does not have permission to perform this action.
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: User does not have permission to perform this action.
Source Error:
Line 205: using (SqlCommand command = new SqlCommand("GetNonEmptyAlbums", connection)) { Line 206: command.CommandType = CommandType.StoredProcedure; Line 207: connection.Open(); Line 208: List<Album> list = new List<Album>(); Line 209: using (SqlDataReader reader = command.ExecuteReader()) {
webhost4life plan is the advance plan, says that my asp.net 2.0 stuff is working etc. From their faq docs I added the initial catalog to the connection strings.
User does not have permission to perform this action.
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: User does not have permission to perform this action.
Source Error:
Line 205: using (SqlCommand command = new SqlCommand("GetNonEmptyAlbums", connection)) { Line 206: command.CommandType = CommandType.StoredProcedure; Line 207: connection.Open(); Line 208: List<Album> list = new List<Album>(); Line 209: using (SqlDataReader reader = command.ExecuteReader()) {
AFAIK most online hosts do not directly support sqlExpress databases and XCopy deployment.
You will probably need to export the express database then reimport it to a WH4L MS SQL2005 DB.
The following are the databases scripts for the original version
Thats strange. They told me they didn't support SQL Express. Only SQL Server 2005 and SQL Server 2000.
You should Open a support ticket and be very detailed in your descriptions of what help you need. Webhost4life has always been very good about helping me resolve issues.
lol Jwad, that would make sense if that is the case, I did open a ticket titled "Sql Express" and they didn't say anything about not supporting it though.
Sometimes you have to be very specific with the Webhost4life guys to get a clear answer. I would open a new ticket or if you already have one open. Ask specifically, "Can I use SQL Server Express or do I have to use SQL Server 2005?"
The WH4L hosting ads http://www.webhost4life.com/hosting.asp do mention support for SQL 2005 Express under the advance plan. I think this is likely a fairly new option as
I had to manually convert mine to MS SQL2005 a while ago.
There is an upsizing tool that is available to
hosting providers.
psully1876
Member
40 Points
8 Posts
Error - User does not have permission to perform this action.
Feb 28, 2006 07:21 PM|LINK
User does not have permission to perform this action.
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: User does not have permission to perform this action.
Source Error:
Line 205: using (SqlCommand command = new SqlCommand("GetNonEmptyAlbums", connection)) {Line 206: command.CommandType = CommandType.StoredProcedure;
Line 207: connection.Open();
Line 208: List<Album> list = new List<Album>();
Line 209: using (SqlDataReader reader = command.ExecuteReader()) {
HS2k
Member
89 Points
22 Posts
Re: Error - User does not have permission to perform this action.
Feb 28, 2006 09:11 PM|LINK
Which plan did you take from webhost4life.com?
Cheers,
HS2k
http://www.digitalsnaps.info
psully1876
Member
40 Points
8 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 02:54 PM|LINK
add name="LocalSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=SSPI;User Instance=True;Initial Catalog=psullyPersonal;AttachDBFilename=|DataDirectory|\psullyPersonal.mdf" providerName="System.Data.SqlClient"
add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=SSPI;User Instance=True;Initial Catalog=psullyPersonal;AttachDBFilename=|DataDirectory|\psullyPersonal.mdf" providerName="System.Data.SqlClient"
webhost4life plan is the advance plan, says that my asp.net 2.0 stuff is working etc. From their faq docs I added the initial catalog to the connection strings.
mumfie2003
Participant
1198 Points
242 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 05:38 PM|LINK
AFAIK most online hosts do not directly support sqlExpress databases and XCopy deployment.
You will probably need to export the express database then reimport it to a WH4L MS SQL2005 DB.
The following are the databases scripts for the original version
http://www.microsoft.com/downloads/details.aspx?FamilyId=2EE85ED4-7613-47E2-8375-17222B150E4F&displaylang=en
http://www.colin-munford.me.uk
psully1876
Member
40 Points
8 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 07:04 PM|LINK
jwadsworth
Contributor
2378 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 08:18 PM|LINK
Here is what I use on WebHost4life. I am on the advanced plan as well.
<
connectionStrings><!--
Connection for SQL 2005 Express --><!--
add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"/--><!--
Connection for SQL Server 2005 --><
add name="Personal" connectionString="Server=IPAddressOfTheDataServer;user id=YourDBUser;password=DBUserPassword;database=YourDataBaseName" providerName="System.Data.SqlClient" /><
remove name="LocalSqlServer"/><!--
Connection for SQL 2005 Express --><!--
add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"/--><!--
Connection for SQL Server 2005 --><
add name="LocalSqlServer" connectionString="Server=IPAddressOfTheDataServer;user id=YourDBUser;password=DBUserPassword;database=YourDataBaseName" providerName="System.Data.SqlClient"/></
connectionStrings>Extended Personal Site Starter kit
jwadsworth
Contributor
2378 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 08:24 PM|LINK
Thats strange. They told me they didn't support SQL Express. Only SQL Server 2005 and SQL Server 2000.
You should Open a support ticket and be very detailed in your descriptions of what help you need. Webhost4life has always been very good about helping me resolve issues.
Extended Personal Site Starter kit
psully1876
Member
40 Points
8 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 08:26 PM|LINK
jwadsworth
Contributor
2378 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 09:06 PM|LINK
Sometimes you have to be very specific with the Webhost4life guys to get a clear answer. I would open a new ticket or if you already have one open. Ask specifically, "Can I use SQL Server Express or do I have to use SQL Server 2005?"
Extended Personal Site Starter kit
mumfie2003
Participant
1198 Points
242 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 10:06 PM|LINK
The WH4L hosting ads http://www.webhost4life.com/hosting.asp do mention support for SQL 2005 Express under the advance plan. I think this is likely a fairly new option as I had to manually convert mine to MS SQL2005 a while ago.
There is an upsizing tool that is available to hosting providers.
http://weblogs.asp.net/scottgu/archive/2005/10/15/427581.aspx
Please post the instructions if you get it working on WH4L.
http://www.colin-munford.me.uk