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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-27 : 08:17:50
|
| Matt writes "Installing SQL 2000 on a W2k Adv server (DC). The manual says to create domain accounts and give them rights. What rights and where, the domain security policy ???Previous install would never let anyone logon. Always came back with the error: Not associated with a trusted SQL server connection.So I figured I would start fresh and try a re-install. I created a domain user "SQL_Sa" and put that in a local group "SQL_Users"... Now what ??? I want this account to run the service accounts.Then after install how do I allow users to logon and use it using Windows Authentication... ???" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-27 : 12:30:46
|
| The SQL_Sa should be a local administrator on the server where SQL Server is to be installed. It should not be part of a group that has other SQL users in it. Just add SQL_Sa to the administrators group on the server. Now add all of the user accounts to the SQL_Users group. After the install, just add the SQL_Users group to the SQL Server by going to Enterprise Manager, go to your server, click security, then add a new login. Just add the group rather than a specific login. Then grant the appropriate permissions. If all of these users will need the same permissions, then you should add a role inside the database then grant the permissions on the role.Tara |
 |
|
|
|
|
|
Domain user accounts on a W2k DC for setup