Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Client Server Databases

Author  Topic 

ExCelciuS
Starting Member

3 Posts

Posted - 2010-06-13 : 09:09:40
Hi all,
I'm new to SQL Server and want to build client-server connection databases. I'm using SQL Server 2005 Express Edition and Windows Vista OS.

Imagine there are 2 PCs, PC "A" and PC "B", PC "A" acts as a server and PC "B" acts as a client. I have a .NET program which installed on PC "A" and doing database operations (insert, update, delete, etc).

Questions:

  • If I want to install my program in PC "B", how my program can connect to database server which is in PC "A"?

  • Do you have a step-by-step guide how to accomplish this task?

  • What should my connection string be? And If I use, windows authentication, what should I fill on the connection string username and password field?


Thank you.

Kristen
Test

22859 Posts

Posted - 2010-06-13 : 10:05:13
See www.connectionstrings.com for info on all the connection strings you are ever likely to need!
Go to Top of Page
   

- Advertisement -