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 8 years, 1 month ago by .
- This reply was modified 8 years, 1 month ago by .