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 |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2010-10-05 : 10:38:07
|
| Hi All,On a client new database server we have 'Windows Server 2008 R2 - Standard' as a operating system and have 'MS SQL Server 2008'. For the first time on this server I am trying to deploy some reports that we have built for the client. When I try to depoly these reports from visual studio 2008 it says "The permissions granted to user 'Domain\user' are insufficient for performing this operation."I saw on some forums that someone suggested to change the 'Home' security permissions but when I connect to 'SQL Server Managment Studio while selecting server type as 'Reporting Services' and using 'windows authentication' I do not see 'Home' under object explorer within the server name in 'SQL Managment Studio'. See the following screenshot:[url]http://www.flickr.com/photos/7714646@N07/5054506604/sizes/l/in/photostream/[/url]Under 'Reporting Services' in 'SQL Managment Studio' when I try to double click 'System Administrator' I got the error "The permissions granted to user 'Domain\user' are insufficient for performing this operation". Please see the screenshot below.[url]http://www.flickr.com/photos/7714646@N07/5053886909/sizes/l/in/photostream/[/url]Using same windows id/pwd I can deploy report to other servers of the same client but not at this server with same windows credentails. I can request my client to make changes on the server so that I am able to deploy the reports. But they do not know much and would like to know the exact steps they need to follow to make changes so that I can deploy the reports. Can someone help please?Thanks,Zee |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2010-10-05 : 17:06:19
|
| Never mind. When I open visual studio as a administrator I can deploy the reports. |
 |
|
|
|
|
|
Cannot deploy reports in MS SQL Server 2008