Make my connection string to SQL Server database using a static IP secure

Question

I'm using the following connection string to connect from my windows app to SQL Server database that located on a WebSite:

dim constr As String = "data source=IPAdresse;initial catalog=mydb;User Id=username;Password=pwd

is this way of connection secure?

Should I use (https://) before writing the IP address in the connection string?

If not, how can I make my connection secure and unavailable to hackers?

how can I make my connection secure and unavailable to hackers? in short you can make it more secure but never unavailable to hackers. There's other ways beside just a connection... — Trevor
– Trevor, Commented May 29, 2016 at 23:07

gofr1 · Accepted Answer · 2016-05-29 10:17:49Z

1

Another way to protect your connection is to work with SQL Server not directly, but via some basic API.

For example, you have SQL Db, you create some php-based service, which will communicate with internet via some url and commands (https://myapi.com/?showsomething=this&date=...) and with SQL Server - via PDO or sqlsrv or whatever commands. You can enable https connection to API.

answered May 29, 2016 at 10:17

gofr1

16k11 gold badges47 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Make my connection string to SQL Server database using a static IP secure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related