Re: Problems with remoting and SqlCommand.ExecuteNonQuery

From: Ken Kolda (ken.kolda_at_elliemae-nospamplease.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 08:32:56 -0700

Don't know if this will help, but I know we ran into some problems with
self-signed certificates and SQL Server which may be affecting you (since
you said you're using IIS).

http://support.microsoft.com/default.aspx?scid=kb;EN-US;302409

Hope that helps -
Ken

"otto" <otto@discussions.microsoft.com> wrote in message
news:D045E6FE-C20E-4248-8653-4F21D2CDFDBD@microsoft.com...
> Hi, all:
> I´m having problems with a .net remoting application. The problem is as
> follows: I have a windows forms application that connects to a .net
remoting
> components hosted in an IIS (in a separate server). This remoting
component
> is a data access component, in other words, it performs data access tasks.
> The problem arise when I try to execute a database task which involves the
> use of ExecuteNonQuery method (like delete a product, for example). When I
do
> this, this error appears: "Unable to write data to the transport
connection.
> The connection has finished: Could not establish a secure channel for
> SSL/TSL." This is very strange, but I can confirm that the error raises
when
> executing that method. Does anyone know what is the reason for this? Is
there
> any relation between these elements? I´m using an Http channel and
Microsoft
> Data Access Application Block for database operations.
> Any help would be appreciated.
>
> Thanks a lot.

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)
  • Re: SSIS - OLE DB Command - how to retrieve query results ???
    ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
    (microsoft.public.sqlserver.dts)
  • RE: xp_cmdshell, ownership chaining, sql 2000
    ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
    (microsoft.public.sqlserver.programming)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
Quantcast