PRB: SQL Server Debugging with Visual Studio Service Pack 5 Requires a Non-System Account

Article translations Article translations
Article ID: 281649 - View products that this article applies to.
This article was previously published under Q281649
Expand all | Collapse all

SYMPTOMS

With Visual Studio 6.0 Service Pack 5 or later, SQL Server debugging cannot be performed when the SQL Server service is set to run under the Local System account. This is true regardless of whether SQL Server is local to the computer where Visual Studio is installed or is located on a remote computer.

The following error message appears in the application event log from the source MSDEVSDI:
SQL Server when started as service must not log on as System Account. Reset to logon as user account using Control Panel.

RESOLUTION

Configure the SQL Server service to run under a valid user account instead of the Local System account.

MORE INFORMATION

Prior to Visual Studio 6.0 Service Pack 5, SQL Server debugging could be performed successfully on a Microsoft Windows NT 4.0 computer with a local SQL Server, even though SQL Server itself was set to run under the Local System account. In Visual Studio 6.0 Service Pack 5 and later, this has been changed so that the behavior is consistent across all platforms. SQL Server must be running under a non-system account for debugging to be successful.

With Microsoft Windows 2000, SQL Server debugging has never been possible when the server is running under the Local System account, even if the server was on the same computer as Visual Studio.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
156096 INF: Tips for Debugging Stored Procedures from VC++
179235 DOC: SQL Debugging with VC++ 5.0 Requires a Non-System Account

Properties

Article ID: 281649 - Last Review: May 12, 2003 - Revision: 2.2
APPLIES TO
  • Microsoft Visual Studio 6.0 Service Pack 5
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbfile kbprb kbtsql KB281649

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com