web discussions tasks blogs photos

what will be the connection string for sql server connection in C# windows app.

1anurag1 (2524) ranked 5 out of 52 in web design

2 years ago

i have developed a windows based application on dot net.but i want that my database sql server must be installed on other machine and the application on different machine.
i think if i just change the connection string in app.config file in each client than it must work.what would be the string. how to access database from other system application. please help me

web design

sponsors

Real California Dairy

Share Family Recipes, Take Pictures W/ Our Cows. Just Enjoy Yourself.

www.realcaliforniamilk.com

SQL Server Articles

Read about SSIS, Replication, T-SQL, Security& More!

http://www.sswug.org

Onsite MDX Training

Expert MDX Training given by Microsoft MCITP Certified DBAs

MDXtraining.com

darkdeivu (169) response was accepted on 4/18/2010.

denotes best response, click it to go to the best response.

respond to this discussion

tags:

sql, string

darkdeivu (169)

2 years ago

Here are sample code of the connection string for SQL server connection in C# windows app.
SQL SqlConnection .NET strings

Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
2."Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection
1."Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

I hope this code will help you.. Happy coding!!

1anurag1 (2524) ranked 5 out of 52 in web design	2 years ago
thanks for the precious response.

Real California Dairy Share Family Recipes, Take Pictures W/ Our Cows. Just Enjoy Yourself. www.realcaliforniamilk.com

add comment

similar discussions

Is MySQL and SQL the same?
I need to build a SQL database. Can I do that with MySQL? Point me in the right direction.

What site that I could learn about SQL 2005?
I want to learn more about SQL 2005 especially this is the site we are using in our office. But I...