What do
I need to know about Enchanted Websites's Power SQL accounts?
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:
TECHNICAL
SUPPORT HOME PAGE
|