Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Profiler connection issue -Please Help

Author  Topic 

arunpundir78
Starting Member

7 Posts

Posted - 2009-11-04 : 11:16:43
When making an entry in " SQL Server Client Network Utility" and make a new entry using the Alias tab and now when try to use the correct login credentials in the SQL Analyser then i am able to scussefully login into the application but when open the SQL profiler and click on Trace->New select the enter the correct "SQL Server" and Login Credentials then System is throwing following error -

---------------------------
SQL Profiler
---------------------------
In order to run a trace against SQL Server you have to be a member of sysadmin fixed server role.
---------------------------
OK
---------------------------


Note:- My SQL Server is 2000 and my server to which i am connecting is SQL Server 2005.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-04 : 12:33:11
You are trying to run a trace with a user that doesn't have the required permissions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -