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:
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
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. |
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. |