Answer the question
In order to leave comments, you need to log in
What's the difference between two connectionString?
What's the difference between two connectionString ?
1)Data Source=tbvdgkkb55.database.windows.net;Initial Catalog=VeriComm_DB;Integrated Security=False;User ID=***;Password=***;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;
2)Server=tcp:tbvdgkkb55.database.windows.net,1433;Database=VeriComm_DB;User ID=***@tbvdgkkb55;Password=***;Trusted_Connection=False;Encrypt=True;Connection Timeout=60;"
Answer the question
In order to leave comments, you need to log in
The lines are almost identical except for the second one where the encrypt=true option is specified, which enables ssl encryption, and the address on the server must be the same as the address in the server parameter, otherwise the connection will not be established.
The first line is suitable for development and testing with test data.
The second is intended for a working application where data protection is important (azure is a cloud service after all, and before your data reaches the database, they will pass more than one server node, i.e. in theory they can fall into the wrong hands)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question