Connection String for SQL Azure Database

Need help Database
1

I am pulling my hair out trying to get the correct connection string to connect to my Azure SQL database…

To follow the format it is saying I am attempting to use the following:
sql://[adminuser:password]@nvr2lte.database.windows.net:1433/[DatabaseName]

The connection string according to Azure is:

Driver={ODBC Driver 13 for SQL Server};Server=tcp:nvr2lte.database.windows.net,1433;Database=[DatabaseName];Uid=[adminuser]@nvr2lte;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

Can someone please help me get a connection string that works? Thank you very much.

2 Likes
2

Anyone?

3

You should use mssql:// etc. at the beginning of the connection string.

4

Still not working… Can someone show me there actual connection string to azure… just put in [password] where the password is? That would be very helpful…

5

I got this from your other post. You know you have to put in your actual parameters such as, Database name, Uid, password? The only reason I say that is because in your other post you were asking if you needed to place your password.

I have not recently connected to mssql so it not fresh in my mind.

msssql://…

50%20AM
50%20AM787×378 26.1 KB

Good luck

6

mssql://yourusername:yourpassword@your.domain.com:1433/yourDBName

7

Ha… yes I realize that and did… It still is not working… It is timing out.

8

The actual string I am trying to use is this:
To follow the format it is saying I am attempting to use the following:
mssql://[adminuser:password]@nvr2lte.database.windows.net:1433/[DatabaseName]

obviously, the real one has the correct user/password and database name in it…

9

This might help:

Example in post:
mssql://username:password@myserver.database.windows.net:1433/MyDatabase?encrypt=true

10

That is good info, but in my case, I am not using any special characters?

11

How about the last section?

12

What last section are you referring to?

13

No mine should be fine… I am only using letters and numbers. I am starting to wonder if it is a firewall issue on Azure… What ips is bubble using to connect?

14

It was a firewall issue… Does bubble only use a single ip address or a range of ips? I put in the one that it was sending from and it connected fine… I just want to make sure there are not others…

1 Like
15

Firewall was on the back of my mind the entire time. To SafeList IPs lets get the answer directly from the Bubble team.

16

Did you ever get an answer to this? As I’m developing, I feel like I’ve having to whitelist a new bubble IP every day. Does not bode well for production.