Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

4 Answers 4

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

 
discard

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