Home Forums SQL Server 2005 Administering The server principal "domain\sqlman" is not able to access the database "test_DBA" under the current security context RE: The server principal "domain\sqlman" is not able to access the database "test_DBA" under the current security context

  • If you have SQL Server 2008 (100) Web Edition then in sp_add_jobstep do not supply @database_user_name or in the GUI supply a run as user as this will result in a spurious error indicating the user does not have permission!

    You just have to run with SQL Agents permission set.