I am creating an application in which it has to retrieve the data from a database that resides on the other computer. I have searched all the Internet links but couldnt find the required information.
Need some help about this. Currently using Sql Server 2005 Express Edition and Windows XP SP2.
Need some help folks.
Regards.
Amit ChoudharyPosted Mar 10, 2010, 12:39 AM
Follow below steps:
for eg: you have two Computers named Node001 and Node 002
1. install the sql server in Node001
2. Go to Surface Area Configuration from Start->Programs->Microsoft Sql Server 2005 -> Configuration Tool -> SQL server Surface Area Configuration
3. It'll Open a window like this
4. Now click on the selected link and you'll see the window below Now click remote Connection and change the setting like given in below snap shot.
And your Computer Node001 is ready to allow SqlServer remote connection.
Now Create application in Node002 and create a connection string like below:
And your application is ready to connect with remote database on another computer.
Hope you get some help from this.
Please mark post as answer and notify me if it helps you.
Amit ChoudharyPosted Mar 11, 2010, 12:45 AM
NO need to add MDF on your server.... other server will do everything you ju just have to connect with it properly..
also Always mark helping post as answer when somebody helps you. it encourage the user ^_^
Farrukh JaveidPosted Mar 10, 2010, 10:38 AM
Ive got a question, do we need to attach that MDF file to our own Sql Server too or the second computer will do just fine!
Regards,
Sam HobbsPosted Mar 9, 2010, 6:06 PM
Farrukh JaveidPosted Mar 9, 2010, 12:22 PM
Ive created the database and put it on the network. Now I want to attach this file but cant actually find the option to attach the DB.
I wanted to ask one more thing, should i be using MySql or Sql Server 2005 will just do fine?
Thanx for the reply.
Regards.
Sarah NasirPosted Mar 9, 2010, 12:11 PM