My colleagues and I have not been able to successfully set up SQL debugging on a SQL 2000 instance running on Windows 2000.
Is there a checklist posted somewhere? We have verified that the SQL Server is not running with System Account Credentials. It runs as a Domain Administrator. We have also verified that everyone has permission to run sp_sdidebug. Does it matter that the Win2K machine is a Domain Controller? Any help would be appreciated.

Jonathan Ryan (jonathan.ryan@programmer.net) writes:
> My colleagues and I have not been able to successfully set up SQL
> debugging on a SQL 2000 instance running on Windows 2000. Is there a
> checklist posted somewhere? We have verified that the SQL Server is not
> running with System Account Credentials. It runs as a Domain
> Administrator. We have also verified that everyone has permission to
> run sp_sdidebug. Does it matter that the Win2K machine is a Domain
> Controller?

There were also changes in SP3, and if your client is running SP2 and your
server is running SP3, you may have problem. (But I have SP2 on my work
machine while our dev server has SP3.)

For a checklist, check the Troubleshooting section in Books Online. See
below for a link to an updated version.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp