SQL


[SharePoint 2010 / SQL Server 2008] Query the SharePoint Object Model from a .NET SQL Server CLR Function

There are times when there is some SharePoint list data that needs to be accessed from a SQL Server query. However, it is unsupported by Microsoft to query the SharePoint Content Database directly and doing so can cause performance or other issues. The question then becomes: How do you query SharePoint data from SQL without […]

[SharePoint 2010] Getting “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’” When Trying to Connect to SQL from Your Custom SharePoint 2010 Web Parts?

When writing web parts and such for SharePoint 2010 it is common to have the need to access external SQL databases. Since SharePoint 2010 runs with ASP.NET Impersonation enabled (required for many of the web services and social features to work), it will not use the Application Pool user account when logging into SQL. This […]

[SharePoint 2010] SQL Reporting Services Report Builder Cannot Connect in SharePoint Integrated Mode

One thing that I discovered the hard way about SQL Reporting Services running in SharePoint integrated mode is that it DOES NOT SUPPORT HAVING ANONYMOUS ACCESS ENABLED IN SHAREPOINT. After setting up and configuring SharePoint 2010 and SSRS, everything was peachy until I enabled anonymous access on the SharePoint web application. When doing so, SSRS […]

[Windows Server 2008] SQL Linked Server Queries Running Slow

A colleague of mine discovered that many of our linked-server SQL queries were running very slowly on SQL Servers running Windows Server 2008 and Windows Server 2008 R2. Since the linked-server SQL queries ran perfectly on Windows Server 2003 servers, the issue had to be Windows Server 2008+ specific. The culprit ended up being the […]

[SQL Reporting Services 2008 R2] Hide Header, Toolbar, or Parameters When Viewing in SharePoint Integrated Mode

I have a number of instances where SSRS reports are displayed through Page Viewer Web Parts in SharePoint. When doing so, I like to only display the report, not the header, toolbar, or parameters section. You can hide them by appending these query strings to the URL: For example: That’s it. Source John ChapmanHello, I’m […]

[SQL Reporting Services 2008 R2] Enable Remote Errors

When encountering errors with reports on Microsoft SQL Server Reporting Services (SSRS) 2008 and 2008 R2 the generic error message isn’t very meaningful: Thanks to this blog post we have a couple of ways to turn on SSRS Remote Errors. Method 1 – Enable Remote Errors Via SQL Query Connect to the ReportServer database in […]

[SharePoint 2010/2007] Get the User Who Created a List or Library

A user on one of the forums had a need to find out who the creator of a SharePoint List (or Document Library) was. The SharePoint GUI gives no way to identify this from the list settings or anywhere else for that matter. With that said, it is possible to retrieve this out of the […]