Ok. The security was tightened in the June CTP build of SQL Server. Read my blog at: http://blogs.sqlxml.org/srinivassampath/archive/2005/06/19/3457.aspx on how to get over this issue.