Prevent Repeated Password Prompts When Using SQL Login in Micromine Geobank

Issue

After setting up a connection to your Micromine Geobank Configuration Database using an SQL login and password, you are prompted to enter your password each time you launch Geobank.

Although it could be a helpful behavior for elevated security circumstances, this is often excessive and unnecessary.

Objective

To provide a seamless login experience by configuring SQL Server authentication to only require the password once during initial setup, eliminating the need for repeated password entries on subsequent startups.

Overview

Micromine Geobank uses a Microsoft SQL Server database known as the Configuration Database to manage its configuration tables. Connection to this database must be established upon the first launch of Micromine Geobank. Primary data storage occurs in a separate database, which requires its own connection specifications.

Solution

This document describes the steps to set up an SQL login connection to a database. While configuring this connection, you’ll need to pass an SQL login password only once.

1. Edit Connection Properties:
In the Connection “Property Editor”, click “Connection Properties” and then “Build…” to define the ADO connection string.

2. Choose SQL Provider:

- In the “Data Link Properties” dialogue window, proceed to the “Provider” tab.

- Select your preferred provider for SQL Server connectivity. For example, you can choose the "Microsoft SQL Server Native Client 11.0" or "Microsoft OLE DB Provider for SQL Server" or any other listed provider that supports SQL Server.

3. Specify Login Details:

- Switch to the “Connection” tab in the same dialogue window.

- Set the connection mode from “Windows NT integrated Security” to “Use a specific user name and password.”

- Enter the “User name” and “Password” associated with your SQL Server login.
These credentials should match those configured in SQL Server under Security -> Logins.

Note: Ignore the “Allow saving password” checkbox, as it does not affect the login prompt behavior in Micromine Geobank.

4. Finalise Connection Setup:

- Click “OK” to return to the “Property Editor” screen.

- In the “Connection Properties” tab, re-enter your password in the “Password” field.

- Make sure the “Display login prompt” box remains unchecked to avoid the login prompt at future starts.

Verification

Restart Micromine Geobank to ensure the password prompt no longer appears, confirming a successful configuration.

Want to learn more?

Click here to login to our Learning Management System

Click here to request access