>>>Got a VFP app that I'd like to take to a SQL backend, but it won't connect. Says everything is fine, but when I try to do anything on the connection it gives me an error that basically says 'Not connected'
>>>
>>>Research on that error generally comes back to 'port issue' so, what port does VFP default to use and is it possible to change it?
>>
>>If you are not set the exact port the VFP uses 1433 (default). But you should check what protocols are enabled on both:
>>Server and Local machine.
>>If SQL Server is enabled in Windows Firewall.
>
>So, of course I'm getting a different error now.
>NOW it's telling me that it can't log in to the database that I can connect to in SQL itself with the same login creds.
>::Headdesk::

Do not add Database=???? and try to connect to the default database (master)
if you can connect then your use has no rights over the database you want to connect to.