|
If you are just starting out with Visual Intercept or setting up a Visual Intercept database for a small team, you may not have access to or licenses for a robust database management system like SQL Server or Oracle. In this situation, you may think an Access database would be the only alternative. However, Microsoft SQL Server Desktop Engine (MSDE) provides a no-cost alternative in these situations that offers all the features and performance a smaller team needs. This month’s tech tip will walk you through the process of creating a Visual Intercept database for MSDE.
MSDE is essentially a free version of SQL Server with some built in limitations in its scalability and features. However, for smaller teams these limitations should be insignificant. You can review MSDE’s capabilities on the product features page.
If you don’t have MSDE already installed you will need to download it from Microsoft. The MSDE home page has links to the free download package. When you install MSDE you will need to use some command line parameters to turn on some features necessary for MSDE to run and install properly. Because MSDE does not have a utility like the Microsoft SQL Server Enterprise Manager,these options must be turned on from the command line.
You will want to use the following switches:
| Parameter |
Value |
Description |
| SAPWD |
AStrongPassword |
This parameter allows you to set a strong sa [administrator] password which is required by the setup. |
| DISABLENETWORKPROTOCOLS |
0 |
Setting this parameter to 0 enables network support necessary to allow other computers to connect to the MSDE instance. |
| SECURITYMODE |
SQL |
Setting this parameter value to SQL allows the MSDE instance to use SQL Server authentication which is the default Visual Intercept configuration. |
If you need more information, all of these switches are documented in the MSDE ReadmeMSDE2000A.htm file. The simplest way to start the installation is to run the setup.exe in the MSDE installation folder followed by the necessary setup parameters, e.g., setup SAPWD="MyPassword25" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL.
Once you have MSDE installed you will need to run the intercpt.sql file to create the Visual Intercept database in the new MSDE instance. The simplest way to run the script is to use one of the many no cost or low cost query tools available on the Microsoft MSDE Partners page. Once you have run the script you are ready to use Visual Intercept with the new MSDE database as you would with any other database Visual Intercept supports.
If you have other questions about issues not included in or beyond the scope of this Tech Tip, please contact Elsinore Technical Support Services at or 866.866.0034, option 2.
|
Go back
