An SQL Server is a high performance database server available to customers on the Shared 2 Windows Plan (TrueAdvanced Plan) or higher that is designed for high traffic and large databases.
In order to setup your SQL database, we require several pieces of information regarding the database. Please contact Granite support for SQL server setup.
Once we have completed the database setup (you will receive a set-up confirmation e-mail), you will be able to access your SQL Server account.
To access the SQL database you can use any database management software, such as Microsoft Access, Visual InterDev, or the SQL Enterprise Manager.
If you are using Microsoft Access or Visual InterDev you will be connecting to the SQL via an ODBC connection, which requires you to create a Data Source Name on your local computer. To do this follow these instructions:
Go to your ODBC section on your computer and open it. In Windows 95/98/NT, your ODBC settings can be found in your administration page.
Add either a File DSN or a Machine DSN. It does not make a difference, the decision is up to you.
Click the "add" button, and then select the SQL server driver. If you do not have this driver you must get it in order to make a connection to the SQL server. You can get this driver by going to Microsoft's Web site at http://www.microsoft.com/SQL/.
After it displays the information on the DSN you are setting up, it will ask for the server location. In this field, type in the IP address you received in your setup confirmation e-mail. It also asks for a username and password, type in the one you requested on the SQL setup form.
Click the "option" button. You will see a series of dropdown boxes. Find the box labeled database and click the down arrow.
If your ODBC driver is working correctly you should see a list of databases, and yours will be highlighted.
If you are using SQL Enterprise Manager, you need to follow these instructions:
Open the SQL Enterprise Manager
Click "Server", "Register Server".
Once the dialog box is open fill in the fields. In the server field, type in the IP address you received in your setup confirmation e-mail.
Fill in the login information with the username and password that you requested. If you did not request one, enter your ftp username and the original password we setup for you when you opened your account.
Once all the information is entered press the "register" button, this will make contact with our SQL server.
Now that you are connected you can add tables and manipulate your information as you wish.
If you have any questions please browse the frequently asked questions page. If you are still unable to resolve your question, please submit a support request. - Updated: March 13, 2001
CATEGORY
RESULTS 
Knowledge
Base 
