1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Kentico ASP CMS

Discussion in 'C#' started by dymac, Mar 13, 2008.

0
  1. #1
    I have been trying to install kentico ASP CMS on my godaddy hosting account and can't for the life of me get it to work.

    I have a shard windows hosting account. The CMS has a web installer but I can't get past the create database step. This is the error message I get

    An error occured when creating database: [DataConnection.ExecuteQuery]: Query: CREATE DATABASE [KenticoCMS] COLLATE SQL_Latin1_General_CP1_CI_AS: caused exception: CREATE DATABASE permission denied in database 'master'.
    Creating a new database KenticoCMS



    I know very little about asp or windows hosting.

    Any Ideas?
     
    dymac, Mar 13, 2008 IP
  2. justkidding

    justkidding Active Member

    Messages:
    937
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    I hope it's trying to create tables in 'master' database, check the queries and try to point your queries to your own database on godaddy's DB server.
     
    justkidding, Mar 13, 2008 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Shared hosting will almost never give you permission to run scripts to create databases. You would normally create the db with the appropriate name etc manually, delete that line from the ASP script and it can then create the tables etc as normal.
     
    AstarothSolutions, Mar 13, 2008 IP
  4. dymac

    dymac Member

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #4
    LOL....If you only knew how little I know about this stuff. I have no idea what you mean, but thanks. I figured since Kentico came with an installer that all I would have to do is follow the instructions. I'm sure its something really simple too.

    Thanks anyways
     
    dymac, Mar 13, 2008 IP
  5. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Ok.... the 101 version :)

    Your website sites on a PC owned by GoDaddy. As well as your site being on there there is up to a couple of hundred other websites (shared hosting). To stop you running programs that will either damage other peoples websites who share the same machine or to stop you exceeding the limits they have placed on your accounts (eg 1 database) they have disabled certain commands being run.

    One of the commands that is disabled is the ability to create new databases, to be able to do this you must use the control panel they have given you. Therefore what you need to do is manually create the database using the control panel and then modify the install script to remove the command to create the new database
     
    AstarothSolutions, Mar 13, 2008 IP
  6. dymac

    dymac Member

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #6
    Oh, I get what your saying. If I post the code of the install script can you tell me exactly what to take out?

    Here is the first half of the install script.

    <%@ Page Language="C#" Inherits="CMSDeskInstall" CodeFile="install.aspx.cs" Theme="Default" %>

<%@ Register Src="~/CMSAdminControls/RequireScript.ascx" TagName="RequireScript"
    TagPrefix="uc2" %>
<%@ Register Assembly="CMS.ExtendedControls" Namespace="CMS.ExtendedControls" TagPrefix="cc1" %>
<%@ Register Src="LicenseDialog.ascx" TagName="LicenseDialog" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>CMS Database Installer</title>
    <style type="text/css">
        body
        {
            margin: 0px;
            padding: 0px;
            height: 100%;
        }
       
        .ButtonsPanel
        {
            padding-top: 10px;
        }
    </style>
