sqldependency work fine locally but fail remotly !

Question

Hi,

I have a c# app that work fine on local machine, i'm using SqlDependency notifications.

Now i configured my sql server to accept remote connexion from the internet and everything is ok, i can connect to my database from management studio through internet :
server name : public ip address : x.x.x.x
user : sa
password : ****

In my c# app i'm using this string connexion :
Data Source=x.x.x.x;Initial Catalog=database_name;Persist Security Info=True;User ID=sa;Password=****

Now when i'm try to run my app remotly i'm facing this error : Login failed for user 'sa', the error occur on 5th line (when trying to start SqlDependency service):

        SqlConnection dependencyCnx;
        SqlCommand sqlCommand;
        dependencyCnx = new SqlConnection(myStringCnx);
        dependencyCnx.Open();
        SqlDependency.Start(dependencyCnx.ConnectionString);

I'm not professionnal on c# and sql server, so what i must to do to avoid this problem ?

Answer 1

Now i configured my sql server to accept remote connexion from the internet and everything is ok, i can connect to my database from management studio through internet :

Remove the instance from Internet immediately! And never have a blank password for sa! As a matter of fact, I would recommend that you uninstall SQL Server and take your computer to the cleaners. It is very likely that it has been infected already.

As for why you get that error message, the answer is probably that you are connecting to a difference instance that you think you are connecting to, and at least this instance has a password for sa. But that is your smallest problem right now.

I very strongly recommend you not to expose SQL Server on the Internet!

Answer 2

thank you for your quick response

but if i want to make my app remotly connected what i must to do ? a VPN for example to avoid this risk or what you propose for me ?

Cordially

Answer 3

Any body have idea how to configure VPN to do that job ? and what type of VPN to choose ? is Nord VPN can do the job ?
Thank you.