connect with sql server through IP address

Question

4.00/5 (1 vote)

See more:

Dear Friends I want to connect sql server through IP address i means sql install in other pc in same Lan network and c# install in my PC. Now i want to connect with both. I have right following code...

__________________________________________________________________________________

C#

string Connection = "Data Source= dell-pc; User ID = sa; Password= mkj@123; Initial Catalog= asset; Network Address= 192.168.22.136 ; Network Library=dbmssocn; Trusted_Connection=yes; Integrated Security=SSPI";

                SqlConnection Connections = new SqlConnection(Connection);
                Connections.Open();
                MessageBox.Show("Success.......");

___________________________________________________________________________________

and this code showing following error:

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Please helo

Posted 30-Jan-13 20:18pm

Nand Kishor Upadhyay

Updated 31-Jan-13 20:12pm

Shanalal Kasim

v2

Add a Solution

Comments

Santhosh Kumar Jayaraman 31-Jan-13 2:34am

192.168.22.136 is your server name

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Answer 1 · 2013-01-30T20:24:00

Solution 1

Yoou have to give your server name in DataSource instead of Dell-pc

it should be something like this:

CSS

Data Source=192.168.22.136,1433;Network Library=DBMSSOCN;Initial Catalog=asset;
User ID=sa;Password=mkj@123;

At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.

Posted 30-Jan-13 20:24pm

Santhosh Kumar Jayaraman

Updated 30-Jan-13 20:45pm

v2

Comments

Joezer BH 31-Jan-13 2:46am

5+

AdityaPratapSingh · Answer 2 · 2013-01-30T20:24:00

Solution 2

try this

C#

string Connection ="Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
User ID=myUsername;Password=myPassword;";

Posted 30-Jan-13 20:24pm

AdityaPratapSingh

Comments

Joezer BH 31-Jan-13 2:47am

5+

Dineshshp · Answer 3 · 2013-01-30T20:35:00

Solution 5

Try this...

//if "IntegratedSecurity" is false
string conStr = "Data Source=192.168.11.11; User Id=uid; Password=pwd; Database=databasename";

// otherwise
string conStr = "Data Source=192.168.11.11; Integrated Security=SSPI; Database=databasename";

using(SqlConnection con = new SqlConnection(conStr))
{
    con.Open();
}

Posted 30-Jan-13 20:35pm

Dineshshp

Comments

Joezer BH 31-Jan-13 2:46am

5+

AdityaPratapSingh · Answer 4 · 2013-01-30T20:31:00

Solution 4

http://www.connectionstrings.com/sql-server-2008[^]

Posted 30-Jan-13 20:31pm

AdityaPratapSingh

KManishS · Answer 5 · 2013-02-02T00:30:00

Solution 6

write your IP Adress in Datasource, That they said above

Posted 2-Feb-13 0:30am

KManishS