Connect C# windows application to web based Sql server

Question

I have developed c# windows application which is currently working fine with lan based remote sql server using servers IP address. Now i want to host my Sql sever on web. I have hosted my database on web with the help of 'myLittleAdmin for Sql Server'. But i unable to access data from web based sql serve. My connection string is as follow -

connectionString="Data Source= servers_ip_address;Network Library=DBMSSOCN;Initial Catalog= database_name ;Integrated Security=False;User Id= uid ;Password= pass ;Trusted_Connection=true;"

Additional Detail:

.Net Framework - 4.0

Sqlserver - 2008

Just tell me what kind of changes i should do in connection string? Or what else changes or settings i should do?

If anyone have solution please let me know.

Thanks

Shubham Kumar · Answer

Hi just try this

Rajeesh Menoth · Answer

Hi Check this.. Windows authentication add name = windowsConnection connectionString = Server=localhost; Database=databasename; Trusted_Connection=True; /> SQL server authentication add name = Sqlserverconnection connectionstring = server=localhost; Database=databasename;uid=db; password=123  /> Reference : https://rajeeshmenoth.wordpress.com/2014/09/03/login-failed-for-user-c-with-sqlconnection-error/ http://www.c-sharpcorner.com/blogs/solve-error-login-failed-for-user-in-c-sharp-and-sql1 The answer is helpful.Then please accept it ..!!

Dhanesh Nambiyar · Answer

Hello Rajeesh I have tried that connection string also. But not working. Thanks for reference links. Let me check out.

Dhanesh Nambiyar · Answer

Shubham I tried this.

Dhanesh Nambiyar · Answer

When i try to access server with its IP address its automatically connects to my local sql server. and When i try to access server with its Domain name it raise error like Login failed. The login is from an untrusted domain and can not be used with Windows authentication.

Ranjit Powar · Answer

There is some errors occurred then share error message.