Anyone know how to...

Anyone know how to or where the instructions are for setting up SQL 2000 for
SMS 2.0 usage is? I know you have to create the accounts in both the
computer / domain and in SQL, but what rights do you give them, etc ? There
used to be a "How To" article in the knowledge base, but that has all but
disappeared when SMS 2003 rolled out.
TIA"_M_" <here@.gone.com> wrote in message
news:#b77YR8nDHA.2676@.TK2MSFTNGP11.phx.gbl...
> Anyone know how to or where the instructions are for setting up SQL 2000
for
> SMS 2.0 usage is? I know you have to create the accounts in both the
> computer / domain and in SQL, but what rights do you give them, etc ?
There
> used to be a "How To" article in the knowledge base, but that has all but
> disappeared when SMS 2003 rolled out.
>
This would normally be a post for the SMS newsgroups :)
The easiest way to run your installation, here are the basic steps:
1) allow your SMS Service account to be sysadmin of the SQL Server
2) log in as the SMS Service account and create the database that SMS will
use, I always use SMS<SiteCode>
3) Install SMS under the context of the SMS Service account, when you get to
the database install dialogs, choose SQL Server 2000, do not create a
database, which will then prompt for the name of the existing database.
There are several other decision points, authentication mode and a prompt to
enter the service account...
Steve