Error (404) Not Found

[iancha]

An error occurred while establishing a connection to SQL Server, connected to the network or to a specific instance: Error (404) Not Found
Can anyone advise me of a solution to this. Many Thanks

 

[TamarGranor]

You need to tell us a lot more. How are you connecting to the server? Is this a web-based server? If yes, have you confirmed that the site is up and running?

Tamar

 

[Olaf Doschke]

404 is an HTTP status, that's nothing I'd expect from a SQL Server connection.

If a connection to SQL Server is established from VFP via SQLCONNECT or SQLSTRINGCONNECT and an SQLEXEC fails, you get a result <0 pointing out an error. AERROR() will tell more about that and have a VFP error number 1526.

An HTTP 404 status means "not found", URL not found.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[pparkso]

make sure the server machine is reachable, DNS can be resolve correctly, you are able to ping the server. make sure SQL browser service is running on the server. for any issues take a look here: how to fix sql errors

 

[Olaf Doschke]

Sorry for confusing the matter by mentioning VFP.

Just realized by this thread coming up because of pparkso's answer this is the MSSQL Server forum. It won't matter from where you connect to MSSQL, though, be it VFP or other clients. It's not about HTTP traffic. Of course, a server can be on the web, but it's usage still won't happen with HTTP requests. A client typically connects via a DSN you set up in a client system, see ODBC Administrator and in programming you may make a DSN-less connection using a connecton string, see

https://www.connectionstrings.com/sql-server/

Azure Databases will have a Server=tcp:Servername.database.windows.net name, as shown there:

https://www.connectionstrings.com/sql-azure/

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name