Hi Everyone,

 First of all, let me start off by saying i'm very new to web developing and deploying.

I am having trouble understanding what I'm supposed to do to configure a SQL database to run on the server. I have created a small site with a Membership using VWD. I used that to create a ASPNETDB.mdf holding the membership infromation in the App_Data directory. I uploaded my entire site using FTP including the database in the App_Data directory.

I then created a database in my DotNetPanel called KW_Membership and a username and password. Now i know i need to publish my database files into this, how do i go about doing this? I tried using the Database Publishing Wizard to send it to the IP provided "69.16.210.14", but it returned an error. I dont know if the this was the right thing to do..plz help.

 Thanks in advance

Brian

Hi Brian,

You will need to create a bak. file from your current databases and then restore these to the hosted SQL server via DNP:

 

https://www.ultimasupport.net/Customer/KBArticle.aspx?articleid=23

 

Cheers,

Mark 

---

System Administrator

Hello, I need a Little help with this issue but the link is not working.

Try this one instead:  https://support.ultimahosts.net/Customer/KBArticle.aspx?articleid=23

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

I follow the instructions, but the site is still not working I'm using the CSK 3.1 and I'm not sure if the connection string is right, see this is my problem the database  from my local is the ClubDB.mdf and the backup still is ClubDB.mdf.bak, but when I look in the DNP SQL Database properties from the empty database I created, in the tab I can see this

Size, KB: 5312 Logical Name: tempname

Size, KB: 504 Logical Name: clubsite_log

the size of the files is right but I don't see the name of the database I restore unless it was change to tempname, in any case this is a copy of my connection string can someone please tell me what I missing?

 <connectionStrings>
<remove name="LocalSqlServer"/>
    <add name="LocalSqlServer"
         connectionString="Data Source=72.52.xxx.xx;Database=Areyou;User Id=Dannyxxx;Password=xxxxxxx; User Instance=True"
         providerName="System.Data.SqlClient"/>
</connectionStrings>

Also when I tried to log in the littleadmin SQL it would say something about not finding the shared memory dll and won't let me see the DB. Any help would be greatly appreciated, I'm new to ASP.NET and having hard time making this site works. Thanks

 

In DNP SQL Databases, you should create a database that is the same name as the one you are restoring (e.g. ClubDB).  Then your connection string must use that same name (Database=ClubDB;).

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Thanks for the answer, but I still have one more question regarding this, do I add the extension from the kit also? ie ClubDB.mdf? That's how the bak is named ClubDB.mdf.bak

It doesn't really matter what you name the file, but when you create the database in DNP, do not include any file extensions (mdf, bak, etc).  For the database name just type ClubDB.

Then, when you restore your copy to the ClubDB database in DNP, DNP will automatically rename your backup file appropriately (which is technically ClubDB.mdf).  Your connection string should not include the filename/extension...just the name of the database (ClubDB).

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

I did everything that I needed to do but I have a little problem I'm receiving this when I tried to make the hosted DB. I deleted the old one and trying to do the corrected name but this is the error:

 

Your database name needs to be unique.  Most of us share the same SQL Server, so if I create a database named "myDB", then nobody else could, even though they are on a separate hosting plan.

If you'd like to PM me I could work with you offline on how to get your database loaded.

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

I finaly got it, I named the database ClubDB1 and it accepted the name but when I click in the database name "ClubDB1" the size is right, but the name says "tempname", and the log says clubsite_log. However I think that is not just the database that is stopping the website from running I keep receiving this web.config error and doesn't matter what I do or someone else do,  it come back with the same error. And of course I would appreciate any help to make the site run, and perdon my ignorance but what's PM? Thank you.

PM is Private Message.  Click on "Contact" in this message and then click "Send itechcs an email" or "Send itechcs a private message".

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com