Re: SQL Profiler won't allow a developer to login

Function returns 1 for both of us. I can login to Profiler he get an Invalid
login

"Tibor Karaszi" wrote:

I would have one of them to login using their windows account, open a query window and verify
whether they are sysadmin (using the IS_SRVROLEMEMBER function).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Jason" <JRawlins@xxxxxxxxxxxxxx> wrote in message
news:F66262B3-4767-401C-80D8-AA99225E5DDF@xxxxxxxxxxxxxxxx
Hi,

I have a SQL Server that is causing some issues when devleopers attempt to
load SQL profiler. I am an admin on the server and have no problems at all.

I have read many articles about granting permission to "Alter Trace" but I
have done that with no joy. I am wondering if this is due to the way we give
access to the servers. We use Active Directory groups and add any developers
who need access to this group. The group has SysAdmin access on the server
and each of the developers can do anything on the server except 2 things.
They can't login with SQL Profiler and they can't import SSIS packages. These
two things may be related or not but I'm wondering if giving access through
Active directory groups is causing the problem??

If I add a developer to the Local Administrator group they can run profiler.
So what permissions do I need to give someone to be able to do this without
NT administror access??

The group everyone belongs to is SysAdmin and have the permission Alter
Trace granted..

Your help would be greatly appreciated...

Thanks
Jason


.

Relevant Pages

  • Re: GRANT CREATE DATABASE versus GRANT ALTER ANY LOGIN
    ... server, and is a member of the sysadmin server role. ... could not grant "alter any login" permission to a domain login. ... server or it has been removed "sysadmin" server role. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
    ... you might also need to add the login before adding the login to the sysadmin server role: ... Following this instructions I try solve the authenticate problem in Windows Vista for SQL Server 2005: ... In my case the user account to add in sysadmin role is under a domain. ...
    (microsoft.public.sqlserver.security)
  • Re: Security
    ... the agents login is and i have changed the SQL login that the ... connection to the other server uses to sysadmin. ...
    (microsoft.public.sqlserver.server)
  • Re: Login failed for user NT AUTHORITYNETWORK SERVICE
    ... The only way I am able to force the netork login failure is by restarting ... the MSSQL server process. ... when I do this with the Profiler ... failed login attempts (catch Audit Login Failed event with ApplicationName ...
    (microsoft.public.sqlserver.security)