I have had this issue a few times and I always forget how to fix it.
Could not start IIS. RedGate.Profiler.Engine.Exceptions.CannotStartSessionException at . .Launch() at ? . . ? () Caused by: Could not start IIS. RedGate.Profiler.Engine.Exceptions.CannotStartIisSessionException at . . () at . .Launch() Caused by: Could not start w3wp as the specified user. Win32 error code: 1385 RedGate.Profiler.Engine.Exceptions.CannotStartIisSessionException stack trace: at ? . ? .?? () at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at . .?? () at . .?? ( ) at . . () Caused by: Could not start w3wp as the specified user. Win32 error code: 1385 RedGate.Profiler.Engine.Startup.IIS.IISException stack trace: at . .StartProfilingIIS(String , String ) at RedGate.Profiler.Engine.Startup.IIS.IISStarter`1.StartProfilingIIS(String currentUserName, String subprocessVariableValue) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at RedGate.Profiler.Engine.Startup.IIISActuator`1.StartProfilingIIS(String currentUserName, String subprocessVariableValue) at ? . ? .?? ()So I need to run my IIS as a network user in order for it to work through SQL Auth etc, the reason it is failing, is because the user isn't an admin user on my box. So go to Administrator Tools -> Groups -> Administrators and add your network user here, check names and it should work!