>>>
>>>You are right about the Agent.
>>>If SQL Server Express is installed on named instance (which is so) and not use port 1433, how do I find out what port is used? And how to I find out what is blocking user access to the SQL?
>>>Thank you.
>>
>>Ok, I found out (from Task Manager) the port on which SQL Server is listening. But still no solution to what is blocking it. The customer IT says there is no Firewall. But they do have Trend Micro AV but I don't know how to deal with it.
>
>How do you connect to SQL Server?
ODBC from VFP 9 app using SQL server authentication. When I RDP to the server I can connect without any problem. But when a user runs the app from a desktop on their network the connection to SQL Server is blocked.
"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