Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-05-13 : 11:53:29
|
| Hi, I got a error when I test operater's email and the SQL mail profile is set no problemError 2202: SQL ServerAgent Error: you do not have sufficient permission to perform this operation on this object.It was working before, anyone knows how to solve this problem??Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-13 : 12:40:05
|
| Yeah, fix the permissions....Really need a little more explination..Brett8-) |
 |
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-05-13 : 13:27:02
|
| I logged in as sa( the owner of databases) should have permissions and it worked before. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-13 : 13:31:32
|
| But the agent is assigned a domain account usually. I'm thinking that's what needs the permissions...most likely to a share...you need to fill in a little on what you're doing though...Brett8-) |
|
|
|
|
|
|
SQL server Agent Error