Home Forums SQL Server 2008 Security (SS2K8) sql agent not shown in ssms after running ssis package as a job RE: sql agent not shown in ssms after running ssis package as a job

  • Do you have any other account with full access to SQL Server (sa, for example)? Log in as that and recreate your account. Now log in with your recreated account, check all your permissions are there, then run SELECT name FROM sys.server_principals, noting the results. Execute your package again and repeat the SELECT query above. Are the results the same?

    John