Category Archives: SQL Server

Manually Deploy SSRS RDL reports to Report Server using SSRS Report Manager Site URL

Recently I had to deploy some of my SSRS reports in a remote VM, where no Visual studio was present, so I followed the manual process steps followed are as below Step 1 : find the report manager URL by … Continue reading

Posted in SQL 2008, SQL Express, SQL Reporting, SQL Server, SSRS, Windows Server 2012 | Tagged , | Leave a comment

Error while accessing Localhost SQL Reporting Services Url – user ‘DomainUserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

In my machine I have 3 SQL server instances installed. 1> SQL Server 2012 2> SQL Server 2012 Express 3> SQL Server 2008 Express   so the corresponding default local host report server names are as below 1>http://localhost/reportserver¬†¬† for my … Continue reading

Posted in SQL 2012, SQL Express, SQL Reporting, SSRS, Windows 8 | Tagged , , , , | Leave a comment

How to Generate Comma Separated Double Quote Qualified Unicode CSV from SQL Server

Recently for Data migration task using SQL server SSIS packages I needed a way to create Unicode encoded Comma separated Quote delimited CSV file directly from SQL server which can consume data from SQL stored procedure or complex SQL statement … Continue reading

Posted in Data Migration, SQL 2008, SQL 2012, SQL Server | Tagged , , , | Leave a comment

Attaching MDF file to Database give Read only or Access Denied Error

Recently I upgraded my laptop from Windows 7 to Windows 8, and I had my SQL server installed in D drive, s I didn’t not bother to take backup of my DB files, thinking the .mdf files are there in … Continue reading

Posted in SQL Server | Tagged , , , , , | Leave a comment