</head>
<body class="InstallBody">
    <form id="Form1" method="post" runat="server">
        <asp:Literal ID="ltlScript" runat="server" EnableViewState="false" />
        <uc2:RequireScript ID="rqScript" runat="server" />
        <asp:Panel runat="server" ID="pnlBody" SkinID="InstallerBody">
            <asp:Label ID="lblHeader" SkinID="InstallHeader" runat="server"></asp:Label>
            <asp:Panel runat="server" ID="pnlWizard" SkinID="InstallerContent">
                <asp:Button ID="btnHidden" runat="server" SkinID="HiddenButton" OnClick="btnHidden_onClick" />
                <asp:Wizard ID="wzdInstaller" runat="server" DisplaySideBar="False" OnPreviousButtonClick="wzdInstaller_PreviousButtonClick"
                    ActiveStepIndex="1">
                    <StepNavigationTemplate>
                        <div id="buttonsDiv" style="padding: 10px 10px 0px 0px">
                            <cc1:LocalizedButton ID="StepPrevButton" Source="file" runat="server" CommandName="MovePrevious"
                                Text="{$Install.BackStep$}" />
                            <cc1:LocalizedButton UseSubmitBehavior="True" Source="file" ID="StepNextButton" runat="server"
                                CommandName="MoveNext" Text="{$Install.NextStep$}" OnClientClick="NextStep(this,document.getElementById('buttonsDiv'));" />
                        </div>
                    </StepNavigationTemplate>
                    <StartNavigationTemplate>
                        <div id="buttonsDiv" style="padding: 10px 10px 0px 0px">
                            <cc1:LocalizedButton UseSubmitBehavior="True" Source="file" ID="StepNextButton" runat="server"
                                CommandName="MoveNext" Text="{$Install.NextStep$}" OnClientClick="NextStep(this,document.getElementById('buttonsDiv'));" />
                        </div>
                    </StartNavigationTemplate>
                    <WizardSteps>
                        <asp:WizardStep ID="stpUserServer" runat="server">
                            <table border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td class="TopLeftCornerInstall">
                                    </td>
                                    <td class="TopMiddleBorderInstall">
                                    </td>
                                    <td class="TopRightCornerInstall">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="3">
                                        <table class="InstallWizard" border="0" cellpadding="0" cellspacing="0">
                                            <tr>
                                                <td colspan="2">
                                                    <asp:Label ID="lblSQLServer" runat="server" SkinID="InstallGroupTitle"></asp:Label>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td nowrap="nowrap" align="right">
                                                    <asp:Label ID="lblServerName" runat="server"></asp:Label>
                                                </td>
                                                <td style="width: 100%;">
                                                    <asp:TextBox ID="txtServerName" SkinID="InstallFormTextBox" runat="server"></asp:TextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="2" align="left">
                                                    <asp:RadioButton ID="radSQLAuthentication" runat="server" AutoPostBack="True" GroupName="AuthenticationType"
                                                        Checked="True"></asp:RadioButton>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td nowrap="nowrap" align="right">
                                                    <asp:Label ID="lblUsername" runat="server"></asp:Label>
                                                </td>
                                                <td>
                                                    <asp:TextBox ID="txtUsername" SkinID="InstallFormTextBox" runat="server"></asp:TextBox></td>
                                            </tr>
                                            <tr>
                                                <td nowrap="nowrap" align="right">
                                                    <asp:Label ID="lblPassword" runat="server"></asp:Label>
                                                </td>
                                                <td>
                                                    <asp:TextBox ID="txtPassword" SkinID="InstallFormTextBox" runat="server" TextMode="Password"></asp:TextBox></td>
                                            </tr>
                                            <tr>
                                                <td colspan="2" align="left">
                                                    <asp:RadioButton ID="radWindowsAuthentication" runat="server" AutoPostBack="True"
                                                        GroupName="AuthenticationType"></asp:RadioButton>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="2">&nbsp;
                                                    </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
                        </asp:WizardStep>
                        <asp:WizardStep ID="stpDatabase" runat="server">
                            <table border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td class="TopLeftCornerInstall">
                                    </td>
                                    <td class="TopMiddleBorderInstall">
                                    </td>
                                    <td class="TopRightCornerInstall">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="3">
                                        <table class="InstallWizard" border="0" cellpadding="0" cellspacing="0">
                                            <tr>
                                                <td colspan="3">
                                                    <asp:Label ID="lblDatabase" runat="server" SkinID="InstallGroupTitle"></asp:Label>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="3">
                                                    <asp:RadioButton ID="radCreateNew" runat="server" AutoPostBack="True" GroupName="DatabaseType"
                                                        Checked="True"></asp:RadioButton>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25px;">&nbsp;
                                                    
                                                </td>
                                                <td nowrap="nowrap" align="left" style="width: 140px;">
                                                    <asp:Label ID="lblNewDatabaseName" runat="server"></asp:Label>
                                                </td>
                                                <td>
                                                    <asp:TextBox ID="txtNewDatabaseName" SkinID="InstallFormTextBox" runat="server" Enabled="False"></asp:TextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="3">
                                                    <asp:RadioButton ID="radUseExisting" runat="server" AutoPostBack="True" GroupName="DatabaseType">
                                                    </asp:RadioButton>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25px;">&nbsp;
                                                    
                                                </td>
                                                <td nowrap="nowrap" align="left" style="width: 140px;">
                                                    <asp:Label ID="lblExistingDatabaseName" runat="server"></asp:Label>
                                                </td>
                                                <td>
                                                    <asp:TextBox ID="txtExistingDatabaseName" SkinID="InstallFormTextBox" runat="server"></asp:TextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                </td>
                                                <td colspan="2">
                                                    <asp:CheckBox ID="chkCreateDatabaseObjects" runat="server" SkinID="InstallCreateDBObjects"
                                                        Checked="True"></asp:CheckBox>
                                                    <asp:Label ID="lblCreateDatabaseObjects" runat="server" Width="250px"></asp:Label>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="3">&nbsp;
                                                    </td>
                                            </tr>
                                            <tr>
                                                <td colspan="3">
                                                    <asp:Panel ID="pnlLog" runat="server" Visible="False">
                                                        <table>
                                                            <tr>
                                                                <td>
                                                                    <asp:Label ID="lblLog" runat="server" SkinID="InstallGroupTitle"></asp:Label></td>
                                                            </tr>
                                                            <tr>
                                                                <td align="center">
                                                                    <asp:Panel runat="server" ID="pnlGroupLog">
                                                                        <asp:TextBox ID="txtLog" runat="server" SkinID="InstallLog" TextMode="MultiLine"
                                                                            ReadOnly="True" />
                                                                    </asp:Panel>
                                                                </td>
                                                            </tr>
                                                        </table>
                                                    </asp:Panel>
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
    Code (markup):
     
    dymac, Mar 13, 2008 IP
  7. dymac

    dymac Member

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #7
    HEre is the second half of the install script

    
                        </asp:WizardStep>
                        <asp:WizardStep ID="stpConnectionString" runat="server" AllowReturn="false" StepType="Start">
                            <asp:Panel ID="pnlConnectionString" runat="server">
                                <asp:Label ID="lblConnectionString" runat="server" SkinID="InstallGroupTitle" Visible="False"></asp:Label>
                                <table border="0" cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td class="TopLeftCornerInstall">
                                        </td>
                                        <td class="TopMiddleBorderInstall">
                                        </td>
                                        <td class="TopRightCornerInstall">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td colspan="3">
                                            <table class="InstallWizard" border="0" cellpadding="0" cellspacing="0">
                                                <tr>
                                                    <td align="left">
                                                        <asp:Label ID="lblErrorConnMessage" runat="server"></asp:Label>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </asp:Panel>
                        </asp:WizardStep>
                        <asp:WizardStep ID="stpLicenseSetting" runat="server" AllowReturn="false" StepType="Start">
                            <uc1:LicenseDialog ID="ucLicenseDialog" runat="server" />
                        </asp:WizardStep>
                        <asp:WizardStep ID="stpSiteCreation" runat="server" AllowReturn="false" StepType="Start">
                            <asp:Panel ID="pnlSiteCreation" runat="server">
                                <asp:Label ID="lblSiteCreation" runat="server" SkinID="InstallGroupTitle" Visible="False"></asp:Label>
                                <table border="0" cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td class="TopLeftCornerInstall">
                                        </td>
                                        <td class="TopMiddleBorderInstall">
                                        </td>
                                        <td class="TopRightCornerInstall">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td colspan="3">
                                            <table class="InstallWizard" border="0" cellpadding="0" cellspacing="0">
                                                <tr>
                                                    <td colspan="2">
                                                        <asp:Label ID="lblSiteCreationInfo" runat="server" /></td>
                                                </tr>
                                                <tr valign="top">
                                                    <td>
                                                        <asp:RadioButton ID="radCorporateSite" runat="server" GroupName="SiteCreation" Checked="True">
                                                        </asp:RadioButton>
                                                    </td>
                                                    <td style="width: 100%;">
                                                        <asp:Label ID="lblCorporateSite" runat="server" />
                                                    </td>
                                                </tr>
                                                <tr valign="top">
                                                    <td>
                                                        <asp:RadioButton ID="radCorporateSiteASPX" runat="server" GroupName="SiteCreation" />
                                                    </td>
                                                    <td>
                                                        <asp:Label ID="lblCorporateSiteASPX" runat="server" />
                                                    </td>
                                                </tr>
                                                <tr valign="top">
                                                    <td>
                                                        <asp:RadioButton ID="radWizard" runat="server" GroupName="SiteCreation" />
                                                    </td>
                                                    <td>
                                                        <asp:Label ID="lblWizard" runat="server" />
                                                    </td>
                                                </tr>
                                                <tr valign="top">
                                                    <td>
                                                        <asp:RadioButton ID="radExisting" runat="server" GroupName="SiteCreation" />
                                                    </td>
                                                    <td>
                                                        <asp:Label ID="lblExisting" runat="server" />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="2">&nbsp;
                                                        </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </asp:Panel>
                        </asp:WizardStep>
                        <asp:WizardStep ID="stpFinish" runat="server" StepType="Complete">
                            <asp:Panel ID="pnlFinished" runat="server">
                                <table border="0" cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td class="TopLeftCornerInstall">
                                        </td>
                                        <td class="TopMiddleBorderInstall">
                                        </td>
                                        <td class="TopRightCornerInstall">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td colspan="3">
                                            <table class="InstallWizard" border="0" cellpadding="0" cellspacing="0">
                                                <tr>
                                                    <td>&nbsp;
                                                        </td>
                                                </tr>
                                                <tr>
                                                    <td align="center">
                                                        <asp:Label ID="lblCompleted" runat="server"></asp:Label></td>
                                                </tr>
                                                <tr>
                                                    <td>&nbsp;
                                                        </td>
                                                </tr>
                                                <tr>
                                                    <td align="center">
                                                        <asp:Label ID="lblMediumTrustInfo" runat="server" Visible="false" ></asp:Label>
                                                    </td>
                                                </tr>
                                    <tr>
                                        <td align="center">
                                            <asp:LinkButton ID="btnWebSite" runat="server" OnClick="btnWebSite_onClick" /></td>
                                    </tr>
                                    <tr>
                                        <td>&nbsp;
                                            </td>
                                    </tr>
                                </table>
                                </td> </tr> </table>
                            </asp:Panel>
                        </asp:WizardStep>
                    </WizardSteps>
                </asp:Wizard>
                <asp:Label ID="lblError" runat="server" SkinID="ErrorLabel"></asp:Label>
            </asp:Panel>
            <asp:Panel ID="pnlPermission" runat="server" SkinID="InstallerContent" Visible="false">
                <div style="text-align: left; padding: 0px 0px 10px 20px;">
                    <asp:Label ID="lblPermission" runat="server" />
                </div>
            </asp:Panel>
            <div style="text-align: center;">
                <asp:HyperLink ID="lnkTroubleshoot" runat="server" Visible="false" />
            </div>
            <asp:Panel CssClass="ButtonsPanel" ID="pnlButtons" runat="server" Visible="false">
                <asp:Button ID="btnPermissionTest" runat="server" SkinID="ContentButton" Width="150" />&nbsp;<asp:Button
                    ID="btnPermissionSkip" runat="server" SkinID="ContentButton" />
            </asp:Panel>
            <asp:Panel ID="pnlPermissionSuccess" runat="server" Visible="false">
                <asp:Label ID="lblPermissionSuccess" runat="server" /><br />
                <br />
                <asp:Button ID="btnPermissionContinue" runat="server" SkinID="ContentButton" />
            </asp:Panel>
        </asp:Panel>
    </form>
