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.
| Author |
Topic |
|
BadBoy House
Starting Member
41 Posts |
 Posted - 2009-07-15 : 09:42:28
|
| Hi all.I'm in the process of setting up our new SBS 2008 Premium server and Member Server. I now need to install and configure SQL Server 2008 on the Member Server.So far I've installed SQL Server with all the default options selected. It installed fine and looks to me as though it's ready to use.What I'm interested in finding out (before we contact our line of business app support teams) is whether or not any server roles or anything needs to be configured on the member server for SQL.So far as all we've done is install SQL it seems too easy to not need anything else configuring.thanks in advance |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-07-16 : 10:36:53
|
| The typical "it depends". Who is connecting to your server? What rights do they need from a datbase perspective? Read-only? Update? Create tables? Execute? I, personally, would limit the user's access to fulfill only their needs, nothing more. If multiple users need the same functionality, create roles and assign those rolse to the user(s). Makes life a little easier.Terry-- Procrastinate now! |
 |
|
|
|
|
|
How to install SQL Server on a Member Server??