none
Win2k8 Terminal Services / ODBC RRS feed

  • Question

  • We have an application that runs on Windows 2008 x64 Terminal Services server. The application connects to a MySQL server (Linux) using the connector; no user or system DSNs. When running this application from C drive, it runs fine. However, if we try to run this application off a mounted CIFS share, an error message appears. [-2147467259][MySQL][ODBC 3.51 Driver]Can't create TCP/IP socket (10022). 
    The version of driver is 32 bit 3.51.27. We cannot upgrade the driver in the short term. This application will run fine as administrator if I navigate to the path on the file server using the UNC path \\server1\share\app.exe and running it.

    At this point, since the application can run locally, and can run as admin, I don't believe it is necessarily a MySQL/ODBC issue but maybe some kind of permissions issue.

    Monday, July 25, 2011 12:31 PM

Answers

All replies

  • Perhaps create a previlaged AD account just for that app to launch automatically from startup; Much like the way AD accounts are made when configuring MS SQL 2008.    AD Username  "Admin_MySQL" or something of the kind.


    MCTS, MCP, A+ Microsoft Partner
    Monday, July 25, 2011 5:13 PM
  • Everything runs as expected on 2003 servers, so I don't want to do something like that.  There must be something between the CIFS share and 2008.
    Wednesday, July 27, 2011 6:44 PM
  • As I said previously, everything works fine on Win2k3.  Something else I found.  On Win2k8, if the user has full access to the full path of the executable, everything works fine.  If they have administrator rights to the server, it does not work.  That would lead me to believe the problems are in the permissions on the share, even though it works fine in Win2k3.  So I'm wondering of there is a difference in that regard where Win2k8 is more strict?
    Friday, July 29, 2011 6:36 PM
  • When watching process monitor on both a Windows 2003 machine and  Windows 2008 machine the big difference I see is something like this:

     

    Date & Time: 7/27/2011 08:43:45

    Event Class: File System

    Operation: QuerySecurityFile

    Result: ACCESS DENIED

    Path: \\;LanmanRedirector\;N:00000000c72476b7\netapp\cifs_share\Username\folder1\folder2\application.exe

    TID: 8968

    Duration: 0.0086658

    Information: Owner, Group, DACL, SACL, Label

    I never see the operation QuerySecurityFile (with advanced filtering turned on IRP_MJ_QUERY_SECURITY) on 2003.
    Another strange thing is \\;Lanman......  only appears on 2008, not 2003.  On 2003 anything regarding the exe file shows the UNC path.
    I don't even think this is a Terminal Services problem and just a Windows 2008 problem at this point.

    Friday, July 29, 2011 9:34 PM
  • Never was able to figure this one out.
    • Marked as answer by AdamP_Ohio Tuesday, September 11, 2012 7:29 PM
    Tuesday, September 11, 2012 7:29 PM