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 |
|
BigMeat
Yak Posting Veteran
56 Posts |
 Posted - 2005-05-20 : 09:42:13
|
| HiI have a asp.net application that uses SQL RS via web services. My application works fine in my Workgroup environment, I have created a NT user on the Report Server and pass the user name and password via the web service using the following code:Dim reportCredentials As System.Net.NetworkCredentialreportCredentials = New System.Net.NetworkCredential(reportUser, reportPassword)I have then put this into a live production environment which is on a Domain and changed the above line to the below (just includes domain):reportCredentials = New System.Net.NetworkCredential(reportUser, reportPassword, domain)I have created and installed everything as I did before but I get an error that the account does not have sufficient privallegaes. The exact error is:The permissions granted to user 'DOMAIN\reportUser' are insufficient for performing this operation. --> The permissions granted to user 'DOMAIN\reportUser' are insufficient for performing this operation. The user account has been setup in teh exact way, it only has 'User' permissions. However if I make this account a memeber of the Administrators group everything works fine?I also tried just adding a 'local user' to the Report Server in the live enironment (not on domain) and I still get the same problem?Any idea what permissions the User account needs?Thanks in advance |
|
|
|
|
|
Account pemissions for SQLRS