SQL Server
Overview
If SuiteFactory can't be effectively deployed using Microsoft's Access database or your company's requirements don't allow the use of Access, SuiteFactory supports "SQL-Lite" MSDE, SQL Server and Oracle(2006). If your active Users exceed 12 and or your system access is heavy SQL is probably a better choice then Access.
If you are installing SQL Server you will need to select this as the "Select a Database Provider" since the system defaults to "Microsoft Jet 4.0". You should also select this option if you chose to use "SQL-Lite" MSDE. MSDE is optimized for about 5 Users even though there is no limit. MSDE has a minimum of Management tools available also.
Note: If you have an existing SuiteFactory Database that is "Access" based you will need to upgrade the database to version 6.5.211 before trying to upgrade to SQL Server. You will also need the "Access to SQL upgrade Document" before proceeding. Call CCI for details. DO NOT Try this on your own!!!!!!!!!!!!!!!
Select Server where SQL resides
Chose the Server with the SQL database resides and the following Window will be displayed after setting the Instance Type to Default Instance and clicking the Connect Button.
SQL databases displayed
Server List Type
Window
This displays the various Servers supported under Window is show here for completeness sake.
SQL Server
This displays the various SQL databases on the selected Server as selected in the "Available SQL Servers" drop down list.
Available SQL Servers
This displays all of the possible SQL on the Network. Chose the appropriate Server that you want to attach to.
Instance Type
In general you will select the Default Instance when selecting know SQL databases.
Default Instance
This is the first SQL established and is always the Default Instance.
Named Instance
If you select the Named Instance you will need to find out these from the IT department..
Connect Button
In order to display the various SQL databases after setting all of the correct options as explained above you will need to this button and all of the SQL databases will be displayed for the selected options.
Create
Select a Server where you would like to install the SQL Database and the following Window will be displayed:
Create a new SQL Server Database
Add the Catalog Set Name, we are going to use "PCMC". Now click the Browse Button and select the Folder that you want the database to reside in. See below:
Selecting the database location
Click the Make New Folder and click OK.
If you are successful in creating a new database the following Window is displayed:
Click the OK Button and the following Window is displayed showing the Catalog Set Name and the path where the database is located.
Catalog Set Name & Database Location Window
Click the OK Button and you will be brought to the login screen.
Login
The initial login into SuiteFactory is Administrator with no password. Administrator has complete "Rights" to SuiteFactory and should only be used by the System Administrator. The User Name is not case sensitive.
Make sure to assign a password immediately to this Super User as this User can do anything.
