locked
need a little help 2 RRS feed

  • Question

  • hello my friends

    first thank you Dan and Daniel for great help in " need a little help 1"

    in fact they do a lot of effort to help me to execute my database that was included a lot of bugs and finally it works

    well ,now i want to upload it to my windows hosting plan that is in :

    http://www.m2host.com/

    and my domain is:

    http://www.altraders.com/

    i want to upload my database to http://www.altraders.com/

    so what should i do ???

    Marooo

      

    Monday, April 16, 2012 5:50 PM

Answers

  • Hello Marooo,

    I am afraid that this not a question directly related to SQL Engine.

    If you are looking for a web application model then it works something like below -

     Let me know if I understood your question incorrectly.


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by marooo Saturday, April 21, 2012 9:33 PM
    Monday, April 16, 2012 6:40 PM
  • is it called windows starter or "Web Starter" ?

    the product page mentions 1 MS Sql included in Web Starter but you don't find any information about MS SQL on this hoster.

    Please contact m2host for info about uploading and setting up MS Sql database with "Web Starter" product.

    • Marked as answer by marooo Saturday, April 21, 2012 9:32 PM
    Monday, April 16, 2012 8:56 PM

All replies

  • Hello Marooo,

    I am afraid that this not a question directly related to SQL Engine.

    If you are looking for a web application model then it works something like below -

     Let me know if I understood your question incorrectly.


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by marooo Saturday, April 21, 2012 9:33 PM
    Monday, April 16, 2012 6:40 PM
  • thank you Anup for your replay

    well, i have a web application contans a database i want to put it in my hosting plan which is windows

    Dan and Daniel helped me to extract the database in my computer

    now i want to upload it to my domain and my hosting plan

    my domain name is:

    http://www.altraders.com/

    and my hosting  plan is windows starter from

    http://www.m2host.com/

    u can find all the web application in this link

    http://www.mediafire.com/?pbzgbq6c3mmzmp8

    Marooo

    Monday, April 16, 2012 7:57 PM
  • is it called windows starter or "Web Starter" ?

    the product page mentions 1 MS Sql included in Web Starter but you don't find any information about MS SQL on this hoster.

    Please contact m2host for info about uploading and setting up MS Sql database with "Web Starter" product.

    • Marked as answer by marooo Saturday, April 21, 2012 9:32 PM
    Monday, April 16, 2012 8:56 PM
  • Daniel 

    thank you for replaying me

    i asked them and they told me

    Please wait for a site operator to respond.

    You are now chatting with 'M2Host - LiveHelp'

    M2Host - LiveHelp: Welcome to our real-time support chat.My Name is Joshua Rodriguez. How can I help you today ?

    amr: Joshua

    M2Host - LiveHelp: Hi

    amr: do u have in the web wendows starter a MS SQL

    amr: ?

    M2Host - LiveHelp: Did you have hosting account with us ?

    amr: yes

    amr: altraders.com

    amr: a web starter "windows"

    M2Host - LiveHelp: Yes we have MSSQL on our windows servver

    amr: i want to upload and setting up MSSql database in my hosteting plan

    amr: how i can do that ?

    M2Host - LiveHelp: You can upload your database under httpdocs folder and place a ticket to our support department to restore the database

    M2Host - LiveHelp: and you will also need to create the database first

    amr: how can i create the data base?

    M2Host - LiveHelp: You will just create the database name through plesk and then upload the database file under httpdocs folder

    amr: ok i will try and get back to you

    amr: bye for now

    M2Host - LiveHelp: You database file should be in .bak format

    M2Host - LiveHelp: bye

    M2Host - LiveHelp: Thank you for using m2host Live Chat service.

    M2Host - LiveHelp: Thank you for chatting.  Good-bye.

    they need a database file shold be in .bak format

    how can i do that?

    Marooo

    Monday, April 16, 2012 10:05 PM
  • They will be needing the backup of your database which will be in .bak format.

    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Monday, April 16, 2012 10:07 PM
  • Anup 

    thank you for replaying me

    well, how i do a backup for my database in a .bak format ?

    Marooo

    Monday, April 16, 2012 10:17 PM
  • Hope you are using SSMS.You can ref the link which will explain how to take backups

    http://msdn.microsoft.com/en-us/library/ms187510.aspx

    Make sure they are really looking for a backup file once again.


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Monday, April 16, 2012 10:20 PM
  • thank you Anup for replaying me

    i did maked a backup file

    sms.bak

    now i don't need any thing else to make the the web application SMS to work in my domain ??

    Marooo

    Monday, April 16, 2012 10:59 PM
  • you need to know how you've to setup the connect string.

    eg. if it is a standard sql with initial catalog and data source or if it is a SQL Express using AttachDBFilename etc.

    see an article here about SQL Server and ASP.net Using SQL Server Express Edition with ASP.NET (Visual Studio)

    Tuesday, April 17, 2012 5:05 AM
  • Daniel

    thank you for replaying me

    could u man kindly try to test this database in your hosting plan and tel me if it is working correctly ?

    Marooo

    Tuesday, April 17, 2012 8:18 AM
  • Daniel 

    i just finieh from chating with my hosting plan staff

    they ask me about the name of the database 

    M2Host - LiveHelp: Please let me know, may I restore the SMS.bak file ?

    M2Host - LiveHelp: If yes, please provide me the database name

    i told them the name is sms , IS THAT RIGHT Daniel ??

    is the name should be sms too ???

    well i told them the name is sms 

    and they create a data base called sms under altraders.com

    and now they need  2 files 

    .mdf and .ldf

    to proceed the steps of restoring the database

    how should i make a .mdf and .ldf files man ??

    Marooo

    Please wait for a site operator to respond.

    You are now chatting with 'M2Host - LiveHelp'

    M2Host - LiveHelp: Welcome to our real-time support chat.My Name is  Catherine Perez. How can I help you today ?

    M2Host - LiveHelp: Hello Marooo

    M2Host - LiveHelp: Please let me know your issue.

    Marooo: hello Catherine

    Marooo: what happen in my ticket number #209463

    Marooo: what happen in my ticket number #209463

    M2Host - LiveHelp: Please hold on for a moment while I check this for you

    Marooo: ok

    M2Host - LiveHelp: Please hold on for a moment while I check this for you

    Marooo: ok ok

    Marooo: well ???

    M2Host - LiveHelp: I am working.

    M2Host - LiveHelp: Please allow me some moments.

    Marooo: ok mam

    Marooo: ok ok

    M2Host - LiveHelp: Please let me know, may I restore the SMS.bak file ?

    M2Host - LiveHelp: If yes, please provide me the database name

    Marooo: yes restore it

    Marooo: sms

    M2Host - LiveHelp: which you want to restore.

    Marooo: the database name is sms

    M2Host - LiveHelp: ok

    M2Host - LiveHelp: Please hold on for a moment while I check this for you

    Marooo: ok

    M2Host - LiveHelp: I have checked and there is no any data base named sms under your altraders.com account.

    M2Host - LiveHelp: Please create the database from - Plesk control panel- > database -> add new database.

    Marooo: the file sms.bak is contuing the data base

    Marooo: create it

    M2Host - LiveHelp: Please hold on for a moment while I check this for you

    Marooo: ok

    M2Host - LiveHelp: I have created the altrader_sms  database under your altraders.com account and tried to restore the same with the backup file.

    M2Host - LiveHelp: So, please upload the .mdf and .ldf file under your altraders.com account

    Marooo: ok

    M2Host - LiveHelp: So, I can restore the database.

    Marooo: where i can upload it ?

    Marooo: where i should upload that files ?

    M2Host - LiveHelp: under your httpdocs folder of altraders.com account

    Marooo: ok

    Marooo: do u need any thing else Catherine to be upload my angel

    M2Host - LiveHelp: Have you uploaded the .mdf and .ldf files ?

    Marooo: not yet

    M2Host - LiveHelp: Please upload them first , so I can proceed.

    Marooo: i ask about any else files do u need to upload it all at one time

    M2Host - LiveHelp: No, only  .mdf and .ldf files.

    Marooo: ok i will and get back to u

    M2Host - LiveHelp: sure.

    Marooo: have a nice day Catherine

    Marooo: bye

    M2Host - LiveHelp: You too!!

    M2Host - LiveHelp: Thank you for using m2host Live Chat service.

    M2Host - LiveHelp: Thank you for chatting.  Good-bye.

    Marooo: thanks to u

    Marooo: good bye

    M2Host - LiveHelp: Welcome :)

    M2Host - LiveHelp: Thank you for chatting.  Good-bye.


    • Edited by marooo Tuesday, April 17, 2012 9:30 AM
    Tuesday, April 17, 2012 9:08 AM
  • Guys 

    how can i make a .mdf and .ldf files ?

    Tuesday, April 17, 2012 8:44 PM
  • hello My friends

    is that a stupid question that far for not answering it ?

    well, i  solved it, i found the files in the directory of the data base

    please my friends don't treat me like that because i am not good in SQL

    any way thank you for your help

    Marooo

    Wednesday, April 18, 2012 8:08 AM
  • Hi Marooo,

    Good that you were able to fix the issue.You can always ref Books Online(BOL) for any quick help regarding SQL Server.

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=1054

    Thank you,


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, April 18, 2012 4:45 PM
  • hello My friends

    is that a stupid question that far for not answering it ?

    well, i  solved it, i found the files in the directory of the data base

    please my friends don't treat me like that because i am not good in SQL

    any way thank you for your help

    Marooo

    Marooo

    like everybody else we've a daily job and only a limited spare time and sometimes peoples are not online for a few days for various reasons.

    If you read the introduction to this forum you'll see that this forum is not a support forum by Microsoft where you can expect to get support always. Most people here answers your question on a voluntary base and do not get paid for it.

    If you really need urgent support you need to contact the Microsoft Support Hotline and probably pay for it and than you can expect an answer within certain times.


    Wednesday, April 18, 2012 5:18 PM
  • well, i  solved it, i found the files in the directory of the data base

    you should not just copy the .mdf and .ldf found in the directory of data base.

    if you need those files (.mdf & .ldf) you need first to detach the database otherwise files are locked and can't be copied away or - if you stopped the SQL Server instance - are in an inconsistent state probably as transaction may be open etc.

    Wednesday, April 18, 2012 5:21 PM
  • u r right Daniel

    u do that for free

    thank u all for your help

    well, my friends i need a last favoer

    i uploaded all files in that .rar file

    http://www.mediafire.com/?7ky9jsryy05d51r

    i just want to extract it and give a try to all the website include the database in your hosting plan and tel me is it work correct or there are a missing files on the system

    i know i don't pay for your help my friends

    but u can ask me what u want in a return of that help

    Marooo

    Wednesday, April 18, 2012 6:09 PM
  • hello My friends

    when the hosting plan stuff try it to make the site work it gave a error is :

    in the site main page it gaves:

    http://www.altraders.com/Default.aspx

    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: Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified.

    Source Error: 
    Line 1:  <%@ Control Language="C#" AutoEventWireup="true"  CodeFile="New_Node.ascx.cs" Inherits="New_Node" %>
    Line 2:  <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
    Line 3:  
    Line 4:  

    Source File: /New_Node.ascx    Line: 

    Assembly Load Trace: The following information can be helpful to determine why the assembly 'AjaxControlToolkit' could not be loaded.
    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

    Please wait for a site operator to respond.

    You are now chatting with 'M2Host - LiveHelp'

    M2Host - LiveHelp: Welcome to our real-time support chat.My Name is  Catherine Perez. How can I help you today ?

    M2Host - LiveHelp: Hi

    Marooo: hello Catherine

    Marooo: what error do u got ?

    M2Host - LiveHelp: yes

    Marooo: ?

    Marooo: what error do u got Catherine ?

    M2Host - LiveHelp: Please hold on for a moment while I check this for you

    Please wait while I transfer the chat to 'M2Host - Operator'.

    You are now chatting with 'M2Host - Operator'

    Marooo: ok

    M2Host - Operator: We have extracted the data of sms.rar for you now

    Marooo: okay

    M2Host - Operator: Please check for the needed settings at your end now

    Marooo: what needed setting u need ?

    M2Host - Operator: upload add needed binary files on your site in bin folder

    Marooo: what is it ?

    M2Host - Operator: Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1"

    Marooo: this what u need ??

    M2Host - Operator: Parser Error Message: Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified.

    M2Host - Operator: Source Error:

    M2Host - Operator: Line 1:  <%@ Control Language="C#" AutoEventWireup="true"  CodeFile="New_Node.ascx.cs" Inherits="New_Node" %>

    M2Host - Operator: Line 2:  <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

    M2Host - Operator: above is the error for your domain name now

    M2Host - Operator: Is there anything else I can help you with today?

    Marooo: ok Habibi i will try to fix it and get back to u

    Marooo: bye

    M2Host - Operator: sure

    M2Host - Operator: Thank you for using m2host Live Chat service.

    M2Host - Operator: Thank you for chatting.  Good-bye.

    please help my friends

    Marooo

    Thursday, April 19, 2012 9:50 AM
  • As you have already contacted the support you might have to wait for them to fix the issue for you.This issue is not related to SQL Server.Incase there is something comes up related to Database Engine,then let us know.


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Thursday, April 19, 2012 4:39 PM
  • As you have already contacted the support you might have to wait for them to fix the issue for you.This issue is not related to SQL Server.Incase there is something comes up related to Database Engine,then let us know.

    not really, he just needs to read the documentation for AJAXControl toolkit and the information how to deploy it to a ASP.NET site.

    As the hosting provider is using .NET 4 it should be sufficient to copy the required AJAXControl toolkit assembly (.DLL) to the APP_BIN folder. http://msdn.microsoft.com/en-us/library/cc295391.aspx

    @Anup, I agree that this problem is not really a topic for a SQL Server forum anymore.

    @Marooo

    If you've a enough powerfull computer, setup a VM (virtual machine) with Windows Server 2008R2 & SQL Server Express 2008R2 & ASP.NET (.NET 3.5/4) and do the initial testing on this VM - it saves you a lot of time. If you don't have access the Windows Server 2008R2 by any Microsoft subscription programs you can still download one of the Windows Server 2008R2 trial edition and install it or just downloaded the VHD with a preconfigured Windows Server 2008R2 trial edition.


    Thursday, April 19, 2012 4:47 PM
  • my friends

    i know it is not a SQL question any more and i am not good in SQL too

    well, i can't do that any more i quit i surrender 

    TO ALL SQL AND ASP.NET GUYS

    who can help me and fix all the problems and take money for that job

    amrelsayed3333@hotmail.com

    Marooo

    Thursday, April 19, 2012 5:17 PM
  • i uploaded all files in that .rar file

    http://www.mediafire.com/?7ky9jsryy05d51r

    if this is the version you've uploaded to your web hoster than it probably fails in the login.aspx as the connect string points to a different server than you web page.

      <add name="SMSConnStr" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=SMS;User ID=smslogin;...

    have you changed it in the file web.config on the server to point to the correct server ?

    Friday, April 20, 2012 11:50 AM
  • no Daniel i did not change it in the web.config man

    and i can not accept your help any more until any one  tell me how much money i should pay to fix my problems 

    i really need help Daniel u know that but i think it is wrong to get help like that without paying money man 

    Marooo

    amrelsayed3333@yahoo.com

    Friday, April 20, 2012 6:26 PM
  • no Daniel i did not change it in the web.config man

    and i can not accept your help any more until any one  tell me how much money i should pay to fix my problems 

    i really need help Daniel u know that but i think it is wrong to get help like that without paying money man 

    Marooo

    amrelsayed3333@yahoo.com

    @Marooo

    probably you main/biggest problem is the support of your hosting provider to setup the SQL database and connect it in your ASP.net appliation.

    To start with SQL Server Express in a hosting enviroment please read the following thread and the embedded links

    SQL Server Express and Hosting


    Tuesday, April 24, 2012 4:11 PM