Re: Connection to SQL on WMI Executed Process

From: [MS] Scott McNairy (scotmc_at_online.microsoft.com)
Date: 03/24/04

  • Next message: [MS] Scott McNairy: "Re: How to list the application/Virutal Directory in IIS?" 
    Date: Wed, 24 Mar 2004 15:51:23 -0800

    This seems very related to the SQL Server configuration, perhaps a password
    reset or something along those lines.

    I would think that the SQL Authentication model would work here, I would
    attempt to get that SQL model working from the target machine itself, then
    try to do it with WMI.

    The other security model won't work by default, that would be a delegation
    hop, and you need to do several things to make that scenario work properly.
    Like enabling the machine for delegation, being a member of an Active
    Directory domain, and requesting the proper authority and delegation levels
    on the IWbemService, apply the proper scope object to the request in .NET,
    or SWbemService object. 

    -- 
[MS] Scott McNairy
WMI Test Engineer
This posting is provided "As Is" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jason" <jtiger12ANTISPAM@yahoo.com> wrote in message
news:064A53B6-9A32-4E90-A5FF-4E918D9BEFBE@microsoft.com...
> I have unique situation that I cannot find a solution for. I am writing a
custom Client/Server application that remotely triggers a small client
executable on a machine using WMI. Once the executable installs the software
it is looking for, it logs the install info to a sql DB. In the past, I have
been remotely executing the process using sysinternal's psexec. The client
executable has not changed since then. Since I have started triggering the
client through a WMI win32_process, the client cannot open up a connection
to my SQL server. I have tried using both SQL Auth and Windows Auth. it
stops execution on this line - rs.activeconnection = conn.connectionstring.
I have tried using all different levels of security_Privledges.
  • Next message: [MS] Scott McNairy: "Re: How to list the application/Virutal Directory in IIS?"

    Relevant Pages

    • Re: COBOL stored procedure for DB2
      ... Have you also confirmed that, prior to executing the CALL statement, the ... Client code -- the CALL statement being used. ... MODIFIES SQL DATA ... lnk-policy is the parameter provided when the program is executed, ...
      (comp.lang.cobol)
    • Re: Dont understand what version of SQL to install
      ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
      (microsoft.public.sqlserver.setup)
    • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
      ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Oracle 10g2 LIKE operator and case-insensitive issues
      ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
      (comp.databases.oracle.server)
    • Re: Oracle 10g2 LIKE operator and case-insensitive issues
      ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
      (comp.databases.oracle.server)
    • Quantcast