sql server - How to use stored procedure in Geoserver?

I have a MS SQL Server 2008 R2 and have a stored procedure in here. I want to create a layer in Geoserver using this. I try:

EXECUTE [dd_base].[dbo].[Request BaseSration]
  'param1',
  'param2',
  'param3',
  'param4'
GO

And get error near key word EXECUTE.

In Geoserver logs:

ERROR [geoserver.web] - Failed to create feature type

java.io.IOException: Error occurred building feature type

What am I doing wrong?

Answer

I don't know what instructions you are following, could you post them here to further study your issue? I found a link that addresses configuring the mssql for geoserver correctly, which if the error is not a coding issue perhaps it will help. http://docs.geoserver.org/2.1.3/user/data/sqlserver.html