SQL Agent not Showing in SSMS
I have a SQLServer 2005 9.0.3042 installed on two servers. When I assign a
user to the SQLAgentOperatorRole the SQL Server Agent node is available in
SSMS for both servers.
When I move the id to the SQLAgentReaderRole or UserRole the SQL Server
Agent node disappears on NodeB but is still visible on NodeA.
It is my understanding that it should still be visible on both Nodes.
I am thinking something is corrupted on NodeB but not sure how to fix the
issue.
There were several non-dbas managing this server before I arrived.
Thank you
.
Relevant Pages
- RE: SQL Agent not Showing in SSMS
... is it a SQL Login? ... MCTS: SQL Server 2005 ... Agent node disappears on NodeB but is still visible on NodeA. ...
(microsoft.public.sqlserver.security) - RE: SBS 2003 Unable to connect to database STS_Config
... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
(microsoft.public.windows.server.sbs) - Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
(microsoft.public.sqlserver.clustering) - RE: migrating from wmsde to sql server
... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
(microsoft.public.windows.server.sbs) - RE: SBS 2003 Unable to connect to database STS_Config
... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
(microsoft.public.windows.server.sbs) |
|
