Loading...

Reply To: Unable to pull stored procedures to siqListForm

Reply To: Unable to pull stored procedures to siqListForm

Home Forums QuickApps Forum Unable to pull stored procedures to siqListForm Reply To: Unable to pull stored procedures to siqListForm

#5516
Anonymous
Anonymous
Participant

Hi

It looks like you have permissions to connect to SQL server database but you don’t have permissions to list the stored procedures.

Open SQL Server Management Studio, use the same method to login as you specify in the Configuration Editor tool for your Service (Integrated Security or providing an user and a password) and try to see whether you can expand the Stored Procedure node and see the content
or you can run this query and see if you get some results back.

select name from sysobjects where xtype=’P’ and category <> 2 order by name

If you don’t see anything in the Stored Procedure folder or coming back after executing teh above query then the SI web parts won’t be able to display anything.

Fix the account permissions and try again.
See this link:
http://www.sql-server-performance.com/forum/threads/granting-permissions-to-view-stored-procedures.22979/

  • This reply was modified 6 years, 9 months ago by AgreeYa Super Admin.
  • This reply was modified 6 years, 9 months ago by AgreeYa Super Admin.