>>>>>>Here is the situation.
>>>>>>
>>>>>>1. If I RDP to the server where VFP 9 application (that uses SQL Server) resides and start the executable the connection to the SQL Server works. I tried Windows authentication or SQL Server authentication, both work. (Note that the SQL Server is on the same box as VFP 9 application).
>>>>>>
>>>>>>2. If I start the VFP 9 executable from a desktop on the network (either navigating to the server and running .EXE or creating a shortcut) the connection to the SQL Server denied. The computer/desktop from which I am running the .EXE is Windows 7. And I tried to run this .exe as administrator but the same negative result.
>>>>>>
>>>>>>What could be preventing connection to the SQL server when starting the app from desktop and not the server?
>>>>>>
>>>>>>TIA
>>>>>
>>>>>Firewall.
>>>>
>>>>I have access to the server. How would I check if there is a firewall on the server?
>>>
>>>
>>>Control Panel->Windows Firewall.
>>>Just add exception for SQL Server.
>>
>>The customer showed me screen shots that point that the Firewall in the Windows on the server is turned Off. So the firewall does not apply.
>>
>>If you think of what else could be blocking the application from a workstation, please let me know.
>>Thank you.
>
>Maybe this will help:
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspxThank you very much. Right before I got this your message I resolved the problem. But I will still read this URL; I am sure I will learn a lot there.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham