Are you running the perl script via the sp_cmdshell sp.

If you do, does the sqlagent allow this (ie the checkbox in properties), also are you running this job as...

Does the sql agent log file give any more details? (Right click on the sql agent and choose 'display error log')

You can use sql profiler to capture all the t-sql commands sent to a sql server. Hence if you run that, you can find out what your web app is...

you will need to check the database to see if the 'guest permissions' are enough for your application.

Your sql server may be setup for NT auth only rather than mixed...

Are you SQL Server and IIS site on the same server?

The IUSR account is the anom access account for IIS. Hence it is trying to use NT auth to access...

You can use the OLE stored procedures to run a dts. See the following link

http://www.swynk.com/friends/green/dtsole.asp

Do any of your apps use the sa account?

If not, and you have an nt account with admin rights (or a local admin account if you leave the builtin/admin with...

A while ago NGS SOFTWARE also published two very good papers on sql injection (time to ensure that all web pages which link to a database are injection proof!)

http://www.nextgenss.com/papers/advanced_sql_injection.pdf

http://www.nextgenss.com/papers/more_advanced_sql_injection.pdf

Just a single vb.net dll on the server to start with.

But once you have allowed it once, more follow...

Can't find anything on MSDN

I was wondering what impact the garbage collector etc. would have on the server CPUs/memory etc.

I plan to take a detailed look at both sets of log files sometime soon. If there are points worth mentioning I'll post them.

Sorted. For those who are interested.

Well I started the sql server (after the forementioned process had been running for 8 hours)

detached the user databases

stopped sqlserver

killed the upgrade process

rebooted the server

the...

Set the collate option against the article and all seems fine now.

Each database has its own database owner.

If you want to change it read up on the stored procedure sp_changedbowner in books on line which will change the database owner and...

Have you gone back to basics and tested your profile using outlook on the server?