|
By toomuchpresha - Tue 23 Nov 2010
|
Hi all,
Im having a nightmare installing this thing!
I have upgraded from 6.1pro and first I couldnt do the upgrade on my 64bit machine so I had to do it on another machine then when I backed up the upgrade and database and transferred it back to my 64bit development machine it all goes pear shaped!
I keep getting the error
The EXECUTE permission was denied on the object '_spKartrisConfig_GetforCache', database 'ryansdirect', schema 'dbo'.
Can anyone help me before I decide to bin it and go back to the 6.1pro??
Thanks in advance!
Rog
|
|
By Paul - Tue 23 Nov 2010
|
Hi Rog
This is a permissions problem. Typically an ASP site will run as the IUsr account on the machine (sometimes it will be called 'IUSR_[machinename]'). But an ASP.NET one will normally run as one of the following users:
ASPNET
Network Service
It is also possible to get an ASP.NET site to run using the IUSR account if you have the following in the web.config file:
<identity impersonate="true"/>
(this tag should be present already, but with 'false' set as default)
Keep it as false for now.
Whichever user your site runs as needs to be given permission to use the database.
To do this, open up SQL Server management studio, and under the SQL server find the 'security', then 'logins' folder. Right click it and do 'New Login'.
Keep 'windows authentication' selected and click 'search'. A dialogue will appear - click 'advanced' and then 'find now' and then select both the following accounts:
ASPNET (if there is one)
NETWORK SERVICE
Once these are added, expand the database itself and then in the security folder under it, you should find a 'users' folder. You should now see ASPNET (if there was one) and NETWORK SERVICE listed.
Right click each and do 'properties'. For both, in the 'role owners' window, check 'db_owner'.
This should give your web site permissions to use the database now.
Let me know if this works - if not, be patient, we will definitely get it working.
|
|
By toomuchpresha - Tue 23 Nov 2010
|
Hi Paul,
Still nothing i'm afraid.
There was no ASPNET available just the NETWORKSERVICE (screenshot attached)
Same error as before. What I cant understand is that is works perfect on my laptop running the same Win7 Ultimate OS except it has a 32x system. My dev machine that is having the issues is on a 64x machine.
Could this be an issue?
If its not an issue, is there anything else you can suggest?
When I first installed the site using the win platform, it worked with an empty DB but had trouble showing the styles.
Now I have upgraded the Access DB from the old site ready to go into Kartris its giving me the problems.
I have crossloop installed if you want to dial in
Rog
|
|
By toomuchpresha - Tue 23 Nov 2010
|
I found the solution. I added the NETWORKSERVICE user to the security in the physical folder.
The only thing that I cant get working are the styles in the themes!
|
|
By toomuchpresha - Tue 23 Nov 2010
|
One thing after another!!
now I cant access admin. I get:
You do not have permission to view this directory or page because of the access control list (ACL) configuration or encryption settings for this resource on the Web server.I cant use any of the passwords or reset the admin password because the datatool tells me that I have an invalid web.config file!!!
Anyone got any ideas before I give up?
|
|
By toomuchpresha - Tue 23 Nov 2010
|
Yet another error...
Server Error in '/' Application.
Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: The resource object with key 'AdminBar_EditThisPage' was not found.
Source Error:
Line 184: <asp laceHolder ID="phdEditThisPage" runat="server">
Line 185: <li class="KartrisMenu-Leaf menudivider">
Line 186: <asp:HyperLink ID="lnkEditThisPage" runat="server" ToolTip="<%$ Resources: AdminBar_EditThisPage %>"
Line 187: Text="<%$ Resources: AdminBar_EditThisPage %>"></asp:HyperLink>
Line 188: </li> |
Source File: /UserControls/Front/AdminBar.ascx Line: 186
Thats it. im done with it!!
Back to the old version for me. very disappointed!
|
|
By Paul - Wed 24 Nov 2010
|
The last error seems to be for the same reason as this one:
http://freeaspnetcart.com/Topic195.aspx
|
|
By toomuchpresha - Wed 24 Nov 2010
|
Hi Paul,
No, nothing worked with that one. I have it working on my laptop to show the client so it gives me a day breathing space.
Everything seems to go pear shaped on a 64bit machine for some reason. Its perfect on my 32bit machine apart from 1 thing...
I cannot get into the admin area with any of the passwords I have. The datatool wont recognise the web.config as a valid file in order to reset it either.
Is there anything you can suggest?
Rog
|
|
By Mart - Wed 24 Nov 2010
|
Some users have had a problem with the password reset on the data tool. Fortunately there is another way you can reset the password, via the web based installer...
http://www.freeaspnetcart.com/Topic201.aspx
|
|
By toomuchpresha - Fri 26 Nov 2010
|
|
This is resolved now guys. Many thanks
|