SQL Server Instructions

SQL Server Instructions

1.  Import the MDB (either the empty or sample) into SQL Server using the Import Wizard in Enterprise Manager.
    1.1.  Run Enterprise Manager
    1.2.  Select the SQL Server where you want to import the data
    1.3.  Right-Click on the Databases Folder and select All Tasks…/Import Data… from the menu.
    1.4.  When prompted for Data Source select Microsoft Access and browse to the MDB file you want to import.
    1.5.  When prompted for a Destination
          1.5.1.  Select the Microsoft OLE DB Provider for SQL Server (should be selected by default)
          1.5.2.  Type in the name of the SQL Server (should be provided by default)
          1.5.3.  Select the authentication method you wish to use
          1.5.4.  For Database select . This will prompt you for a database name.
    1.6.  Select Copy Table(s) from the source database
    1.7.  Select All the Tables
    1.8.  Select Run Immediately and the import will begin

2.  Set the Primary Key and Identifier field for each of the tables (the SQL Server Import utility does not do this automatically)
    2.1.  Using Enterprise Manager, select the database that was just imported
    2.2.  Select the Tables icon to get a listing of all the tables in the database
    2.3.  Right-Click on the first table (called Analysis) and select Design Table from the menu
    2.4.  Within the design window right-click on the top field (called AnalysisID) and select the Primary Key menu option
    2.4.  Also within the design window select the Identity checkbox for the top field
    2.5.  Close the design window and when asked to save select Yes.
    2.6.  Repeat these steps for every table in the database except for the system tables (system tables begin with “sys”)

3.  Install the DMO objects on any client machine running SPC Explorer
    3.1.  Place the SPC Explorer disk into your CD drive.
    3.2.  Select Install SQL Server Files from the installation utility

4.  Setup the Config.mdb file on the web server for eNetSPC
    4.1.  Using Microsoft Access open the config.mdb file located (by default) in c:\inetpub\wwwroot\eNetSPC
    4.2.  Double-Click on the Table called SPC
    4.3.  In the first record UNSELECT the Access field and SELECT the SQLServer field
    4.4.  Fill in the SQLServerName field with the name of the SQL Server machine
    4.5.  Fill in the SQLServerDatabase field with the name of the database supplied during the Import
    4.6.  Fill in the SQLServerUID field with the an SQL User that has SELECT/ INSERT/UPDATE/DELETE privileges to tables in the database
    4.7.  Fill in the SQLServerPWD field with the password for the SQL User

Search | Site Map | Privacy | About Us