Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sql Server infrastrusture

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-10-07 : 05:30:52
I just want to know about the network setup with sql server.
When users connect to a database around the office. Is there a main sql server box. then all user pc's have sql server installed with the minimal access a user needs and connects to main server.

Or am i totally wrong.

Regards

Rob

MCTS certified

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-07 : 06:06:34
Usually there is a central database server that the users connect to using SQL Client, Excel, other application.
The security is on the server and database level.

Some users may have local databases (maybe using SQL Express edition).
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-10-07 : 06:56:38
thank you very much

has cleared up a lot. Am learning such a lot but little things just need clearing up.

Regards

Rob
Go to Top of Page
   

- Advertisement -