Step 1 - Adding Security Tables to an Application Database

The Help topic Security Tables contains a list of all security tables needed for an MM .NET Windows or Web Forms application. You can place these tables in your main application database or in another secondary database.

Automatically Adding Security Tables to your Database

If you are working with SQL Server, S QL Server Express or MSDE, you can run a script, MMSecurity.sql, that automatically creates these tables for you. In addition, this script also creates a user named "MM .NET User" with an ID of "MM" and a blank password.

To run this script:

If using SQL Server, launch the SQL Server Management Studio. If using an older version of SQL Server, launch the SQL Query Analyzer tool. In either case, connect to SQL Server.
If using SQL Server Management Studio, press Ctrl+O to launch the Open File dialog. If using SQL Server Query Analyzer, click the Load SQL Script button in the Query Analyzer toolbar. Regardless of the tool you are using, in the dialog, navigate to the \Program Files\MM .NET Framework 2026\MM .NET Framework Wizards\Scripts directory, select the MMSecurity.sql file, and click the Open button.
This displays the MMSecurity.sql script file in the Query window:
Go towards the top of the script file and look for the following:
```
use <Security Database>
```
Change <Security Database> to the name of your security database. For example:
```
use Northwind
```
To run the script, press F5, or select the Execute Query button from the toolbar.
When the script is finished executing, you should have all the MM .NET security tables in your database.

Note: The script adds a LanguageFK column to the Users table. This column is used in applications that implement MM .NET Localization. If you have no need for this column, you can remove it.

Manually Adding Security Tables to your Database

If you are not using SQL Server of MSDE, you need to manually add the security tables to your database. For a list of all tables and their structure, see the Help topic Security Tables.

Remember, after manually creating the tables, you need to add at least one user to the table so you can access the application!