Connection problem with Microsoft SQL

Need help Database
1

Hi, This is Sam.
I am new to bubble. It would be appreciated for your inputs.

So actually I am trying to connect my bubble application with Microsoft SQL Server.
I have read a lot of posts n this forum and followed few steps.

I have placed a connection string as below:

  1. Selected the Database type as “Microsoft SQL”
  2. Username and Password: Got the username and password from ms sql (after i have opened the MS SQL in my PC it asked for authentication type and login credentials). So these are the credentials I have entered.

    3)IP Address: I heard that i need to place an external IP address. So I got my pc’s external address from http://www.canyouseeme.org/ and placed this IP Address.
  3. Port Number: I got the got the port number from MS Sql server configuration manager → selected sql server network configuration → clicked on “protocols for MSSQLSERVER” and Right-clikced on TCP/IP and clicked on properties. So there i saw the port number.
  4. Database Name: I have already created a database with name students.

So finally this how my connection string looks like :
mssql://sa:hellobubbler@183.82.236.134:1555/students

I have tried in multiple ways and got the same error saying

I have also tried restarting my sql but there was no change in my result.
Is there anything to change in my windows level ?
What can I check to make this work ?

2

Hello Bubblers,

This issue has not yet resolved. I am still trying for this.

And is there any other source for us to connect with MS SQL server apart from amazon services ?

Any input from you people is appreciated.

Thanks in advance.

Sam.

3

Try checking for non-Bubble documentation on setting up SQL server to serve to the internet.

For example, you may need to configure your router to tell it which computer on the local network should handle requests to port 1555.