To use an Power SQL 1, 2, or 3 account, there are some technical prerequisites that need to be met:

• You currently have, or will have a Win2000 (Powersite) Plan, or Win2000 Plan+ hosting account with Enchanted Websites.
• You will be using ASP, IDC or HTX to connect to this MS SQL Database.
• You must be aware how to use the Windows Control Panel, as you will need to setup the ODBC connection after confirmation of your order has been sent to you.
• Enchanted Websites' Power SQL 1, 2 and 3 packages only support MS SQL 7.0 and MS SQL 2000.  Enchanted Websites does not support any prior version of MS SQL for the Power SQL accounts.
• Enterprise Manager will be required to upload the current database (using DTS) from your local PC, or server to your Power SQL account with Enchanted Websites. This software comes with MS SQL 2000 or MS SQL 7.0 upon purchase of the product.
• There are only 2 ways to change your username's password:
  
  • Enterprise Manager can be used to change your Administrative Login's password.
  • Enchanted Websites' Customer Service Department can change your Administrative Login's password.
• Enterprise Manager can be used to administer your database remotely.  Click here for details.
• Automated data replication is not permitted with Power SQL 1, 2, or 3.
• When ordering your Power SQL account, you will be required to provide the domain name that will be using the Power SQL account (top level domain or virtual host) and the database name.  Enchanted Websites will generate the login name and the password for you. The default login name will be your database name.
• To order, fill in our form, indicating which Win2000 account you currently have, and which MS SQL 2000 plan you would like to add to your account.

How do I set up my DSN for my Power SQL account?

Once you have received email confirmation that your Power SQL account is set up, you will need to create a DSN through the Control panel. To set up the DSN, complete the following steps.

• Proceed to your Windows 2000 Control Panel, which is located at http://cpanel.yourdomain.com
• Log in as webadmin@your domain.com.
• Click on the 'ODBC DSN' link
• From the menu, select 'SQL Server' and click Next
• Input the DSN, and description. The DSN will be used in conjunction with your login and password that Enchanted Websites will provide you once your Power SQL account is established.
• Click 'Add the DSN' and the DSN will be created for your use.

How do I connect to my Power SQL account using Enterprise Manager?

Here are step-by-step instructions on how to add your Enchanted Websites Power SQL account as a server inside of your Enterprise Manager. Beside each item is a link to a screen shot. This screen shot should look familiar to the step at which you're at.

• Open Enterprise Manager on your local computer. Right click on your 'SQL Server Group' (Click here for screen shot)
• Select 'New SQL Server Registration...' (Click here for screen shot)
• A wizard will appear. Click next. (Click here for screen shot)
• Input the server's hostname of your Power SQL account. This should be something like sql01.nt.aitcom.net Refer to your initial email from Enchanted Websites. This has the hostname inside it. (Click here for screen shot)
• Click the 'Add >' button. (Click here for screen shot)
• It will add the server to the 'Added servers' area of your screen. Click Next. (Click here for screen shot)
• On the next screen, ensure you select 'The SQL Server Login information that... [SQL Authentication]' This will use SQL authentication, rather than Windows Authentication. Click Next. (Click here for screen shot)
• Select the option that will allow you to login using your Administrative Login and password. This is what Enchanted Websites sent to you in your initial email about your Power SQL account. Click Next. (Click here for screen shot)
• You can add this server to your existing group, or create a new group. By default, you should just add the server to your existing SQL Server Group. Click Next. (Click here for screen shot)
• Enterprise Manager will attempt to login, and register this server. This means that you can remotely administer your Power SQL account using Enterprise Manager. (Click here for screen shot)

Now that you have added the SQL server to your group in Enterprise Manager, you can activate the connection, and begin to administer your database as necessary. You will find your SQL database under the 'Database' directory.

How do I DTS (transfer) my MS SQL database to my Power SQL account?

• Open Enterprise Manager on your local computer.
• Locate your SQL server .
• Open the Database Directory.
• Right Click on the database that you wish to export.
• Select 'All Tasks' and then 'Export Data...' A wizard will appear.
• Click Next on the wizard.
• Select your data source that you wish to export.
• Click Next.
• Select your destination. The Server should be listed, or can be typed in.
• Input the server's hostname of your Power SQL account. This should be something like sql01.nt.aitcom.net Refer to your initial email from us. This has the hostname inside it.
• On the next screen, ensure you select 'Copy objects and data between SQL databases'. This will ensure that all data, logins, stored procedures, etc are copied.
• Click Next.
• On the 'Objects to Copy' screen, most of the defaults will be fine. Ensure the defaults are what you desire, and click Next.
• A summary of your selections will be posted at the end of the wizard with a 'Finish' button.
• Click Finish if you're ready to export the data.
• The data will be DTS'ed to your Power SQL account. The wizard will give you the status during the transfer.

Click here to see a detailed screen shot series of the DTS system.

RELATED LINKS:

• Microsoft's Official SQL website

TECHNICAL SUPPORT HOME PAGE