SQL Debugging - Microsoft SQL Server

Jonathan Ryan

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.

Jul 20 '05 #1

Subscribe Reply

2007

Erland Sommarskog

Jonathan Ryan (jo***********@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, so****@algonet.se

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

Jul 20 '05 #2

Similar topics

3205

Erratic Sever Side Script Debugging ASP 3.0/.NET DLLs: Problems and Solution

by: ZMan | last post by:

Scenario: This is about debugging server side scripts that make calls to middle-tier business DLLs. The server side scripts are legacy ASP 3.0 pages, and the DLLs are managed DLLs...

ASP.NET

4176

Unable to start debugging

by: Serdar Kalaycý | last post by:

Hi everybody, My problem seems a bit clichè but I could not work around. Well I read lots of MSDN papers and discussions, but my problem is a bit different from them. When I tried to run the...

ASP.NET

1842

debugging server but not IE

by: Andy Fish | last post by:

Hi, Using VS.NET 2003, when I use 'F5' to start debugging my web app, it obviously attaches the IDE to IIS for server debugging. However, it also seems to put IE into some kind of debugging mode...

ASP.NET

3258

SQL Debugging Not working as it should

by: Alex Clark | last post by:

Hi All, My system: WinXP Pro, VS.NET 2003, SQL Server Personal Edition. I'm having problems with my old favourite demon, SQL Debugging from within VS.NET. I have to say I've found this...

Visual Basic .NET

2926

Classic ASP Debugging with VS.NET installed

by: Velvet | last post by:

Can someone tell me to what process I need to attach to be able to step through my classic ASP code in VS.net 2003. I'm working on an XP box with IIS installed. I also have VS.net 2005 (The...

ASP.NET

2492

QUERY: debugging ASP VBScript

by: KevinGPO | last post by:

I am currently developing a website in ASP (VBScript) using MS Visual C#.NET IDE. I just create a new "ASP.NET Web Application" and point to my local webserver (IIS) of my website address. Then I...

ASP.NET

7777

Debugging .net libraries in both the GAC and local folder

by: phnimx | last post by:

Hi , We have developed a number of plug-in .NET Library Components that we typically deploy with our various applications by installing them into the GAC. Each of the applications contains an...

.NET Framework

3438

asp.net debugging on local IIS

by: =?Utf-8?B?Z2FkeWE=?= | last post by:

I can't get to debug on my local IIS using VStudio.net 2005 Prof. I can on the development server. I get the msg 'the server does not support debugging for asp.net...' I have done the following...

ASP.NET

20815

Zen and the Art of Debugging C/C++ in Linux with GDB

by: jwwicks | last post by:

C/C++ Programs and Debugging in Linux This tutorial will give you a basic idea how to debug a program in Linux using GDB. As you are aware Visual Studio doesn’t run on Linux so you have to use...

C / C++

12674

Better debugging of classic ASP with Visual Studio 2008 SP1

by: =?Utf-8?B?TWlrZSBHYWxl?= | last post by:

VS 2008 initially didn't debug classic ASP. SP1 fixes this in some ways. You can debug if you select the debug option to "Start Without Debugging, then either attach the debugger manually or...

ASP / Active Server Pages

7160

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7537

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7099

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5685

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5086

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3233

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3222

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1594

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

799

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP