Archive

Archive for September 20, 2008

SQL Server and SQL Reporting Server SSRS – Quick Reference –FAQ’s

September 20, 2008 Leave a comment

SQL Server

  1. Add a Database user to a Database role:

        EXEC sp_addrolemember ‘db_owner’, ‘yourdbusername’

        More here

http://technet.microsoft.com/en-us/library/ms187750.aspx?PHPSESSID=rr1g5nuj29l79hrpjk7k0g1461

  1. When you rename the SQL Server name:

In case if you have renamed the SQL Server recently and find a trouble to connect to the server using code. Try the below items.

  • Use Query Analyzer and Connect to the SQL Server.
  • Execute the command SELECT @@SERVERNAME AS ‘Server Name’
  • You will find the old name reflecting there.
  • First run the command sp_dropserver ‘old server name’
  • And then run sp_addserver ‘new server name’, ‘local’
  • You should be good to go

    SSRS Reporting Servers:

  1. To change the User Name or the Server name of the Reporting Server instance [SSRS].
  2. When you get rsreportserverdatabaseunavailable error when connecting to SQL Server Reporting server.

For the above case you have to use the tool rsconfig that will change the user and server details.

http://msdn.microsoft.com/en-us/library/ms162837.aspx

STSADM Tool Reference

September 20, 2008 Leave a comment

Adding Server Side code to the Publishing Page Layouts – PageParserPaths

September 20, 2008 Leave a comment

    This article is to give a brief introduction for the Functionality of PageParserPaths tag in the Web.Config file of SharePoint. (It serves as a Reference for me In future and for someone out there who is  search  for a similar implementation).

    All the Layout pages in the SharePoint 2007 are derived from the class Microsoft.SharePoint.Publishing.PublishingLayoutPage .

This works very well for most of the cases and customization. But there will be very chance that for some reason you want the actual page instance to have a completely different class. Might be a case where you are using a third part tool or a component. In this case if you try to change the base class or put in some custom server side code in to the page layout file, SharePoint will complain you with a parser error.

        This Article describes the approach that will help you to put in the code for the layout pages. It works like charm.

        On additions to the above article is that in case if you are concerned about allowing all the pages having the server code as defined by below tag

<PageParserPath VirtualPath=”/_layouts/masterpage/*” CompilationMode=”Auto” AllowServerSideScript=”true”

IncludeSubFolders=”true”/>

You can make a particular page to have server side code as below

<PageParserPath VirtualPath=”/_layouts/masterpage/yourpage.aspx” CompilationMode=”Auto” AllowServerSideScript=”true”

IncludeSubFolders=”true”/>

While configuring a single page, make sure that you remove the attribute IncludeSubFolders=”true”. If you leave this tag as it is, all you are going to get is a plain HTTP 500 error code which is hard to debug. Validation that SharePoint makes here is IncludeSubFolders=”true” can be present only if the attribute VirtualPath ends with /*.

SharePoint Permission Dependency Chart

September 20, 2008 Leave a comment

This Image speaks for Itself.. If you want more Visit this link.

SharePoint Tools

September 20, 2008 Leave a comment

Below is the List of the SharePoint tools that will boost your productivity. I love them and use them. You too will…

Writing CAML Queries directly in C#.

CAML.NET     http://codeplex.com/camldotnet

Custom STSADM command and Command to Get the Content Type Xml Schema

CUSTOM STSADM http://www.andrewconnell.com/blog/articles/MossStsadmWcmCommands.aspx

SQL like CAML Queries  – My Favorite one

CAML Queries in SQL Syntax http://www.ideseg.com/SharePointYetAnotherCAMLQueryTool2.aspx

SPDisposeCheck 

SPDisposeCheck is a tool to help SharePoint Developers follow memory management best practices when using the SharePoint API with IDisposable objects including SPSite and SPWeb.  More Information about the tool here .

http://code.msdn.microsoft.com/SPDisposeCheck