SQL 2005 Reporting Services
-
Hi,
I got an error when I tried to create a Report Model using Report Model Wizard
" Select permission denied on object 'sysindexkeys', database 'mssqlsystemresource', schema sys.
Command:
Select u.name as schemaname, o.name as TableName, x.Name as IndexName, c.Name as ColumnnName from sysobjects o
inner join sysusers u on u.id = o.uid
inner join sysindexes x on x.id = o.id
inner join sysindexkeys k on k.id = o.id and k.indid = x.indid
inner joi syscolumns c on c.id = o.id and c.colid = k.colid
order by schemaName, TableName, Indexname.
Any idea? Really appreciate it. Thanks.
-
you mixed up on
inner join sysusers u on u.id = o.uid
supposed to be
inner join sysusers u on u.uid = o.id
-------
Select u.name as schemaname, o.name as TableName, x.Name as IndexName, c.Name as ColumnnName
from sysobjects o
inner join sysusers u on u.uid = o.id
inner join sysindexes x on x.id = o.id
inner join sysindexkeys k on k.id = o.id and k.indid = x.indid
inner join syscolumns c on c.id = o.id and c.colid = k.colid
-
Thanks. I might type it wrong but that error message actually generated by the system. I have changed my connection to the SQL from SQL authentication to Windows Authentication and it worked fine. I then deployed the report model to the Report server but when I clicked the Report Builder to test the model I got message stated that "The Report Builder could not start". Any suggestion? Again thank you very much for your time and effort.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply