GotFusion.com Where your journey begins
Showcase your website at Fusion GalleriesNetObjects Fusion 7 Websites Portal

 


 

Managing Your Microsoft SQL Server Databases

If you do not have a local version of MS SQL Server you can download and install a trial version from Microsoft which will revert to a single user version after 180 days. If you do not wish to install the full SQL Server software on your computer you can select only Enterprise Manager and Client Tools during the install process.

Adding New Databases to SQL Server
  • Open the SQL Server Client Network Utility:
    Click the Start Button
    Hover over Programs
    Hover over Microsoft SQL Server
    Select Client Network Utility

  • On the SQL Server Client Network Utility palette:
    Click the Alias tab
    Then Click the Add Button

  • On the Add Network Library Configuration palette:
    Under Network Libraries Select TCP/IP
    In the Server Alias input box put the name you wish to use for your database
    Under Connection Parameters
    For Server name enter 72.18.129.10
    Un-check dynamically determine port and for Port Number enter 1533
    Click the OK button to save your configuration

Regester Your New Database
  • Open Enterprise Manager:
    Click the Start Button
    Hover over Programs
    Hover over Microsoft SQL Server
    Select Enterprise Manager

  • Adding Your Database to Enterprise Manager:
    Right Click onRemote SQL Server Group and select New SQL Server Registration

  • The Register SQL Wizard will start:

  1. Click Next to begin


  2. Select your database from the list of Available Servers

  3. Press the Add Button and it will move to the Added Servers side

  4. Press Next

  5. Select SQL server information that was sent to me (SQL Server Authentication)

  6. Press Next

  7. Select Automatically Log in, enter the User Name-Password that you were sent

  8. Press Next

  9. Select Add to Existing SQL server group and pick Remote Server Group

  10. Press Next and the wizard will finish and show you the success screen with the name of your database

  11. Press Finish and wizard will say Server Registration Complete

  12. Press Close and your database will appear in the Remote Server List in Enterprise Manager

  • To start and connect to your remote Database in Enterprise manager:
    Click on the plus sign (+) in front of your database to expand options
    Click on the plus sign (+) in front of the Databases option
    Click on the plus sign (+) in front of the name of your database that was sent to you
    Click on Tables to show you the existing table structure

  • To add new tables right click on tables and select New Table
    The Design Table dialogue box will open and you can enter rows and data types
    select Save when you are finished and give your new table a name
    Create as many tables as you need



Return to the TOP of this page

Did you find this tutorial useful?
Do you want to keep this resource online?
Make a donation to keep gotFusion alive


|  Fusion  |  Web Design  |  Hosting  |  Resources  |  gotFusion Store  | 

Problems with this page?  

All content copyright © 2001 - 2017 gotFusion LLC. The name gotFusion and the gotFusion ® logo are registered trademarks of gotFusion LLC
Copyright, legal notice & privacy statement