sql server with client

[solo1234]

Hello everybody,

We are searching for good documentation or pdf file to create a network with one pc with the sql server installed and a lot of clients who are using this sql server.

Hope you can help us.

Nice regards,
Michelle.

 

[gmmastros]

What is the expected size of the database?
What is the anticipated number of concurrent connections?

The reason I ask is because without knowing certain requirements, it would be difficult to give advice. Therefore, please do not respond with 'really big' database or 'a lot of users'.

Depending on your requirements, it could be as simple as a peer-to-peer network where one computer 'acts' like a server simply because it has the SQL Server database engine. The other computer would 'act' like a client because they connect to the 'server' for their data.

On the other hand, you could be looking at spending fair amounts of money on a server computer. This could range anywhere from $10,000 to a $100,000 and up depending on the needs.

One of the reasons I am so fascinated with SQL Server is that it has a wide range of uses and under different circumstances. Most of my customers have very small databases (approximately 1/2 a gig). But I know that others around here have db's measured in terrabytes.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[solo1234]

Hi gmmastros,

Thanks for the reaction.
We are busy to learn something about the sql server and there will maximal 2 users on the network.

We have a network:

ip sql server 2000: 192.168.10.100
Clients: 192.168.10.101 / .102

All computers can be pinged and directories can be shared on all computers.

How do we configure / install so that the clients can be connected to the sql server. (database)

Michelle.

 

[gmmastros]

It's actually pretty simple. Install SQL Server on the server computer. You will need to make sure that the server allows incoming requests. SQL Server uses TCP/IP ports to communicate from one computer to another. By default, the port is 1433. So, in its simplest form, allow incoming traffic on the port, and you're all done.

Start -> Control Panel -> Network Connections
Right click on your network connection
Click Properties
Click Advanced
Under firewall, click settings.

Click the exceptions tab, and add one for port 1433.

Usually, this is all that is required.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[solo1234]

Hi gmmastros,

Is there any documentation on internet about this?

Michelle.