Not able to execute procedure in AX .

Hi,

I have trying to execute stored procedure from AX and i’m getting following error message :

"Cannot execute the required database operation.
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user ‘Ax_Dubai_user’.

SQL statement: Exec SCOB_IMOSDATAPULL ‘2010-01-01’,‘2014-04-01’,‘3706’,'PANAMAX POOL"

Regards,

Darshan

Ax_Dubai_user doesn’t have permissions to connect to the database.