Microsoft Identity Integration Server 2003 Reskit graphic

MIISSQLDiag

MIISSQLDiag retrieves and displays the MIIS 2003 service status, the SQL Server status, and configuration information about the SQL server used by the MIIS 2003 server. Used without parameters, MIISSQLDiag displays the following information:

Syntax

miissqldiag [/s:Servername [/u:[Domain\]Username [/p:Password]]] [/t] [/l:Loglevel]

Parameters

/s:Servername
Specifies the MIIS 2003 server name. The server name can be given as a system name, an IP address, or a domain name. If the parameter is not specified, the local system is used.
/u:[Domain\]Username
Specifies the user account used to authenticate to the specified server. If the server is in a different domain, the domain name must be specified along with the user name. If the parameter is not specified, the current credentials are used.
/p:Password
Specifies the password for the user account used to authenticate to the MIIS 2003 server. MIISSQLDiag prompts for the password if the server name and the user name are specified but the password is not.
/t
Displays the status of the SQL server used by MIIS 2003.
/l:Loglevel
Specifies the log level for writing messages to the log file. The possible values are: The log file is created in the current working directory with the name MIISSQLDiag.log.
/?
Displays help at the command prompt.

Examples

To display the MIIS 2003 service status and the configuration information of the SQL server used by MIIS 2003 from the local MIIS 2003 system, type the following command:

miissqldiag

To display the MIIS 2003 service status and the configuration information of the SQL server used by MIIS 2003 from a remote MIIS 2003 system, type the following command:

miissqldiag /s:MIIS-1 /u:MIISuser /p:pwd

To display the local MIIS 2003 service status and the configuration information of the SQL server used by MIIS 2003, and also to display the SQL server status, type the following command:

miissqldiag /t

To display the MIIS 2003 service status and the configuration information of the SQL server used by MIIS 2003 from a remote MIIS 2003 system and to test the SQL server status, type the following command:

miissqldiag /s:MIISRemote /u:MIISuser /p:pwd /t

To save all the log information in miissqldiag.log and display the status of the SQL server, type the following command:

miissqldiag /s:MIIS-1 /u:MIISuser /t /l:1

MIISSQLDiag errors and warnings

Error Code Description
2226 The MIIS 2003 service is not installed on the server.
2227 The user name or password is specified as an argument but the server name has not been specified.
2228 The server name and the password are specified as arguments but the user name is not specified.
2229 The specified user does not have sufficient privileges to access the information.
2231 The specified server is not a valid MIIS 2003 server.
2232 MIISSQLDiag could not run due to .NET framework security policies or low trust on MIISSQLDiag.exe. This error will occur only when running MIISSQLDiag.exe remotely. Increase the trust on MIISSQLDiag.exe to "Full trust" and try again.

Common command-line Errors and Warnings

Error Description
2004 A string value was expected for the parameter but the value is not specified.
2006 The date specified is not a valid date.
2007 The time specified is not a valid time.
2008 The computer name specified is not a valid DNS computer name.
2009 The computer name specified is not a valid computer name.
2010 The user name specified is not a valid user name.
2011 The file name specified is not a valid file name.
2012 The path specified is not a valid path.
2014 The file path specified is not a valid file path.
2015 A parameter was specified without a "/" or "-" character preceding it.
2016 A specified parameter is not valid for this application.
2017 A specified integer value is not a valid integer.
2020 A mandatory value for a parameter was not specified.
2021 A value was specified for a parameter that does not allow any values.
2026 A parameter value was specified where the application was not expecting any value for the parameter.
2027 A parameter that is only allowed to occur once was specified more than once.
2028 A parameter that is allowed to be repeated n times was repeated more than n times.
2029 A mandatory parameter was not specified.
2033 A specified parameter value is not in the list of allowed values for that parameter.
2035 The application failed to create a log file. A file already exists with the same name, and is marked Read Only or Hidden.