Solved

Login

Posted on 2011-03-23
3
329 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tempdb log keep growing 7 33
Is this spec enough for a developer or is it just blabble ? 1 37
SQL Quer 4 22
Current Month Filter in Visual Studio 10 23
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

828 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