Unanswered: profiler cannot connect to db to log to table
when ever a profiler trace is run it times out and presents an alert box that states failed to start a new trace. I have tried to run index wizard from within profile as well and recieved a cannot connect to db message. All this magic is done as sa account.
Originally posted by Satya
True, only members of the sysadmin fixed server can execute those tools. Refer to BOL for more information.
thanks for the post. I will look into that info.
BTW, this is all done on the same server - there is no network connection. So I was expecting sa to be part of the sysadmin fixed server. This process works on 1 of 3 machines and I don't see the difference (yet) in the setup.