Login

When i connect to SQL Server 2005 i do not see the maintence plan under management for me to be able to create maintenance plans and jobs. What am I suppose to do with my login to be able to have these access?

Thanks
mamlaideAsked:
Who is Participating?
 
bitrefCommented:
- Open SQL Server Management Studio
- Login using sa or through windows authentication
- Go to Security --> Logins
- Right click the login you want to use
- Select Server Roles
- Check sysadmin and close
0
 
lcohanDatabase AnalystCommented:
You need to be sysadmin on that SQL server in order to do that - please run command below to see the permissions for sysadmin server role:

sp_srvrolepermission @srvrolename =  'Sysadmin'
0
 
Anthony PerkinsCommented:
>>When i connect to SQL Server 2005 i do not see the maintence plan under management <<
It is not available in SSMS Express Edition.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.