11.4 Creating a Default Logon Profile

All AppManager command-line scripts require you to log on to an AppManager repository. By default, AppManager scripts use the following login information:

Logon Parameter	Default
/USER	Windows user account name with which you logged on.
/PASSWORD	Password for the current Windows user account.
/SERVER	Windows name of the local computer.
/DATABASE	Repository name of QDB.

To create your own default logon profile for AppManager scripts, add a section called [Default Logon] to the netiq.ini file (located in the %SYSTEMROOT% directory) and enter the logon parameters. For example:

[Default Logon]
USER=FRED
PASSWORD=SCOOTER
SERVER=SHASTA
DATABASE=MY_QDB
DEBUGGING=TRUE

NOTE:In creating a default logon profile, consider your security requirements. For example, you may want to include only the /SERVER and /DATABASE parameters, requiring the /USER and /PASSWORD parameters to be entered at the command-line.

If you do not want to include the password in a default logon profile, change the SQL Server security mode to minimize the arguments entered at the command-line.

With Windows Authentication or Mixed security modes, SQL Server uses Windows security to authenticate a Windows user at the computer where the script is being run. The Windows user is allowed to log on if authenticated by SQL Server. In this case, only two parameters (/DATABASE and /SERVER) are required to log on. These can be included in the netiq.ini file or entered at the command-line.