windows 7 block TCP communication with SQL server when running the exe from network path
Hello When running our exe on a remote PC on the network as domain Administrator everything runs ok, but when trying to do so as a regular users within the domain, windows 7 block TCP communications with the SQL server (in XP it works ok)If I copy all the exe directory with all the DLLs to the local PC it is running ok. I believe this is something to do with the network settings. What network settings do I need to set in order to get windows 7 trust the exe when running on network path? thanks
March 7th, 2012 10:30am

Hi, Did you recieve any error message when run the exe file with regular users? According to your description, I suggest to perform these tests to troubleshoot the issue: 1 Logon with Safe Mode with networking 2 Temporary disable firewall and antivirus 3 Temporary disable UAC 4 Trun off IE protected mode 5 Reset IE advanced setting I ssuspect the firewall setting block the program. Hope that helps. Regards, Leo Huang TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Leo Huang TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
March 8th, 2012 12:57am

Hi, Did you recieve any error message when run the exe file with regular users? According to your description, I suggest to perform these tests to troubleshoot the issue: 1 Logon with Safe Mode with networking 2 Temporary disable firewall and antivirus 3 Temporary disable UAC 4 Trun off IE protected mode 5 Reset IE advanced setting I ssuspect the firewall setting block the program. Hope that helps. Regards, Leo Huang TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Leo Huang TechNet Community Support
March 8th, 2012 8:51am

Hi, How's everything going on? Please feel free to give me any update. Thanks. Regards, Leo Huang TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Leo Huang TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2012 9:43pm

Hi, As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as Answered as the previous steps should be helpful for many similar scenarios. If the issue still persists, please feel free to reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish. BTW, wed love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems. Thanks for your understanding and efforts. Regards, Leo Huang TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Leo Huang TechNet Community Support
March 15th, 2012 9:32pm

Hello Leo thanks for helping We try it all , but still getting same problem the exe cannot get access to the SQL server any other suggestions thanks
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2012 11:35am

Hi, Thank you for your update. You may try to modify the UAC on Local Security Policy for test: 1 Login with Administrator 2 Type in secpol.msc into the Start menu search box and hit enter 3 browse down to Local Policies \ Security Options\ User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode and double-click on it. 4 Change the setting to Elevate without prompting. Hope it helps. Regards, Leo Huang TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Leo Huang TechNet Community Support
March 22nd, 2012 11:25pm

Hi, Behavior of the elevation prompt for administrators in Admin Approval Mode was already set to Elevate without prompting something else maybe? thanks
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2012 4:22am

Hi, Would you please try disabling TCP offload, RRS and Auto-tuning on the involved Win7 machine since they are new features than XP. You can follow the steps below to do so: a. To disable TCP Chimney Offload, follow these steps: Open the Command Prompt as administrator permission. At the command prompt, type the following command, and then press ENTER: netsh int tcp set global chimney=disabled b. To disable RSS, follow these steps: Open the Command Prompt as administrator permission. At the command prompt, type the following command, and then press ENTER: netsh int tcp set global rss=disabled c. To disable Auto-turning. Follow these steps: Open the Command Prompt as administrator permission. At the command prompt, type the following command, and then press ENTER: netsh interface tcp set global autotuninglevel=disabled On the other hand, how do you disable the Windows Firewall? Please make sure that you are disabling the rules of Windows Firewall profiles instead of the Firewall Service itself. The command to do this is "netsh advfirewall set allprofiles state off", the Firewall Service is always suggested to be enabled in Vista and Windows7. In addition, I'd like to know how do you determine that "the TCP communication is blocked by the Windows7"? I certainly understand that it seems to be the Win7's fault, but please note that the failure can be caused by any involved devices in the connection. I suggest you use the Microsoft Network Monitor tool to capture some traces during the faile process. Let's check if there is any Tcp packets with "Reset" flag=1 or some unresponsive requests between the Win7 and the SQL. Microsoft Network Monitor Tool http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=983b941d-06cb-4658-b7f6-3088333d062f Best regards, Steven XiaoPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
March 27th, 2012 5:52am

Hello, How are you? Is there any update regarding the TCP connection issue? Best regards, Steven XiaoPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2012 5:42am

Hello Steven I did all the steps mentioned above still nothing new... The error I get SQL Server Error: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server not exist or access denied. Our exe use TCP communication with the SQL server and this is not happen when login as admin or when running in local pc I monitor communication using the monitor tool but didnt see any TCP flags = 1 Is there something in particular I can look for when monitoring that can help us get a clue of our problem? thanks
April 9th, 2012 2:20am

Hi, I am having the same problem. We migrated to win7 machines and the exe that is located on a network drive is unable to connect to SQL server anymore. We also tested with local computer administrator rights - exe still can`t connect to SQL. The only way to get it working is with domain administrator rights. The other way is to use this exe on a local hard drive. The problem is very important. because we found another similar problem - there is an application on a network drive that has a startup security check. There is another master PC on network which has a security dongle connected to it. When client launches the application, it tries to read the dongle info from master PC. Everything works ok on XP machine. Windows7 allows to do this only with domain admin account. If application is copied on local hard drive - everything is ok. the sadest thing is that windows does not give any sign or warning.
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2012 10:46am

While investigating I did create a simple VB6 executable with few lines to connect to SQL through trusted ODBC. These lines fail to execute if program is located on a network drive. Dim dbconnstring As String dbconnstring = "DSN=" & ODBCname & ";uid=;pwd=;OLE DB Services=-2" Set cnn = New ADODB.Connection cnn.Open dbconnstring 'obviously here I have a timeout (15 sec) and afterwards it throws: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
April 10th, 2012 11:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics