Access SQL Server Localhost database, from an external web service?

tv6aics1  于 12个月前  发布在  SQL Server
关注(0)|答案(1)|浏览(110)

I have the next setup for SQL Server on my machine => And I'm able to login from SSMS with the next data=>

Server Type: Database Engine
Server Name: DESKTOP-9J8RFVD\SQLEXPRESS
Login: SamLProgrammer
Password: 12345

When I open this Server in the SSMS, and I go to databases. I can find a database that I created from SQLCMD named "myDatabase".

However I'm trying to connect to that database from an external connector called "Skyvia"

And it requires the next data:

But as you can see, I throws an error labelled as 26 -error. And I still don't get why. That is my IP address, I queried from "whatismyip.com".

I have also opened ports through windows firewall. And enabled TCP/IP and ALLIP ass follows:

But I still don't know what configuration I'm missing. Please I would be really glad to any help

New edits:

I used the number 1 ip address to open my router port 1433. I dont know if that should be the right one to use.

ldfqzlk8

ldfqzlk81#

At the very end, this was the way it worked for me tcp:,

相关问题