T
T
Tsiren Naimanov2015-04-28 12:23:23
SQL
Tsiren Naimanov, 2015-04-28 12:23:23

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;"

The first one I took from Properties in the connected database
The second one I took from Azure itself

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Kano, 2015-04-28
@ImmortalCAT

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 question

Ask a Question

731 491 924 answers to any question