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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Jason (JRawlins@xxxxxxxxxxxxxx) writes:
Don't know what to tell you...If I add this developer to the local admin
group he can login to profiler. if I remove him and rely on the access
enabled through the Active Directory group which does give him sysadmin
then he gets an invalid login.

Could you post the exact error message? (There is a button down to the left
that permits you to put the message on the clipboard.)




--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: User Question
    ... and write capabilities. ... Should that be an SQL login or Windows login? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express blank sa passwords
    ... that uses the Sa login, I need to set the password to blank. ... I suggest that you get a voodoo doll of that former DBA, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Using sql to execute a batch file, xp_cmdshell
    ... In here I have entered the login and password for an accepted ... credential when I am running the bath file? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: newbie Simple Question about Users in SQL 2000
    ... access with the roles public and db_owner for the database. ... I still get login failed for user d_xxxx. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: sql express 2005 security
    ... If they can login, they can view the data, right? ... And, yes, this means that the user will be able to connect to the database ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)