>Hi,
>
>I would like to understand better how VFP 9 application connects to SQL Server. Here is the situation:
>
>The application resides on the customer server (VM) (in folder c:\applfolder). SQL Server is in the same box (same VM).
>The application is set to connect to SQL Server using SQL Server authentication. The application has a configuration file where the User ID and Password for the SQL Server are set. So that application is using these credentials to connect to SQL Server.
>
>When I RDP to the server I can start the application and it connects to the SQL Server, no problem.
>
>When any user (who is on the LAN) starts application (by loading the application .EXE from the Shared folder, applfolder) they get error that they cannot connect to the SQL Server.
>
>What permissions should the desktop users have to the SQL Server in order to connect? Or is there another explanation of this problem?
>
>TIA.
Another possible cause could be that the customer network admin says that "SQL Service is not listening on tcp 1433". How do you set SQL Server to listen to this port?
"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