In SQL Server 2000's Books Online there is a section entitled "Security Account Delegation." It tells you all you need to know.

You can find it at Administering SQL Server >>...

Weapon speeds were just... broken. Broken especially if you were playing with cumulative init. Speed is only one of the factors that need to be considered. For instance, the wielder...

Is .NET Framework 2.0 still installed? If so, you'll need to uninstall it, too. Uninstalling SQL Server 2005 beta I don't believe uninstalls that, too.

I second the "got the T-shirt" perspective and this is generated mainly from my own observations from the military and IT. Having worked in the trenches gives you a better...

In SQL Server 2000 you can also grant the CREATE <object> rights manually. This will create the objects belonging to the user. The user will have complete rights over his...

You'll want to post this as a different topic. However, did you have any tracing on (Profiler traces)? Do you have any log reading software (Log Explorer, Apex SQL Log)?

You're running into a double-hop issue. You're doing Windows authentication to connect to the first SQL Server. You're also got the linked server connection to do the same to the...

Use a high number port, above 1024. Stay away from the common ports, like the list you've included. When we assign ports for apps, we break out dice. Yup, Dungeons...

Hi Betty,

If you have an MSDN subscription and access to the download of SQL Server 2000 Developer Edition, that should be all you need. You'll likely need the first as...

SQLRecon is here:

Special Ops Security: SQLRecon

It's from Chip Andrews, the same guy who runs SQLSecurity.com and coded the SQLPing application. Much preferable...

Windows XP cannot run SQL Server 2000 Standard or SQL Server 2000 Enterprise. However, it can run SQL Server 2000 Developer edition, which is SQL Server 2000 Enterprise running under...

A Windows user must have a login in order to connect to the SQL Server. Whether this is through the login itself or through a Windows group does not matter.

In...

Check out the most recent posting on my blog. I was just pulling drive letters in my code for each database, but it's similar to what you're trying to do...

It is in Active Directory, but with delegation turned on. Check with your system/domain administrators about this.

How do you know it's coming back from [A]? Are you seeing any activity occuring on ?