I need to upload an sql2000 database

Right this is the address I used - mssql01.discountasp.net - but should I enter it as a URL, i.e.,
http://mssql01.discountasp.net. I think I tried both ways with no success.

 

Ok, you need a SQL application to access your database. You can't just access it directly through the web browser.

You can get Microsofts SQL server express for free:

http://www.microsoft.com/sql/editions/express/default.mspx

Or you can just visit the web admin:

https://sqladmin.discountasp.net

 

First of all, make sure you have signed up for the Sql Sever 2000 add-on. It's $10/month on top of the hosting cost.

Once you have the add-on, you can login to the control panel at https://my.discountasp.net/ and click 'MS SQL 2000' on the left hand side under Database Management.

All your SQL account info will be listed there (except your password). Your SQL database name will be something like mssql01.discountasp.net

 

Well - i have SQL Server Enterprise Manager and I'm trying to connect via the DTS Import/Export Wizard - is this not the tool I need to upload an SQL db to the site?

 

That is the correct tool. When you reference the database name, you don't need the http prefix, so it would just be mssql01.discountasp.net.

Using the DTS Import/Export wizard can be complicated. I'd make sure you can connect in Query Analyzer and just do simple queries, then start to figure out what is going wrong with DTS

 

There is really no query I can run because there is no database on the web server - I have yet to upload it.

 

An empty database is set up for you automatically. So you could run a CREATE TABLE query or a SELECT GETDATE() query, for example. Your database name is listed in your control panel.

 

i opened the Query Analyzer - for SQL Server I entered mssql07.discountasp.net - chose SQL Server Authentication - then I used same username and password which I used to logon to the control panel. The result was the following error message -

Unable to connect to server mssql07.discountasp.net - Login failed for optimumregi [which is my username]

 

You have a different username and password for SQL. You can find/update these in the SQL 2000 section of the control panel. You're really close though!

 

It's nice to know I'm closing in on the beast!

 

Yep - the different username/password was the problem - thanks! - I've uploaded the database - now for the application.

 

OK - I don't know if I should now start a new thread in a different forum section - but this has worked for me this far and I am loathe to leave it. I've uploaded my application to my website - it actually runs (but fails to access database - I'll deal with that later). My question now is "How can I examine the tree structure of my virtual website - that is the index.aspx, default.aspx, and other files that have been placed on Discount's server?

 

You just need to see the files on your website? You have to use an FTP program. I like SmartFTP:

http://www.smartftp.com/

The username and password should be the same as what you use to login to the control panel. Your FTP info is also listed in the control panel.

 

Merci Beaucoup

 

As I said the application cannot connect to the database (totally expected) - I'm certain I will at least need to change the connection string in my app code. Can you tell me what the string will look like and if there are any other changes necessary?

 

You can find the connection string in your 'Database Manager>MS SQL 2000>MS SQL 2000 Databasesright below the usage meter.
before you make changes to your connection string make sure that you have successfully restored your database to DASP Sql Servers and your connection string has the correct information.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

I need to upload an sql2000 database - The directions tell me that the DiscountAsp server name is listed in the control panel. Could anyone tell me what exactly I'm looking for? Is this an http address or what? Nothing I've tried has worked

Post Edited By Moderator (Joel Thoms) : 12/14/2006 11:19:34 PM GMT