How do I upload my data to my domain name?

[ryguy7272]

I have two questions.

#1) How can I upload my SQL Server Express DB to my domain name? I’ve looked all over the site and can’t figure it out! I saw this video:
http://iis7test.com/expresstools/Default.aspx
that looked pretty interesting, but I can’t tell for sure if that’s what I need and I have no idea what to use as FTP, so I can’t FTP to anything even if I knew how to use that.

#2) How do I use the tool here:
https://sqlwebadmin.discountasp.net/

I thought maybe I could upload my data using that tool, but again, I can’t figure out how to use it!

When I open SQL Server express all I see is this:
Server Type: Database Engine
Server Name: EXCEL-4J2W8KYNP\SQLEXPRESS
Authentication: Windows Authentication

The SQL web admin has fields such as:
Server Name: EXCEL-4J2W8KYNP\SQLEXPRESS (I think…)
Database: Hotel (in my SQL Server Express)
Authentication: SQL Server Authentication (appears to be the only option)
Login: (none…AFAIK)
Password: (none…AFAIK)

What do I need to do to make this work?


---


Ok, I go to DNS Manager and see a Domain Name of 'ftp.pubcrawlnyc.com' (one of several). I think, ok great, this is how I can ftp my SQL Server Express up to the site. I fire up VWD and open my web site. Then I click Web Site > Copy Web Site > Connect > FTP Site and enter the following:
Server: ftp.pubcrawlnyc.com
Port: 21
Directory: /_database
Username: (I entered it)
Password: (I entered it)

I get a message saying that my password is incorrect. I know it is not incorrect; I'm simply using the same password I used for my site and I can log into the site just fine. I think, perhaps, the problem is with the setting of Permissions for the main Directory. Right now I get a message that reads 'No Users Exist'. I clicked on Add More Users > 'Go to User Manager'. However, in this area, I don't see any possible way to add a user or manager. What am I doing wrong?

Thanks,
Ryan---

[wisemx]

Hi Ryan,
Are you making any progress with this?
I'll keep checking on your status, in this thread...
Did you add a SQL Server to your account?
Once you have you can use the Attach feature from your Control Panel.
The Express DB once uploaded to your site is just sitting there until you attach it.
At that point your site will need to connect to the SQL Server you added.
The Express DB itself is not supported on DASP servers but the Attach feather is for getting that data into your added SQL Server,
All the best,
Mark

[ryguy7272]

I added SQL Server to my account (several days ago). I clicked on Control Panel API in the left margin, but I am not seeing anything called 'Attach'. I read in the Form that the SQL Express is not supported, and I also read that it is easy to transfer the data from Express (which is the version of SQL Server that I have) to the full-featuered SQL Server on discountasp.net. Still, I can't figure out how to do this. Wisemx can you, or someone, show me step-by-stpe how to proceed. i have my VWD part done and the SWL Server express contains all the date...I just can't get it to the discountasp.net site. I don't think it should be so hard; must be missing something basic here...


I followed the instructions here:
http://support.discountasp.net/KB/a72/how-do-i-deploy-visual-studio-20082005-visual-web-developer.aspx

For Directory, it reads '[name of the remote directory to copy to; leave blank for the root]' I am leaving this blank, just because I don't know what to put here. When I click 'Open', I get a message that says the Username or Password is incorrect. I KNOW THE USERNAME AND PASSWORD ARE CORRECT. What is going on??? What do I have to do to post to my site. I've been trying to deploy the site for one week now and have made no progress. I'm literally getting behind on deadlines right now. If I can't get this discountasp.net to work very soon, I'm going to use the 30-day rule, get my money back, and go somewhere else.

Thanks,
Ryan---

[raymondp]

What platform is your account on? Is it IIS 6 or IIS 7. For IIS 7 the FTP login is a little different then your account login. I suggest you log into your hosting control panel and go to Account Info/Edit and look at your FTP login to make sure you are typing in the correct FTP user name.

[ryguy7272]

I have web server type: Windows 2008 - IIS 7.0

If I click on Account Info/Edit, I can see the FTP info.
Username, Password, Address, and Alternate FTP Address

I went to this link:
http://support.discountasp.net/KB/a72/how-do-i-deploy-visual-studio-20082005-visual-web-developer.aspx
I followed the instructions there.

I can’t tell for sure if the server is:
www.pubcrawlnyc.com
or…
ftp.pubcrawlnyc.com
(I tried it both ways)

Port: 21

For Directory, it says ‘[name of the remote directory to copy to; leave blank for the root]’. I didn’t really know what to put there so I tried leaving it blank, and that didn’t work. I tried a few things that I though may be directories, but nothing worked. What is the directory supposed to look like?

Passive Mode: Checked

Anonymous Login: unchecked
I tried my Control Panel Login (from the Account Info/Edit) and I tried FTP Username and FTP Password. I tried all kinds of combinations of these things…nothing has worked so far.

Every time I click ‘Open’ to deploy my site, I get a message that says ‘the username or password you entered is incorrect, or you do not have authorization to perform this operation.’ There should not be anything wrong with my username and password (I can log into my section of the discountasp.net site just fine).

I’ve been trying to deploy this site for 1 week now. If I can’t get this working soon, I’m going to get out of here and get my $ back (invoke the 30-day rule). I need to do something soon for a client; deadlines loom. Any thoughts or ideas?

Thanks,
Ryan--

[raymondp]

Post a copy of the ftp log from beginning to end. This will help us better troubleshoot your problem.

[Chuck]

Create a ticket via your control panel by clicking support at the top.

[ryguy7272]

Thanks guys! I finally got it working, but just because I had some serious help from a friend. This stuff is not exactly intuitive, but I guess it makes sense one you get the hang of it. I've got a lot to learn. Ok, onward and upward.

Ryan---

[Amadeus]

Would you like to share the solution with us? I get the same error.