|
|
More
Info
|
Plans
& Pricing:
- - -
-
-
-
-
Technical
Info:
-
-
-
Application
Support:
-
-
-
-
-
-
-
-
- - -
General
Info:
-
-
-
-
-
-
Reseller
Program
Start making money now with your own hosting company. Its easy!
|
|
|
|
SQL Server FAQs
This page answers the following commonly asked
questions:
- Is MS SQL server
installed on a separate computer?
- Can I FTP my
database to the SQL server?
- What tools should
I use to connect to SQL server and to run my SQL scripts in order to create
objects?
- I do not have any
of these tools. How can I get them?
- What version of
SQL server do you currently have?
- What are the exact
steps for connecting to SQL server?
- I have connected
to SQL server but cannot transfer my database. What should I do?
- How will I
administer my database while hosted on your server?
- I want my web
site, which is hosted by Top Notch Hosting, to be able to use SQL server
database from ASP or Cold Fusion programs. How will I do that?
- How often do you
backup data?
| Is MS SQL server installed
on a separate computer? |
 |
| Yes, the SQL server is housed on a
dedicated dual-Pentium processor for optimal performance. |
|
| Can I FTP my database to the
SQL server? |
|
| No, FTP and Web servers are
not installed on this server for two reasons: performance and
security. In order to maximize performance and security of the
SQL server, FTP and Web servers have not been enabled. Doing
so optimizes a dedicated database server to better suit your needs. |
|
| What tools should I use to
connect to SQL server and to run my SQL scripts in order to create objects? |
|
The following tools
are recommended for connecting, scripting, and the transferring of
files:
SQL Server Enterprise Manager;
Isql command line utility;
Isql/w – Windows based utility;
and ODBC. |
|
| I do not have any of these
tools. How can I get them? |
|
| You will install them from SQL
server distribution by running Setup program. |
|
| What version of SQL server
do you currently have? |
|
| We currently offer both SQL Server
2005 as well as SQL Server 2000. |
|
| What are the exact steps for
connecting to SQL server? |
|
After we receive payment you will be
provided with connection information such as:
IP Address, server name, database name, ODBC DSN, username,
password.
Step by Step can be found below:
A) You will
configure Client Configuration Utility which comes with SQL
server distribution starting with default net library which
should be TCP/IP sockets
Then you go to ‘Advanced’
screen and enter the server name that was emailed. Put server IP in
place of ‘Connection String’.
B) To use ODBC
from your ‘home’ location you need to create an ODBC DSN. Open
ODBC applet, choose ‘System DSN’, select ‘Add’, then
‘SQL server’ and use the connection information that we have
supplied you with. Always use ‘Standard Security’ mode to login with
the username/password we will provide you with.
|
|
| I have connected to SQL
server but cannot transfer my database. What should I do? |
|
First be sure you only have one
database user – ‘dbo’- who owns all the objects.
Open SQL Enterprise Manager. Go to ‘Tools’, then ‘Transfer
Objects’. You should be able to transfer from there.
Another way to transfer a database is
to use BCP command line utility. |
|
| How will I administer my
database while hosted on your server? |
|
| Use the same tools as mentioned above:
Enterprise Manager, Isql/w, ODBC. Your login will be
mapped to ‘dbo’ (database owner). So you will have all the
access to your database that you may require. You could even delete it! |
|
| I want my web site, which is
hosted by Top Notch Hosting, to be able to use SQL server database from
ASP. How would I do that? |
|
| At your request, we will create an
ODBC DSN for you. |
|
| How often do you backup data? |
|
| Twice a day. |
|
REQUEST
FORM
|
|
