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



Jason (JRawlins@xxxxxxxxxxxxxx) writes:
Function returns 1 for both of us. I can login to Profiler he get an
Invalid login

"Invalid login"?

When I tried to log in with plain-vanilla user I got a message box
telling me that I needed ALTER TRACE or be a sysadmin member. If your
colleague is getting Invalid login, he appears to be logging into some
server where does not have any login.

--
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
.