|
toomuchpresha
|
Posted Tue 23 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
Paul
|
Posted Tue 23 Nov 2010
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
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.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
toomuchpresha
|
Posted Tue 23 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
Capture.JPG
(2 views,
387.33 KB)
|
|
|
|
|
toomuchpresha
|
Posted Tue 23 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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!
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
toomuchpresha
|
Posted Tue 23 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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?
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
toomuchpresha
|
Posted Tue 23 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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!
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
Paul
|
Posted Wed 24 Nov 2010
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
The last error seems to be for the same reason as this one:
http://freeaspnetcart.com/Topic195.aspx
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
toomuchpresha
|
Posted Wed 24 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
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
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
Mart
|
Posted Wed 24 Nov 2010
|
|
Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148,
Visits: 3,450
|
|
|
|
|
|
toomuchpresha
|
Posted Fri 26 Nov 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
This is resolved now guys. Many thanks
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|