December 12, 2006 at 2:50 pm
Hello everyone, I'd really appreciate some help on this one...
I have sql 2000 client tools (EM) installed on my xp machine and I'd like to register remote SQL Servers in enterprise manager so that I can monitor them.
Currently I don't have admin rights to those remote servers. How can I access these remote servers safely using my xp machine's EM client tools ?
will I need to have my domain login added on each SQL Server box ?
thanks !
December 12, 2006 at 4:02 pm
You can only register sql server 2000 servers in EM but you have to have a login (nt/sql) to register irrespective of admin access...
You can't register 2005 servers in EM, you have to install SSMS... You can use QA to connect 2005...
You can use your domain login or sql login...
MohammedU
Microsoft SQL Server MVP
December 12, 2006 at 4:09 pm
Thanks Mohammed
so if my domain login was added to the 'Performance Monitor User' group on the WinServer2003 machines, would I be able to remote connect to each SQL Server instance on those machines ?
thanks again
December 12, 2006 at 6:43 pm
No, not by default.
Your ability to connect to SQL Server depends on what logins the DBAs have authorized within SQL Server. These logins can be SQL Server based, Windows user accounts, or Windows groups. However, they must be allowed to login.
By default the only Windows login permitted is BUILTIN\Administrators, which corresponds to the local Administrators group on the server where SQL Server is installed. Any other Windows users or groups will have to be added by the DBAs. The Performance Monitor User local group is not a group that would have the ability to log in to SQL Server unless a DBA has authorized such.
K. Brian Kelley
@kbriankelley
December 13, 2006 at 7:19 am
Thanks Brian !
What would be an appropriate Server Role within SQL Server for me to monitor logins, maintenance plans, and check things like recovery models for each database ?
I only want enough permission on the SQL Server to simply monitor these things, so something like System Administrator would be a bit much.
Thanks again.
December 13, 2006 at 2:42 pm
I'll rephrase my question as it may not be specific enough....
What server and/or database role will I need to analyze Database Maintenance Plans in SQL Server 2000 ?
currently I have 'TargetServersRole', but this doesnt allow me to view Database Maintenance Plans or Database Maintenance Plan History......can someone guide me through this ?
December 13, 2006 at 4:24 pm
As per BOL...
You must be a member of the sysadmin role to create and manage maintenance tasks.
MohammedU
Microsoft SQL Server MVP
December 14, 2006 at 6:23 am
Thanks Mohammed.
It would be great if there were a role to simply view maintenance tasks and histories and not have sysadmin control, but I'm not sure if that is at all possible. I'll just assume that it isn't.
December 14, 2006 at 8:09 am
so here is something interesting (for a noob at least!)....
on 2 SQL Servers I have the same SQL roles : Security Admininstrator, Process Administrator, and I have 'TargetServers' role on msdb.
I can see the Database Maintenance Plans and history on one SQL Server, but I cannot see them on the other SQL Server.
any clues as to how this is happening?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply