August 28, 2019 at 3:42 am
I created a user and it's Server roles is Serveradmin?Setupadmin?public?bulkadmin,and it has all persmision of MSDB (as shown in the picture), when loging in using the account to create a job, it shows error below, when a user can create a job which permissions is needed to release, thanks!
ERROR message as below:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Job '1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Job&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
August 28, 2019 at 11:58 am
Hi,
I think, there are missing permission in the msdb database:
Just take a look:
Kind regards,
Andreas
August 29, 2019 at 2:48 am
Thank you andreas.kreuzberg, I created a new user and set those permissions as you mentioned then it works fine.
before a created a user like this one and I set all the perssion expect for db_denydatareader and db_denydatawriter under MSDB database, but it can't work, I don't know it caused by which role. thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply