Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Right now I have Microsoft SQL Server ready configured, I want to use it for accessing database to more than one computer in a LAN. How should I go with it?

share|improve this question

Not quite sure what you mean here but there are several options for accessing data in a database.

You can write a program in a language such as C# which uses ADO.NET to access the database. You can also use excel to get data from the database. SQL Server will support having more than one client so having multiple computers accessing it will not cause any problems.

If you give us a bit more infomration about what you are trying to do we might be able to help you out a little more.

share|improve this answer

You could install the SQL Server 2000 client tools from the same installation medium. That will give client computers access to the SQL Server Enterprise Manager and Query Analyzer.

Connect to your database using your server's name and your credentials (Security/Login).

share|improve this answer

Open corresponding port on the server firewall if any. For basic tasks you can setup an ODBC dsn the get the datas.

share|improve this answer

Set up an ODBC connection on the client computers then use an application (e.g access or a custom written app) to connect to the database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.