Databases

MS Access 2000
It is one of the most popular database connections.
Create your own database, upload it into your web-area then please send us a valid support request, stating the location of the database and we will assign you a DSN (Data Source Name).
DSN is required and will be the unique identifier for your database.

Note:
DSN-less connections are not supported. You must obtain a DSN in order to use a database.

MS SQL 7.0
MS SQL is powerful database server and fully compatible with ASP. It is available with the
Silver or higher plans. If you need to use this feature, please check the available SQL plans here,
then send an e-mail to billing@nextwebhosting.com



[back]



Getting SQL 7.0 Connected

This document provides connection instructions for SQL 7.0 users. The instructions were written for accounts hosted on the Windows 2000 platform. If your account is hosted on Windows NT 4.0 please contact Technical Support for client configuration set up.

You will need:

  • Your server name or TCP/IP address and server port.
  • SQL Server 7.0 Server Enterprise Manager installed. If not, you will need to run SQL Server 7.0 setup from your SQL software and select the Client Connectivity and Management Tools options.
Note: SQL Server Enterprise Manager is a 32-bit application. It cannot be installed on computers running
16-bit operating systems.

Follow these instructions:

Configure Your SQL Server Client

  1. On the Start menu point to Programs/Microsoft SQL Server 7.0 and then click Client Network Utility. The SQL Server Client Network Utility screen opens.
  2. Click Add (for a new server) or Edit (for an existing server). The Network Library Configuration screen opens.
  3. Enter your server name in the Server alias text box. (This refers to the server running Microsoft® SQL Server™ that listens on the TCP/IP Sockets network library) .
  4. Select the TCP/IP option.
  5. Enter your IP address in the Computer Name text box. (This refers to the computer that listens for TCP/IP Sockets clients.)
  6. The port number should always be 8181. (This is the default TCP/IP port SQL listens on.) Click OK.

    Client Network Utility
Establishing the Connection:

Note: You can use the SQL Wizard or setup manually. These instructions use the wizard. If the Register Server Wizard does not start, then someone selected From now on I want to perform this task without using a wizard when the Register Server Wizard was last used. If so, the Registered SQL Server Properties dialog box opens. Most Wizards can be accessed from the Tools menu in this dialog box.
  1. On the Start menu point to Programs/Microsoft SQL Server 7.0 and then click Enterprise Manager. The SQL Server Enterprise Manager screen opens.

    SQL Enterprise Manager

  2. Right click the SQL Server Group. (In the example shown, it is highlighted and located in the left pane below Console Root.)
  3. Click New SQL Server Registration. The Register SQL Sever Wizard opens. Click Next.
  4. Select the server you defined using the SQL Server Client Network Utility. Click Add and then Next. The Select an Authentication mode part of the wizard opens.
  5. Select the SQL Server login (SQL Server authentication) option. Click Next.
  6. Enter your login name and password. Click Next.
  7. Select Add the SQL Server to an existing group. Use the default Group name (SQL Server Group). Click Next.
  8. Completing the Register SQL Server Wizard screen displays. Click Finish.
  9. The status should show the registration was successful.
Additional Resources

Microsoft® SQL Server™ is a complex Client/Server database system. Microsoft includes an online SQL Server Book when SQL is installed. This can easily be accessed from Start/Programs/Microsoft SQL Server 7.0/Books Online.

You also can find information at www.msdn.microsoft.com/library or of course, through a third party book. Although our technical support staff is very knowledgeable, to better serve the needs of all our customers it is our policy to limit technical support to only the connection process of SQL as it relates to web hosting.

Troubleshooting
  • Is the server name correct?
  • Is the IP address correct?
  • Is your online connection working?
  • Are your userID and your password correct?
  • Are you using the correct network library? (i.e. TCP/IP)

[back]



SQL Server 7.0 FAQ

What is the SQL Server Client Network Utility?
The SQL Server Client Network Utility is used for managing the client configuration for DB-Library, Net-Libraries, and custom-defined network connections. Reconfiguring using this utility allows SQL Server to listen on additional server Net-Libraries.

Here is how Microsoft explains it in the SQL Server Books Online "...if your server uses a network protocol on which SQL Server, by default, is not listening, and the SQL Server Net-Library for that protocol is not activated to listen for SQL Server clients, you will need to use SQL Server Network Utility."

What is the SQL Server Enterprise Manager?
SQL Server Enterprise Manager allows for easy enterprise-wide configuration and management of SQL Server and SQL Server objects. SQL Server Enterprise Manager provides a powerful scheduling engine, administrator alert capability, and a built-in replication management interface.

When I use SQL Server Enterprise Manager with your system are there any restrictions?
To prevent your security from being compromised, some of SQL Server's features are not available. All Databases and transfer logs are backed up nightly. In the event that you need to restore data, please contact Technical Support. If it is necessary to restore data that was not due to a malfunction within our systems, you will be charged.

Use SQL Server Enterprise Manager to:

  • Create scripts.
  • Manage backup devices and databases.
  • Manage tables, views, stored procedures, triggers, indexes, rules, defaults,
    and user-defined data types.
  • Create database diagrams, and database maintenance plans.
    (To protect performance, full-text searches are not enabled on our system.
  • Import and export data.
  • Transform data.
Is the SQL Server Enterprise Manager automatically installed on my computer?
No, SQL Server Enterprise Manager is installed as part of the Management Tools for SQL Server 7.0. You must run SQL Server 7.0 Setup and select the Client Connectivity and Management Tools options in order to run this software.

How do I connect to my database on your server?
There are really two parts to this. This first thing you need to do is to make certain you have the SQL Server Client Network Utility installed and properly configured on your remote computer.

Can I have multiple logins?
For security reasons there is only one login.

[back]