Login Form

When Katmandoo is started using either by double-clicking Katmandoo2 icon or "Katmandoo2.GUI.exe" file, Login form is displayed. It is used to authenticate user for a selected database before user is allowed to access the database.

Illustrative snapshot:

1. Released version of Katmandoo.
2. Database server name that hosts databases (3) of Katmandoo. The database server can be changed by modifying the .config file of Katmandoo. Please contact Katmandoo Team for customised-build to use different database server. In this snapshot, "KatmandooMSDE" is the database server installed in local computer.
3. List of Katmando database names that are available in the database server (2).
4. Click it to reload database names from the database server (2).
5. Enter user name (if you have logged-in into Windows, then the logged-in name is displayed here which can be changed as required).
6. Enter password for the user.
7. If you do not want to continue, click it to close Katmandoo.
8. After selecting CORRECT Database Name, entering user name and password to login into Katmandoo.

Katmandoo can be configured to use authentication-token of the operating system so that user does not have to enter user name and password to login. If user want to change the user name after successful auto-login, then user can use [ Tools > Database > Switch Database ] or can click on Switch database icon in the toolbar.

Use the steps below to configure Katmandoo for Auto-login:

1. Open the Katmandoo2.GUI.exe.config file in a text editor (eg notepad).
2. Find "UseWindowsAuthenticatedLoginName" key in the config file and set its value from "false" to "true".
   •  <add key="UseWindowsAuthenticatedLoginName" value="false" />
3. Save and close the text editor.
4. When user login after the first successful login, Katmandoo will attempt to login the user to the last-used database.

Right-click on Login form to display context menu.

Illustrative snapshot:

1. Attach Database (available only when using Local Database Server)
2. Fix login and Permission (available only when using Local Database Server)
3. Detach Database (available only when using Local Database Server)
4. Reset [ dba ] password
5. Generate Encrypted Text

Right click in the Login Form to activate context menu and click on [ Attach Database ] to attach any database into the Local Database Server.

Illustrative snapshot:

1. Click it to select the database to attach in the database server which is installed in your computer. When a database name is selected in the Open Dialog, and click on "open" button of the dialog window, Katmandoo will update MDF File Name, LDF File Name and database name of the selected database as shown in the snapshot.
2. Or manually you can change the LDF file if required.
3. Or manually you can change the Database name if required.
4. Enter login name. If the database is located in your computer enter [ sa ]. The login name is used to connect to the database (so its not your login or user name).
5. Enter login password. If the database is located in your computer enter [ rescue12 ] (assuming that the database password has not been change). Then click on [ Attach Database...].

Important Note: Please make sure that the database is NOT already attached in the database server.

It is particularly useful on sharing database between the colleagues and here is the process to share the database:

• User 1 detach a database
• User 1 sends the "mdf" and ".ldf" file to User 2
• User 2 copy the file to the database folder (eg C:\Program Files\Katmandoo2) (in this snapshot it is C:\Katmandoo\Database).
• User 2 uses [ Tools > Database > Attach Database ] to attach database in his/her computer using the form shown below.

Right click in the Login Form to activate context menu and click on [ Fix Login and Permission ] to fix login and permission problem that occurs when the database is detach from one database server and attached into another database server.

 

Right click in the Login Form to activate context menu and click on [ Detach Database ] to detach a database from the Local Database Server.

Illustrative snapshot:

1. Click it to select the MDF file of the database
2. When the MDF file is selected, the database name is updated. It should NOT be changed.
3. Enter login name. If the database is located in your computer enter [ sa ]. The login name is used to connect to the database (so its not your login or user name).
4. Enter login password. If the database is located in your computer enter [ rescue12 ] (assuming that the database password has not been change). Then click on [ Detach Database...].

User should contact system administrator of Katmandoo to reset your password. But if you're the System Administrator and have forgotten all the passwords that are used in Katmandoo, then Right click in the Login Form to activate context menu and click on [ Reset dba password ].

Illustrative snapshot:

1. Database name (Name of the database in which to restore the password of dba): Katmandoo2_2
2. Database Login Name: sa
3. Database Login Password: rescue12
4. [ dba ] user name: dba
5. Enter encrypted password: B6YL8tnN+Y50MA2AFxeCkurGa6Y=
   • Note: If you have changed the default password of the [ dba ] then you need to either ask database administrator in your IT Department to retrieve encrypted password from the SystemUser table in the database or you can send the database to one of the member of Katmandoo Team to retrieve the encrypted password.
6. Then click on [ Reset dba password to rescue12 ]

This form can be used to generate Encrypted Text as well as to change the Database Login password.

Please take following measure before changing database login password.

• Create a new System Adminstrator login for [ sa for SQL Server ] or [ root for MySQL ] in case you forget new password for the System Administrator.
• User can use this form to change database login password only if the database is running to your computer.

Follow the steps below to change database login password stored in the Connection Strings of the "Katmandoo2.GUI.exe.config" file:

• Open "Katmandoo2.GUI.exe.config" in text-editor and find [ UserDbServer ] key.
• Note "uid" and "pwd" values in the connection string of [ UserDbServer ].
• Note "uid" and "pwd" values in the connection string of [ AdminDbServer ] which is after [ UserDbServer ].
• Start Katmandoo and Right-click on Login form to activate context menu.
• Click [ Generate Encrypted Text ] menu to activate following window.

 

1. Enter text (alpha-numeric) to generated its encrypted text (see 2)
2. Click on [ Encrypt Text ] to generated the [ Encrypted Text ] using the plain text (see 1).
3. Use [ Decrypt Text ] to confirm the encrypted text.
4. Click it to close the form.
5. Enter the password from the [ UserDbServer ] key in the ConnectionStrings section of the .Config file.
   • If the password has already been encrypted, then its better to copy from the .Config file and paste here.
6. Click it to replace existing password (see 4) for the connection string of [ UserDbServer ] with the encrypted password (see 2).