Solved

Login

Posted on 2011-03-23
3
328 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:mamlaide
3 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 35201564
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
 
LVL 5

Accepted Solution

by:
bitref earned 500 total points
ID: 35203060
- 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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35203712
>>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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question