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 |
|
soumendra
Starting Member
1 Post |
 Posted - 2009-03-12 : 03:50:48
|
| Dear All,We are using a sql server 2005. in the single server box we are already configured a database which is using for an application. Now we wants to configure another application on the same server and for that we have created a domain user through which the database will be created but we are facing a problem to access the report service. For the new application the application team need the access on two databases ReportServer and Reportservertempdb. How to give access on those two databases also keep it in mind this new application cannot touch anything of another application. Please suggest it's my immediate requirement.Update: getting one error message: Details ID: rsAccessDenied Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. -------------------------------------------------------------------------------- Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-12 : 09:01:32
|
| just add new created login to db_owner role of needed databases.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
|
|
|
Report server access