ASP.NET Call SQL Server DTS
-
Dim sql As String sql = "exec master.dbo.xp_cmdshell 'dtsrun /Shitsql033 /NLinus_DTS_ASP_Test /UASPDTS /PASPDTS'" oic.executeSelectStatement(sql) oic.CloseConnection() Result: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. I have make the account "ASPDTS" to be System Administrator Can anyone help? Many thanks Linus
-
Dim sql As String sql = "exec master.dbo.xp_cmdshell 'dtsrun /Shitsql033 /NLinus_DTS_ASP_Test /UASPDTS /PASPDTS'" oic.executeSelectStatement(sql) oic.CloseConnection() Result: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. I have make the account "ASPDTS" to be System Administrator Can anyone help? Many thanks Linus