Help on Registering SQL Server in Enterprise Admin

Dear All
We want to monitor SQL job history for 50+ servers using id which doesn't
have admin priviliges on server and database. On database front I can
achieveit by assiging TargetServer role but I want to add all servers in
Enterprise Administartor console. What are minimum rights we require to
register server in Enterprise Admin for Windows 2000 & 2003 Servers?
Rahul> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
You will have EM installed on your workstation and to know a login and
password to register the SQL Server
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message
news:36C3F6A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...
> Dear All
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
> --
> Rahul|||The minimum 'rights' to register a server are to be able to log into the ser
ver. It is not necessary to have permissions for any database.
However, in order to view the job history in EM (SQL 2000), I think that it
will be necessary to be in the sysadmin server role for all servers. (I'm a
little fuzzy on this...)
For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or s
ysadmin) in order to view Job history of all the jobs.
If you used Query Analyzer and had some form or script, it would be necessar
y to only have SELECT permissions on the various sysjob... tables in the msd
b databases.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6A6-BBF7-41A1-A97B-
E5EC3A6AD6F9@.microsoft.com...
> Dear All
>
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
>
> --
> Rahul|||Dear All
Thanks for your inputrs. But how I will give permission to domain user to
log on to SQL Server? Do you mean by adding user in SQL Login? Also when we
add user to SQL it asks for "Database" name, like master etc or user created
like test,test1 etc.
So which database we need to assign while adding user to sql login and what
will be security implications of same? I.e.if we add user with database as
master or user database test then what rights the user will have on these
databases'
Rahul
"Arnie Rowland" wrote:
[vbcol=seagreen]
> The minimum 'rights' to register a server are to be able to log into the s
erver. It is not necessary to have permissions for any database.
> However, in order to view the job history in EM (SQL 2000), I think that i
t will be necessary to be in the sysadmin server role for all servers. (I'm
a little fuzzy on this...)
> For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or
sysadmin) in order to view Job history of all the jobs.
> If you used Query Analyzer and had some form or script, it would be necess
ary to only have SELECT permissions on the various sysjob... tables in the m
sdb databases.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6
A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...