>>>>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.
Thank you. Too bad the customer didn't make the admin so I can add SQL Server. Hopefully he will. Thank you very much for your help!
"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