The Microsoft SQL database server software provides a data management system for the Windows platforms.
Install Microsoft SQL and SQL Server Management Studio Express:
1. Do a typical installation of SQL Server Express. Use all the defaults except set the server to use both Windows and SQL Server Authentication. This can be set later if you do not do this during the installation.
2. Go to Start menu and pick: Programs->Microsoft SQL Server 2005->Configuration Tools-> SQL Server Configuration manager.
3. Click on the SQL SERVER 2005 Network Configuration item in the left tree view.
4. Click on the Protocols for SQLEXPRESS in the left tree view.
5. Enable the TCP/IP and Named Pipes options.
6. Right click on the TCP/IP option in the right window and select Properties from the context menu.
Remove the port number for TCP Dynamic Ports and set the TCP Port to 1433 for IPAll.
7. Restart the server by click on the SQL Server 2005 Services item in the left tree view. Select the SQL Server (SQL EXPRESS) option and click the restart button in the toolbar or right mouse click and pick restart from the context menu.
8. Do a typical installation of SQL Server Management Studio Express with all default option.
Create an MSSQL example database instance named SMDB in SQL Server 2005:
1. Start SQL Server Management Studio Express: Start->Programs menu.
2. Click on Server Name from Object browser. Right mouse click on the Database on right window and select New Database.
3. From the New Database window, give the new database a name, such as SMDB.
Create an admin user for your new database:
1. Under the Security/Logins section, right mouse click and pick New Login.
2. From the general section, enter the name of the admin user. Select SQL Server authentication and give the new user a password. Uncheck the box labeled Enforce password policy.
3. Set the default database to the database you created in step 2 above.
4. Click on Server Roles in the left window. Check the box next to sysadmin as shown below. (The Public box should already be checked.)
5. Click on User Mapping in the left window. Check the box next to your database (e.g. SMDB) 6. Click on OK to create the new user.
Utilities
Content Vault / File Server
SimManager stores all data files into a file storage repository or file vault. The SimManager system can be configured to use several different integrated file vault systems for the management and storage of files. It can use the local and network file management and storage capabilities of your system and no additional software is required.
FTP File Vault
Alternatively, the following applications can also be used to enhance and expand the file management and storage capabilities of the SimManager system.
If an FTP server is already installed and operational on your system, obtain and verify the user name, password, FTP root directory, and FTP port. These inputs will be required in configuring SimManager.
Installing and/or Configuring FTP Server
The FTP server software is an optional component of the SimManager system, but in typical
deployments, this software will be used to manage the data files that SimManager processes generate.
You can configure SimManager to use the FTP server for file vault management. For Linux and UNIX platforms, an FTP server is provided as an operating system component and is typically installed with the operating system. Any FTP server that supports passive-mode file transfer can be used in the
SimManager system. The following section describes installing and/or configuring a typical FTP server on the supported platforms.
A separate user account is not required for using the FTP server. We recommend, and it is good practice, to assign a unique user with limited privileges for security reasons. MSC Software recommends using the user name ftpuser and password ftppasswd. To ensure security, these values should be changed after the initial installation of the SimManager system. When this change is made, verify that all references in the SimManager configuration and properties files are consistent.
To install the FTP server on Windows:
If the FTP server is not installed on your system currently, follow the instructions below to configure the Windows Internet Information Services.
Using Windows IIS (Internet Information Services):
1. Under Start Settings Control Panel Add or Remove Programs.
2. On the left, select Add/Remove Windows Components.
3. If necessary, select the check box for IIS box, and then select Next.
4. Create a new user and password to use with the FTP file vault. From Start Settings Control Panel Administrative Tools Computer Management Local Users and Groups
Users.
5. Use the Action New User pull-down menu to create a user named ftpuser and password, ftppasswd
.
6. Under Start Settings Control Panel Administrative Tools Internet Services Manager, verify that FTP server is started.
7. Under Default FTP Site Properties Home Directory, verify that the Write check box is selected in the FTP Site.
The user name, password, FTP root directory, and FTP port will be required to configure the SimManager using the Admin tool.
If an FTP server is already installed and operational on your system, obtain and verify the user name, password, FTP root directory, and FTP port. You can find this information for Windows by:
a. Start Settings Control Panel Administrative Tools Internet Services Manager.
b. Expand hostname, select Default FTP Site, and then right-click on the Properties tab.
c. For Username and Password, select the Security Accounts tab.
These inputs will be required in configuring SimManager.
To install or configure FTP server on AIX:
1. If necessary, add a user to perform FTP functions. Root access is required to add users to the system.
2. Go to SMIT Security and Users.
3. Select USERS Add a User.
4. Enter the User name, ftpuser, (up to 8 characters) and Password, ftppasswd, and then select OK.
5. Create a vault root directory /tmp/ftp_vault.
6. Verify that the FTP server is functioning by testing a simple FTP command with the user name and password of the vault.
The user name, password, FTP root directory, and FTP port will be required in configuring the SimManager using the Admin tool.
To install or configure FTP server on Linux:
If you do not have a current version of an FTP server on your system, the WU-FTP server application can be downloaded from http://www.wu-ftpd.org. See Installing WU-FTPD installation instructions available at http://www.wu-ftpd.org/wu-ftpd-faq.html.
1. If necessary, add a user to perform FTP functions. Root access is required to add users to the system.
2. Create a user by using the useradd command:
Note: For installing IIS on Windows XP refer to system “Help and Support” for complete instructions
%>useradd -M ftpuser
3. Create the user password by using the passwd command:
%>passwd <username> For example: “passwd ftpuser”
4. Create a vault root directory, such as /tmp/ftp_vault.
5. Verify that the FTP server is functioning by testing a simple FTP command with the user name and password of the vault.
The user name, password, FTP root directory, and FTP port will be required in configuring the SimManager using the Admin tool.