Show username instead of “System Account” in SharePoint

Many times when you login to a SharePoint site you will see at the right hand side top corner “Welcome System Account” instead of your username. Sometimes we need to really get rid of this system account and display proper username.
Here are the two ways which could help you accomplish this task:
Solution one :
· Go to Central Administration / Application Management.
· Click Policy for Web Application.
· Select your web app and click your account in the list.
· In the Edit Users page, clear the Account operates as System checkbox.
· That should fix this particular problem.
Solution two:
· Go to Central Administration / Operations.
· Select Service Accounts
. Select your web application
· Change the application pool identity for your Web application

Prevent users from changing a Windows SharePoint Services 3.0 site or a SharePoint Server 2007 site using SharePoint Designer

Prevent users from changing a Windows SharePoint Services 3.0 site or a SharePoint Server 2007 site using SharePoint Designer

The following article shows you how you can prevent users from changing a Windows SharePoint Services 3.0 site or a SharePoint Server 2007 site using SharePoint Designer.

http://support.microsoft.com/kb/940958
http://blogs.msdn.com/sharepointdesigner/archive/2008/11/25/locking-down-sharepoint-designer.aspx

Shrink SharePoint configuration database log file

USE DatabaseName
GO                
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 10)

Where 10 is the size to which the log file will be shrrinked..in this case it is 10 MB

You can also do it from the SQL Management Studio

Right Click on Database –> Tasks –>Shrink –>Files—>Select “Log” option from the dropdown and then select the shrink size

SharePoint and Reporting Services: User cannot be found

While configuring SQl Reporting Services-SharePoint Integration you may encounter an issue “User cannot” be found. As the error suggests the issue here is that the user (author) of a SharePoint web site cannot be found. When Reporting Services tries to render a page, it seems to read the Author field of every web site of all site collections in all web applications. If the author cannot be resolved in just one web site(the user had been deleted), this fails. The following blog has more details with code sample as to how to restore the author of a SharePoint site collection and make the report services run in integration mode with SharePoint. http://larslynch.blogspot.com/2009/11/sharepoint-and-reporting-services-user.html