SQL Debugging

#1

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.

#2

Jonathan Ryan (jonathan.ryan (AT) programmer (DOT) net) writes:

Quote:

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 (AT) algonet (DOT) se

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Debugging

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

SQL Debugging - 08-06-2003 , 02:27 PM

Re: SQL Debugging - 08-06-2003 , 04:30 PM