Connecting to Sql server2005 from Other clients

SqlConnection con=new SqlConnection ("Server=servername;database=databasename;integrated security=true");

SqlCommand cmd=new SqlCommand ("your insert query",con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

In your Code I can clearly see that you are probably not using ConnectionString in which format it should be.

Please have a look at THIS[^] to have more clarity about ConnectionString to DB.

Please vote and Accept Answer if it Helped.

Hi Dears :(( :(( :((

Thank you For Your Guidelines.I saw your Page and read it Carefully. I used Connection Via IP from That Page(

Data Source=xxx.xxx.xx.xx,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; )


As you will see in button#3 in my project.
First of All I got Error1(I attached Errors)and The Compiler passed from Catch and I got error3.When I added (Trusted_Connection=Yes)My problem solved but couldn't connect to my DB from Other clients.I used The Idea of mohd Wasif But my problem is reminded yet.

http://www.4shared.com/file/0e9l8mcj/IPErrors.html

Now,What Must I do? Please Help Me ?

Hi Karthik

Thank you for your suggestion. It was great.By your Idea,I could Solve some parts of my problem.
I login into Clients as a administrator and Easily by below connection I can Insert data In Db:

SqlConnection oSQLConn = new SqlConnection();

oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" +
"Data Source=MyServerName;" +
"Initial Catalog=test;" +
"Trusted_Connection=yes";
But When Others login, They Can not insert Data.I add them as admin(in that clients) in those clients But my problem remind yet.

Do you Have Any Idea ?

And I can not understand These Sentences
{
An important point to note - I guess you will distribute this application to others. So make sure you are not having the connection string in plain text. :omg: Encrypt the connection string/ the password :confused:when you distribute the app.
}

Please Help me?especially highlight texts

Thank you

HI :)

Thanks to all my friends that help me for solving my problem. I finally solved my problem .After adding the Users in sql(my DB) and using firwall.cpl for its exceptions (as my friend Karthik told mein this Page

http://support.microsoft.com/kb/914277[^]

)
,I used this Connection and it works.

I will copy my connection here maybe another person use it .


"Data Source=MyserverName;Initial Catalog=MyDataBase;Persist Security

Info=True;User ID=sa;password=password of Sa";

Thanks :-O