The permissions granted to user 'UserName\UserName' are insufficient for performing this operation in SSRS.

The permissions granted to user 'UserName\UserName' are insufficient for performing this operation in SSRS.

Answer: 

Step1: Go to SQL server data Tools.

Step2: Right Click on SQL server data Tools. 

Step3: Run as Administrator.

ASP.NET C# project on Windows Server 2012 with IIS

When I hosted an ASP.NET C# project on Windows Server 2012 with IIS, the below error appeared.

Let's learn how to overcome this error. 

Solution
I found the solution for this issue and I would like share with others.

Step 1While installing SQL, we have to select "Mix Mode Authentication".

Step 2Include the username, for example - sa and password: abc@123

Step 3Then, create a table using SQL Server Authentication.

Step 4Place the connection in web.config file.

1. <connectionStrings><add name="ABC" connectionString="Data Source=ServerName; Initial Catalog=DataBaseName; User ID=sa; Password=****** " /></connectionStrings>