Step by step instructions for adding an SQL database to a VPS or Dedicated Server Account

Step by step instructions for adding an SQL database to a VPS or Dedicated Server Account

When you sign up for a VPS or Dedicated server account you will receive two emails from Server Intellect. The second contains your login information for your Windows server but the first contains the control panel information for the shared SQL server.

Locate the section of the first email that contains the SQL information. It should look something like this.

Log into the Server then click on the Domains icon.

You need to add a domain name in order to create databases. Please note that this domain name does not affect web or emails services or anything else at all. It is merely used for tracking purpose to associate a database with a domain name. You can enter any name you like in the field. So select the Add New button to add your domain.

Next enter the domain name.

Once that is done click on the domain name you entered.

You should now be present with the Database Manager icon. Click on the icon to start creating your database.

Click the Add New Button and the select your database type and the name for your database and click Save.

After that is complete click on the Add New button under the users box. Then enter a user name and password and click save. Please note that this use is assigned DBO permissions to the database.

Now that you have entered the all the information your database is ready to use. You should be presented with a dialog box containing the IP address and port number for you database. Use these plus the login you have just created to connect to your database in your web application or in your SQL Management tools.