In SQL a Stored Procedure with optional parameters are showing Required when passing the value into the SmartObject method.
There is no error, but this is not expected behavior. See below.
Double check that the account that is configured for Authentication in the SQL Server Service Instance has View rights to the Stored Procedure and Table(s) being called by the Stored Procedure. See below screenshot of SQL Server Management Studio.