Connecting to a MSSQL Server 2016

Wappler General How To
#1

My situation in the local network:

  • I’m working on a iMac
  • the Testserver is a Windows Webserver 2016 (192.168.16.6)
  • the SQL Server is MS SQL Server 2016 (192.16.16.5 on Port 1433)

I have a local directory for my site on my Mac

I am connected to a MS Windows Webserver via FTP.

The connection and uploading works fine.

Now my problem:
I can not figure out how to make a connection to MS SQL Server with Server Connect. I always get an error:

“Error using Database Connection! Can not connect to database! Check your network or server address”

The connection with SQLPro Studio does work without problems.

I’m using asp.net, any idea what could be the problem?

Thanks for your help in advance.

#2

Can you ping your database server from your web server?

#3

yes. Ping works fine

#4

Have you defined a target in Wappler that goes to your web server and is the SQL Server IP accessible from your webserver? Not blocked by firewall or so?

#5

The SQL Server IP is accessible from the webserver and is not blocked by the firewall.

Could it be a problem with the FTPUser? The FTPUser does not belong to the Domain. It is a local user account on the webserver.

#6

target is created and works

#7

Checking Connection …
drwxrwxrwx 1 owner group 0 Oct 18 15:07 App_Data
drwxrwxrwx 1 owner group 0 Oct 18 15:07 Bin
drwxrwxrwx 1 owner group 0 Oct 18 15:07 dmxConnect
drwxrwxrwx 1 owner group 0 Oct 18 15:08 dmxConnections
-rwxrwxrwx 1 owner group 117 Oct 18 15:08 index.html
Connection Test completed successfully…

#8

I found the problem. It was a misconfigured DNS.

This video helps a lot, for those who have a similar problem:

2 Likes