SQL Server Connectivity issue on LAN 1

[Qamar Zaman]

Hi Programmers,

i have very small knowledge about SQL Server. i have a application created in VFP9 back-end using SQL Server 2017. Application run successfully on local system.
using following string
nHandle = SQLStringConnect("Driver={SQL Server};Server=DESKTOP-494255d;Database=QAMAR;Uid=;Pwd=;")

now i want to run application on local area network (LAN). how to connect SQL Server Database on an other PC (workstation).

please suggest me with VFP code.

Thanks in advance.

 

[Olaf Doschke]

The connection stays that way as it already has the server name and not "(local)" in the Server option. What you need to change to allow non-local connections and you do that in the SQL Server configuration manager. There's a bit more to do, here's a comprehensive walkthrough:

https://medium.com/developer-diary/how-to-enable-remote-connections-to-sql-server-dc5b6c812b5

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[Qamar Zaman]

Olaf

Thank you soooooo much.

you are so much genius man. Always you help me in many problem.
Thanks Again.

Bye, Qamar