In our case, Sharepoint 2007 with SQL Server 2008 R2. The results are pretty consistent. Turn it on and wait, eventually every web on the site will start locking up and web requests will time out.
I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.