SQL Server 2005 MSDB Access

[cappjr]

On my SQL Server, I have a stored proc called 'sp_exec_job' that
simply starts a job:

EXEC [msdb].[dbo].sp_start.job @JOB_NAME

When I run this from Management Studio, it works fine. Yea.

But, when I try to execute sp_exec_job from my .NET (C#) code (on the
same server as the SQL DB), I get the following error:

System.Data.Sql Client.SqlExcep tion: Could not find server 'msdb' in
sysservers. Execute sp_addlinkedser ver to add the server to
sysservers.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject
stateObj)

Any ideas?

[cappjr]

Sorry, the above message is not correct (I pasted the wrong message).
This is the error I am getting...

System.Data.Sql Client.SqlExcep tion: EXECUTE permission denied on
object 'sp_start_job', database 'msdb', schema 'dbo'.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject
stateObj)

[cappjr]

On Apr 15, 10:20*am, [e-mail] m wrote:

Sorry, the above message is not correct (I pasted the wrong message).
This is the error I am getting...

System.Data.Sql Client.SqlExcep tion: EXECUTE permission denied on
object 'sp_start_job', database 'msdb', schema 'dbo'.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje *ct
stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject
stateObj)

Never mind, i just gave my SQL user owner permissions on the msdb
database. Duh. Sorry to waste anyone's time.

[Norman Yuan]

Also, do not name your own stored procedure like "sp_xxxxxxx ", which is used
for system stored procedures.

<ca****@gmail.c omwrote in message
news:ae******** *************** ***********@f36 g2000hsa.google groups.com...
On Apr 15, 10:20 am, [e-mail] m wrote:

Sorry, the above message is not correct (I pasted the wrong message).
This is the error I am getting...

System.Data.Sql Client.SqlExcep tion: EXECUTE permission denied on
object 'sp_start_job', database 'msdb', schema 'dbo'.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje *ct
stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject
stateObj)

Never mind, i just gave my SQL user owner permissions on the msdb
database. Duh. Sorry to waste anyone's time.