</body>
</html>
    Code (markup):
    Thanks!
     
    dymac, Mar 13, 2008 IP
  8. dymac

    dymac Member

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #8
    Hmm, Ok, so let me explain what is happening noow with this install script.


    I've attached the steps as I see it.

    On step 1 I enter the info and everything is right and then I go to step 2. I enter the info here and its tells me that the database I entered doesn't exist. This is where I get stuck. I tried choosing create new database but I get an error message and when I try use exisitng database it tells me the database doesn't exist! I tried to delete that part of the script but then I just get a script error.

    Thanks
     

    Attached Files:

    dymac, Mar 13, 2008 IP
  9. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Have you gone back into your GoDaddy account to check you have the details correct for the name of the db? Assuming the error reporting is correct it would appear the login details are right just the name isnt. It would have actually been the .cs file that I would have needed to see as it is the programming but the screenshots are fine (.aspx is mainly just the look bit)
     
    AstarothSolutions, Mar 14, 2008 IP
  10. Jhar

    Jhar Peon

    Messages:
    318
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #10
    In step 1 - Are you certain you have the correct name or IP address for the Godaddy database? Have you created a database user in you godaddy control panel and and is that the user name and password you are entering.

    In step 2 - As long as that is the correct name for the database you created it should be good.

    Good luck!
     
    Jhar, Mar 15, 2008 IP