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.
It appears that the real error, got this after the site was reset and run for the first time, is in named pipes
System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error:
0 - No process is on the other end of the pipe.)
We are using SQL 2000 instead of SQL 2005 on our servers. How do I configure it to use it with SQL 2000? What is the backup file or mdf/ldf that we could attach to create this database under SQL 2000 server. We are using your customized kit.
My kit doesn't include any SQL 2000 support. In order to use SQL 2000, you will need to create database scripts using SQL Server Management Studio that are SQL 2000 compatible, and then create a database from those scripts.
If I install SQL 2005 along with SQL 2000 on the same machine will that be a conflict? Also can I use this kit as it is with SQL Express 2005 edition installed on the server will that work. As of now that is how it is and hence getting this error message.
What permissions am I missing on SQL Express 2005 as it is already installed on the server. I have also checked the SQL 2005 Express service running so it is running for sure.
I use SQL Server Management Studio Express to generate scripts. You would be much better off using SQL Express or SQL Server 2005. You should be able to use SQL Express on the server as long as the host server has SQL Express Installed. You’ll need to set
the following permissions on folders.
App_Data folder (Read, Write, Modify, for the Network Services account)
Albums folder (Read, Write, Modify, for the Network Services account)
Uploads folder (Read, Write, Modify, for the Network Services account)
None
0 Points
7 Posts
Error - User does not have permission to perform this action.
Feb 28, 2006 03:21 PM|psully1876|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:
Member
20 Points
22 Posts
Re: Error - User does not have permission to perform this action.
Feb 28, 2006 05:11 PM|HS2k|LINK
Which plan did you take from webhost4life.com?
Cheers,
HS2k
http://www.digitalsnaps.info
None
0 Points
7 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 10:54 AM|psully1876|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.
None
0 Points
241 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 01:38 PM|mumfie2003|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
None
0 Points
7 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 03:04 PM|psully1876|LINK
Member
130 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 04:18 PM|jwadsworth|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
Member
130 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 04:24 PM|jwadsworth|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
None
0 Points
7 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 04:26 PM|psully1876|LINK
Member
130 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 05:06 PM|jwadsworth|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
None
0 Points
241 Posts
Re: Error - User does not have permission to perform this action.
Mar 01, 2006 06:06 PM|mumfie2003|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
None
0 Points
7 Posts
Re: Error - User does not have permission to perform this action.
Mar 02, 2006 02:48 PM|psully1876|LINK
System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
None
0 Points
42 Posts
Re: Error - User does not have permission to perform this action.
Mar 06, 2007 06:24 PM|snehalrana|LINK
Hi Jeremy,
We are using SQL 2000 instead of SQL 2005 on our servers. How do I configure it to use it with SQL 2000? What is the backup file or mdf/ldf that we could attach to create this database under SQL 2000 server. We are using your customized kit.
Let me know
Thanks
Snehal Rana
Member
130 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 06, 2007 11:42 PM|jwadsworth|LINK
Snehal,
My kit doesn't include any SQL 2000 support. In order to use SQL 2000, you will need to create database scripts using SQL Server Management Studio that are SQL 2000 compatible, and then create a database from those scripts.
Extended Personal Site Starter kit
None
0 Points
42 Posts
Re: Error - User does not have permission to perform this action.
Mar 07, 2007 10:57 AM|snehalrana|LINK
Hi Jeremy,
If I install SQL 2005 along with SQL 2000 on the same machine will that be a conflict? Also can I use this kit as it is with SQL Express 2005 edition installed on the server will that work. As of now that is how it is and hence getting this error message. What permissions am I missing on SQL Express 2005 as it is already installed on the server. I have also checked the SQL 2005 Express service running so it is running for sure.
Please advice.
Thanks
Snehal
Member
130 Points
542 Posts
Re: Error - User does not have permission to perform this action.
Mar 07, 2007 11:40 AM|jwadsworth|LINK
I use SQL Server Management Studio Express to generate scripts. You would be much better off using SQL Express or SQL Server 2005. You should be able to use SQL Express on the server as long as the host server has SQL Express Installed. You’ll need to set the following permissions on folders.
Extended Personal Site Starter kit
None
0 Points
42 Posts
Re: Error - User does not have permission to perform this action.
Mar 07, 2007 11:54 AM|snehalrana|LINK
Permissions are as set correctly, still no luck.
Thanks
Snehal
Member
24 Points
45 Posts
Re: Error - User does not have permission to perform this action.
Jun 23, 2007 11:56 AM|ccharneca|LINK
Hi there!
What you have to do is to add a line in your web.config file.
Try this inside <system.web>
<identity impersonate="true" userName="ServerName\login" password="p455w0rd" />
I hope that I could help you.
database database hosting Security web.config
Member
15 Points
239 Posts
Re: Error - User does not have permission to perform this action.
Nov 16, 2008 05:16 AM|extinct_pirate|LINK
how about if the website is in a host site?
we can't use identity impersonate here,
please help, we also have no luck here
http://thedailyarr.tk
http://www.ftpx.com/index.html