Is My Automation Manager Identity Configured Correctly?
Feature Only in Enterprise Edition SQL source code debugging is supported only in Visual C++ Enterprise Edition. For more information, see .
If you install SQL Server and then install Visual C++ Enterprise Edition (including the Visual C++ Enterprise server-side components) on the same computer, the automation manager's identity is registered as The interactive user. In this scenario, if you log off from this machine but keep SQL server running as a service, you will not be able to remote debug against this server. Registering the automation manager's identity as The interactive user requires that someone be logged onto the computer to remotely debug SQL.
When installed with a pre-existing SQL Server, the Visual C++ setup registers the automation manager as The interactive user, with the assumption that you'll want to do local SQL debugging. SQL debugging may not work if the automation manager's identity is registered as The launching User (the default) and SQL server and the automation manager are already running in the service environment.
To change the automation manager identity
On the computer on which you installed SQL Server and then installed Visual C++ Enterprise Edition, run DCOMCNFG.EXE.
On the Applications tab in the Applications listbox, select Remote Automation CLSID_StubMarshaler.
Click Properties.
On the Identity tab, select the appropriate user account.