-
On the menu bar, select File > Database Type Test and Query.
-
To connect to the Admin schema whose parameters are defined in the Intools.ini file on the current client computer, select Actions > Use INI File.
The software automatically retrieves the connection parameters from the Intools.ini file for the Admin schema.
OR
To connect directly to the target Domain schema without specifying the Admin schema parameters first, under Database type, select SQL Server.
-
When connecting to a Domain schema in a database that is located on another computer, make sure that the appropriate ODBC profile exists on the current computer.
-
The ODBC driver box must display MSS. This value is retrieved from the Intools.ini file, where it appears in the [Database] section as the DBMS parameter value. Make sure that in the MSS value of the DBMS parameter appears in upper case. Otherwise, it is not possible to work with specifications in Smart Instrumentation.
-
-
Under Connection settings, in the Schema logon name box, type the target Domain schema logon name specified by the System Administrator when initializing the domain.
-
In the Schema logon password box, type the target Domain schema logon password specified by the System Administrator when initializing the domain.
-
Enter or modify the DBParm string using the following values:
DBParm=ConnectString='DSN=<ODBC profile name>;UID=<Domain schema logon name>;PWD=<Domain schema logon password>',DisableBind=1
If you connected to the Admin schema using the Intools.ini file parameters, the DBParm string is retrieved automatically from the Intools.ini file. When you change the
logon name and password, the software does not update the DBParm string. You must manually change the UID and PWD values to match the Domain schema logon name and password respectively.
-
For SQL Server 2014, the default ODBC profile name for SQL Server is MSS2014.
-
If the Server name and Database name boxes do not display any settings, you can leave them blank.
-
-
Select Actions > Connect
.
The Results pane displays the result of the connection. A zero (0) indicates a successful operation. Codes that indicate a connection failure include a message explaining the reason for the failure.