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 |
|
hardboiled
Starting Member
6 Posts |
 Posted - 2011-12-05 : 13:09:59
|
| I'm pretty new to this so go easy on meHow do I make sqlserver 2008 available to all users.eg if a user is to have access to tables via exceland I need to have a asecond administrator how do I give him access viathe management console.I "thought" NT authentication took care of that , but it doesn't.Help!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-12-05 : 13:22:18
|
| If you want to use Windows authentication, then I would suggest granting access via AD groups. Have groups created in Active Directory for the various types of access that will be needed. Like one for read access and another for admin access. Then add those groups to SQL Server. It sounds like your first user just needs read access, so after you add the AD group to the logins in SSMS, add the group to the database and grant it db_datareader database role. I'm unclear about what access your second administrator needs. Do you mean a sysadmin-type user or an admin of just a particular database? If it's for a particular database, then you would grant db_owner inside the database. If it's for sysadmin access, then you would do that on the logins screen.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
hardboiled
Starting Member
6 Posts |
Posted - 2011-12-05 : 13:55:08
|
| Sysadmin type user.As you can see I'm really new to this.The users are more important.At the mo we're alk part of a work group. Active diretory should come in.later |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-12-05 : 14:00:55
|
| If you are only using a workgroup, then you shouldn't use Windows authentication. Instead use SQL authentication. Create the first SQL login in SSMS, specifying SQL authetication. Then add the user to the database and grant db_datareader. Now create the second SQL login in SSMS, specifying SQL authentication, and grant sysadmin. It's in the login page where you are creating the account.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
hardboiled
Starting Member
6 Posts |
Posted - 2011-12-05 : 14:57:31
|
| OK, I'll try that. A massive thank you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Authorizing others to a database