Failed to open a rowset.
Details: ADO Error Code: 0x
Source: Microsoft SQL Native Client
Description: The EXECUTE permission was denied on the object 'SpPayPeriodTimecardCA', database 'WaspTime', schema 'dbo'.
SQL State: 42000

Open Microsoft SQL Server Management Studio Express on the server, select <server>\WASPDBEXPRESS for the server name and Windows Authentication, then click Connect. Click + next to Databases, then right click WaspTime and select Properties.

On the Permissions page click TimeUser, then scroll down the list of Permissions and check the Grant box for Execute, then click OK.