Advertisements

Archive

Archive for May 21, 2012

User Account Control (UAC) and SSRS

May 21, 2012 3 comments

In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working. Read more…

Advertisements

Table Attributes Dependencies in Store Procedures with SQL Server 2012

May 21, 2012 2 comments

Couple of days back I got an opportunity to migrate the existing Sybase ASE database (Adaptive Server Enterprise/15.0.2) to my favorite MS SQL Server 2012, to find out the feasibility of migration activity in near future.

Our team consists of Project Manager, Database architect and few of the senior guys we all concluded to just migrate the database objects from Sybase to SQL Server 2012, and along with the migration we need to find out dead objects in the existing database which is being carried so far. Here the dead objects means such tables, columns and views which are no more in use. Read more…

BIDS No More Exist in SQL Server 2012.

Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools.

Comparison of SQL Server 2012 Vs SQL Server 2008 R2. Read more…

Convert Number Value Into Words using SSRS

May 21, 2012 1 comment

For Display Amount Value into Words with SQL Reporting Services 2008, we can implement the same with following two ways.

· Database Function

· Custom Assembly Read more…

%d bloggers like this: