Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their own Windows domain credentials and integrated security...
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server...
During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend to read through BOL if you need a basic information...
Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services report http://support...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
05-08-2008
Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode
Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse platform you can set, with the features and functionality...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-13-2008
Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office
So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped by measure group. Simplified and enhanced Aggregation...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-25-2008
Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services
Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also...
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services...
Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from a back up copy Getting Results of a Query into...
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-07-2008
Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports