Q:

How to make a remote connection with SQL Server 2008 with ADO.NET entity Data model from C# winform

I have built a window form application and I use ADO.NET entity Data model to make connection with my local database and it work good with my own PC (the database and application in one PC).  
Now I need the application to be used by many users 3 or 4. I have no idea how  to install my database on the server and whether ADO.NET entity Data model will work again. I use SQL Server 2008 and C# window Form. Please I am waiting to hear what your suggestion will be. 

A:

all you need to do is just change the Data Source value in your connection string.
Follow the below Steps:
Step 1: Install and Maintain Your Database in your server machine.
Step 2 : Specify your databse Server HostName/IP Address in your Connection String as below:
String   connectionString="Data Source=ServerName;Intial Catalog=DatabaseName;UID=userID;Password=password;Integrated Security=True;"

