Connect C# windows application to web based Sql server

Guest User

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User10y ago
Hello Rajeesh,
I have tried that connection string also. But not working.

Thanks for reference links. Let me check out.
Rajeesh Menoth10y ago
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..!!
Guest User10y ago
Shubham, I tried this.
Guest User10y ago
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 Powar10y ago
There is some errors occurred then share error message.
Shubham Kumar10y ago
Hi just try this