Demantra application can be installed on Oracle Database as well as on Micrsoft's Database SQL server. Oracle's recent Demantra release 7.2.0.1 is well supported on MS SQL server 2005 database. If you have already are familiar with Demantra installation on Oracle DB, then installing it on MS SQL sever should be pretty easier.
Pre-requisite for Demantra installation on SQL server can be listed as:
1. The client machine where Demantra is being installed should have MS SQL client (same version as server) installed on it.
2. You should extract standard backup file from the installer, say from "F:\Demantra 7.1.1 installer\Disk1\InstData\Resource1.zip >>unzip>>Infra/Database Objects/Microsoft SQL Server/dumps", and put it in the SQL server machine.
3. Keep handy DB server connectivity information and 'sa'(system administrator) login details.
Installing Demantra on SQL Server:
1. Click on "Setup.exe" (Launch anywhere application for installing Demantra) to initiate the installation.
2. Click on option "Install Demantra Spectrum" and then Click on "Next" button at the bottom.
3. In installation tab, Select component of application to be installed. (say, DM) >> Click on Next >>
4. Select Path where you would like to install Demantra.>> Click on Next >>
NOTE: You will have to put backup file in the same path location on Server machine, as mentioned in point 2 of Pre-requisite section above.
5. Select from options available to create Product launch shortcuts. (say, In a new Program Group)>> Click on Next >>
6. Choose Database type as "SQL Server". >> Click on Next >>
7. Provide details for 'sa' login and the SQL server name. >> Click on Next >>
8. Enter SQL DB Schema/User login and Database to be created in case of fresh install. (In case of upgrade you can enter details for existing Demantra database & schema).>> Click on Next >>
9. Select Engine execution type. (Manual or Automated)>> Click on Next >>
10. Wait for Completion of Demantra installation. >> Click on Done>>
Important Note:
- The SQL DB user should have db_creator and bulkadmin permission
- Backup file should be extracted out and stored in correct path, prior to installation
- Password for DB user should respect SQL server security levels(shouldn't be too simple)
- Ensure SQL server connectivity is established and verified
Refer Oracle Metalink for SQL server support related queries.
1 comment:
Can anyone recommend the top Endpoint Security utility for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central malware detection
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!
Post a Comment