Connecting to database SQL server 2008 in remote machine using c#
my database is in a remote server in Sql server 2008
I m using .net Framework 3.5 how should i connect it through c# code. ?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Chandu KumawatPosted Feb 18, 2016, 5:07 AM
Manoj KumarPosted Feb 18, 2016, 4:58 AM
Shourya VerdhanPosted Nov 20, 2012, 9:41 PM
i have a software now i want to install SQL in only server and use from other 10 client pc..
my connection string is
"data source=192.168.113,1433; Network Library=DBMSSOCN; initial Catalog=ndts_tm247; integrated security=true;";
I already use id n Password but no same problem coming again n again.
i had also change my port no from the fire wall n my tcp/ip is also enable.
but it not works..
any one can help me so please do....
my email is [email protected]
or just give me a miss call
Mob:+91-8010359695
Vikrant MorePosted Sep 28, 2012, 5:01 AM
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
User ID=myUsername;Password=myPassword;
Vikrant MorePosted Sep 28, 2012, 4:59 AM
Vikrant MorePosted Sep 28, 2012, 4:58 AM
Pradip PandeyPosted Sep 28, 2012, 4:01 AM
Are u able to connect to Sql Server on your remote server by using this information
Server Name:113.30.141.10,1433
Login:sa
Password:Mypassword
If not, plz check it to correct network related error.
Hope it will help.
Ramesh MuruganPosted Sep 28, 2012, 3:29 AM
The server has Sql Server 2008, Is is necessary to install Sql Management studio 2008 in my computer too.
The code is showing me Network Related error
Vikrant MorePosted Sep 28, 2012, 3:19 AM