Posts

Showing posts with the label SQL Server 2008

SharePoint Integration Mode SSRS : Permissions granted to user are insufficient for performing this operation

Image
Hi There, Its December 30 2015 12:30 PM and my team has to show demo to client at 02:00 PM. Received a call from my team that editing a data source from a SharePoint list is throwing an error. Wow, that's critical and i would love to fix this. I quickly googled and tried every solution i found on first page but didn't work. "Google says, the best place to hide a dead body is on google's second search page." So i navigated to move ahead with search on second page and found  this  awesome post that fixed my issue. I took the below steps which didn't helped me. 1. My permissions was OK on reporting DB,s 2. The account i am using for editing the data source was the system account 3. Restarted the SQL Server Reporting Services in SharePoint CA BTW, i am running SharePoint 2013 in a three tier farm architecture with SSRS SharePoint Integration Mode. Below are the error details... The permissions granted to user ‘ domain\username ’ are...

How to copy data from one table to another in SQL Server 2008

How to copy data from one table to another in SQL Server 2008 insert into MultiMedia.dbo.MovieSongs(Col1,Col2,Col3) select Col1,Col2,Col3 colums from MultiMedia_Temp.dbo.MovieSongs

How to get data in temp table and then copy it to another table in SQL Server

How to copy data from temp table in SQL server 2008? with MovieSlice as           (                 select  moviestock .moviesuffix,count( moviesongs.id_song) as songsCount from  moviestock inner join moviesongs on  moviestock .moviesuffix = moviesongs.moviesuffix group by  moviestock .moviesuffix     )     UPDATE      MovieStock SET      MovieStock .songsCount = MovieSlice.songsCount FROM      MovieStock INNER JOIN     MovieSlice ON     MovieSlice.moviesuffix =  MovieStock .moviesuffix