Proxy Authentication While Consuming Web Service

[virendra_sharma]

Hi,

i have windows application , in that i have reference to the web service. Now when i put username and password , application calls to authentication service ( which is hosted on same machine IIS 7.5 ) i get pop up which is asking for Proxy Authentication. can anyone plz help me out for the same :)

Following is the Error :

{"System.Web.Services.Protocols.SoapException: Server was unable to process request. --->      
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'SP_AUTHENTICATE',
 database 'XXXXXXX', schema 'dbo'.\n   at System.Data.SqlClient.SqlConnection.OnError
 (SqlException exception, Boolean breakConnection)\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
 (TdsParserStateObject stateObj)\n   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
 BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\n   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()\n
 at System.Data.SqlClient.SqlDataReader.get_MetaData()\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader
 (SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\n   
 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)\n
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, 
 DbAsyncResult result)\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, 
 Boolean returnStream, String method)\n   at System.Data.SqlClient.SqlCommand.ExecuteScalar()\n   
 at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText,
 SqlParameter[] commandParameters)\n   at XYZService.SecurityHelper.Authenticate(SqlConnection dbConn, String userName, Byte[] password)\n 
 --- End of inner exception stack trace ---"}