Re: DBA can't see other jobs

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 01/07/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Tue, 7 Jan 2003 21:27:07 -0000

Well something sounds screwy with the Authentication :-)
What operating system is she using on her desktop ?
What's the OS on the server? It would be worth getting your
Network/System Admin's involved to see what makes this
users domain account/desktop different from everyone else
It seems the domain account is ok as the server can correctly
authenticate it locally but not remotely. It might be worth also
checking the client Network utility to check whether Named
Pipes or TCP/IP is being used to connect and switching it
around to see if that helps (on her desktop). 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Elliot Marc" <nomail> wrote in message
news:uSF6eCptCHA.2332@TK2MSFTNGP12...
> Thanks, Jasper.
>
> I just sent this to the admin. She will probably get back to me tomorrow.
>
> Meantime, I forgot to mention that IF she logs in locally (console or
> Terminal Service) to the SQL server in question, she can see ALL jobs.
>
> The problem occurs only when she uses Enterprise Manager remotely from her
> desktop to connect to the SQL server.
>
> I hope this additional info jolts some memories.
>
> Thanks, again, Jasper.
>
> Marc
> "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
> news:eQzlzZotCHA.2604@TK2MSFTNGP12...
> > If this admin runs the following in QA when connected
> > via NT Authentication can she see all jobs or just hers
> >
> > select * from msdb..sysjobs_view
> >
> > also , what are the results of the following (replacing the
> > domain\username with her details)
> >
> > exec master..xp_logininfo 'domain\username'
> >
> > select IS_SRVROLEMEMBER('sysadmin')
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "Elliot Marc" <nomail> wrote in message
> > news:#ml1iqntCHA.1668@TK2MSFTNGP09...
> > > I have a unique situation here, and I'm hoping someone can help me.
> > >
> > > One of my Admins (who is a member of the builtin\administrators group)
> can
> > > only see the jobs she schedules. She can not see other jobs created by
> > other
> > > people.
> > >
> > > The builtin\administrators group is in the sysadmin roles. Other
people
> in
> > > this role can see ALL the jobs, just not this admin.
> > >
> > > Any pointer/help greatly appreciated.
> > >
> > > Marc
> > >
> > >
> >
> >
>
>

Relevant Pages

  • CUPS problem printing pictures is very slow
    ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
    (Debian-User)
  • CUPS problem printing is slow
    ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
    (Debian-User)
  • Re: Login failed for user (null).
    ... authenticated connection with SQL server. ... Whether or not the remote service accepts the authentication from client ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Manager Server Registration General Network Error
    ... I can ping the server by name from the affected client. ... I can register the server by name using SQL Authentication (rules out name ... Verify that the instance of SQL Server is listening Correctly ... I use Active Directory Account on Windows 2000 machine. ...
    (microsoft.public.sqlserver.connect)