Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-03-05 : 08:28:48
|
| Hi,I have to create reports for a client. The database is on one server and the report management tool on another (http://localhost/reports).On the database server they can't give me administrator rights.Will i be able to create subscriptions (email subscriptions) and deploy reports if i don't have administrative rights?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-05 : 08:33:55
|
| You need to set the permissions on the reporting server for your user, this is on your localhost/reports. As long as you can read the data on the Database you shouldn't have any problems. |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-03-05 : 08:48:03
|
| That was a quick response :-) Thanks.So even if i won't have administrator priveleges i will still be able to upload files and create data sources in the reports manager?I will also be able to create subscriptions?What are the limitation of not having administrator priveleges?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-05 : 12:17:29
|
| As long as you have the correct rights on the reporting server database, you will be able to do all this, if your actual reporting database is on the same server as the other databases, then you may have issues if they won't give you rights, but you say it is seperate. All your reports are held in a database generally called ReportServer$<InstanceName> (or something similar), so as long as you have rights to this, you should be fine. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-03-06 : 13:26:48
|
| Hi,What are the correct rights that I need?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
|
|
|
Reporting services rights