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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2010-08-04 : 11:25:04
|
| the select permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'---------------------------I am creating a job failed report. This report let me know when a job fails, the job is schedule to run nightly. When I use the ConectionStrigDEV that uses userid & password - the conection fail and I received the above ERROR MESSAGE. However, this is the conection that I need to be using. When I use the local conection with not user id nor password, everything works fine. <connectionStrings> <add name="ConnectionStringDEV" connectionString="Data Source=xxxxxxx\TEAM; Initial Catalog=xxxxx; Persist Security Info=True;User ID=xxxxx ;Password=xxxxxxx" <add name="ConnectionString" connectionString="Data Source=xxxxxx\TEAM;Initial Catalog=xxxxx; Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-08-04 : 11:39:18
|
| Thank you Tara Kizer....This are SQL system tables. I have no clue where to find this table inside SQL. Thank you. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-08-04 : 12:26:11
|
| Thank you Tara ---I found the tables. Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
ERROR MESSAGE ----have you seen this error before