RE: SQL Agent not Showing in SSMS

Yes it is a sqlLogin but it is just created and is correctly mapped.

"Mohit K. Gupta" wrote:

The Login ID in question, is it a SQL Login?

if so try using sp_change_users_login stored procedure to map it properly in
the server.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Thom" wrote:

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: Cluster Configurations
    ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • RE: Active Directory Group in SQL Server 2005 SP3 Server
    ... MCITP: Database Administrator ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ...
    (microsoft.public.sqlserver.security)
  • Re: SQL native client
    ... "Mohit K. Gupta" schrieb im Newsbeitrag ... i have a VB6 app which connects via SQL native client 2005 to a SQL Server ... As other computers don't need admin rights i think it's a config. ...
    (microsoft.public.sqlserver.clients)
  • Re: Too many full-text columns or the full-text query is too compl
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... "Mohit K. Gupta" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server Named instance with Default Instance
    ... There should be no problem with a default instance and a named instance. ... instance to SQL Server. ... "Mohit K. Gupta" wrote: ... > SQL DBA team install named instance on the cluster enviornment. ...
    (microsoft.public.sqlserver.clustering)
Loading