Troubleshooting
Problem
Installation of Sterling Integrator fails with Microsoft SQL Server 2008
Symptom
The following error is logged in PreinstallSI.log:
[java] ErrorDescription="Error_description_not_available" ErrorRelatedMoreInfo="">
[java] <Attribute Name="ErrorCode" Value="com.microsoft.sqlserver.jdbc.SQLServerException"/>
[java] <Attribute Name="ErrorDescription" Value="Error_description_not_available"/>
[java] <Error
[java] ErrorCode="com.microsoft.sqlserver.jdbc.SQLServerException"
[java] ErrorDescription="" ErrorRelatedMoreInfo="The EXECUTE permission was denied on the object 'sp_columns_100', database 'mssqlsystemresource', schema 'sys'.">
[java] <Stack>com.microsoft.sqlserver.jdbc.SQLServerException: The EXECUTE permission was denied on the object 'sp_columns_100', database 'mssqlsystemresource', schema 'sys'.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQueryInternal(SQLServerPreparedStatement.java:296)
[java] at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:284)
[java] at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:300)
[java] at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getColumns(SQLServerDatabaseMetaData.java:603)
[java] at com.yantra.tools.migrator.custom.CustomEntityDBHome.loadMetaData(CustomEntityDBHome.java:139)
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
31 October 2019
UID
swg21628514