Microsoft BI-Azure and Project Server Blogs

Understanding Kerberos and NTLM authentication in SQL Server Connections http://www.blogger.com/img/blank.gif

There are always several questions we face at customer sites on the licensing requirements for their Project Server implementation. It’s best to consult your local Microsoft Solution Sales Specialist (SSP) for the details to ensure compliance. A common scenario we see customers are faced with is loading Project Server with ALL resources in the organization, whether work assignments exist or not, and have them available to perform work as it is assigned. An organization may likely consist of 10,000 people and only 1,200 active on projects at a time and would prefer to only have 1,200 Client Access License (CAL)s for the entire organization. This scenario is not allowed, however, Microsoft allows the CAL to be transferred (as a one off) after a 90 day period to a new user. The simple SQL script below provides a view of all the resources in the named instance you set through the @PUBLISHED_DB_NAME variable to have the discussion with the SSP. Key columns to review from the SQL output that...

http://blog.lanactech.com/?p=246 http://blog.lanactech.com/?p=246

To launch date and time properties window from command prompt just run the command timedate.cpl c:>timedate.cpl

http://www.microsoft.com/showcase/en/us/details/73213feb-9a93-43b6-94c2-65f64127bbe7 http://microsoftepmsolution.blogspot.com/2009/05/how-to-improve-project-server-2007.html http://www.microsoft.com/showcase/en/us/details/73213feb-9a93-43b6-94c2-65f64127bbe7

runas /user:ihess\srv_Projsvr_db "C:\windows\system32\cmd.exe"

Great post Click one more another http://www.harbar.net/archive/2007/06/19/NO-Your-SharePoint-Farm-Account-does-NOT-need-local-admin.aspx

Click here for more detail

click Here

believe me I suffered alot,our client decided to implement a new menu item via WSP solution,which went into many versions ...and testing it was horrible eveytime I need to go retract ,delete,deactivate the feature and then activate it ...finally I decided that I'll try to find out sts command which really my time and saved me to get mad I'll start with adding a new template in WSS site for more technical details 1)CD\ 2)CD \Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN 3) stsadm -o addtemplate -filename " E:\PS-Admin-Work \stpfilename" -title "Test Workspace Title" 4)then IISRESET ============== WSP Solution======================= Activating feature at child site level Click Here Cd\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN Add solution stsadm -o addsolution -filename "E:\PS-Admin-Work\PWS Helper\icomp.SharePoint.PWSHelper.wsp" Deploy solution stsadm -...

http://technet.microsoft.com/en-us/magazine/ff395842.aspx

One more day when entire day I spent to find some information..[:(]...btw I was happy person at the end of day. I raised following question in MSDN ..see more to access it Click Here and Tool suggested in following url Codeplex tool TYO use it download this tool in local directory of MOSS server and then use it E:\WorkflowExplorer http:// all : displays all running workflows WorkflowExplorer http:// error : displays all faulting workflows WorkflowExplorer http:// raw : displays all workflows (including completed and their raw state, nice fro developers).

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

http://technet.microsoft.com/en-us/library/cc197677%28office.12%29.aspx License Issue after Sp2 Installation of PS 2007: http://blogs.msdn.com/b/brismith/archive/2009/05/20/project-server-2007-license-type-set-to-trial-after-loading-office-server-service-pack-2-sp2.aspx

ohh boy,it took me hell alot of time to get these keys but thanks to Bert Johnson for his script in Recover Your SharePoint 2007 Product ID . It was wonderful post and it worked like a charm. for more options click here

In Microsoft Office Project Server 2007, you may experience one or more of the following symptoms when you try to access a Web page from Microsoft Office Project Web Access: When you try to view the "Project Center" page, you receive an error message that resembles the following: Project Center cannot access the project(s) you are trying to view. It is most likely that you either don't have the permissions to view the project, another user has deleted this project(s) before you were able to view it or that another user is in the process of publishing the project When you try to view the "Resource Center" page, you receive an error message that resembles the following: There was an error loading the page. Please try again by clicking Refresh. If this problem persists, contact your administrator. When you select a user on the "Manage Users" page, you receive an error message that resembles the following: An error was encountered in loadin...

Windows Server 2008 Resource Center Deploy a simple farm on the Windows Server 2008 operating system Install PS 2007 with Windows server 2008 Running SharePoint Server and Project Server 2007 on Windows Server 2008 R2 Beta How to determine Installed MOSS version Deploy PS SP2 Comparison of Windows Server 2003 Editions

Windows Server 2008 is the next generation of the Windows Server operating system. Windows Server 2008 provides significant improvements over Windows Server 2003. Important improvements include the following: Networking Advanced security features Remote application access Centralized server role management Performance and reliability monitoring tools Failover clustering Deployment File system Because of these improvements to the base operating system, backward compatibility of all applications is not guaranteed. For more information about how to upgrade to Windows Server 2008, click the following article number to view the article in the Microsoft Knowledge Base: 948070 (http://support.microsoft.com/kb/948070/ ) Information and resources to use when you plan to upgrade Windows Server 2003 to Windows Server 2008 Back to the top Applications that are currently compatible For more information about the applications that are currently compatible with Windows Server 2008,...

http://www.mskbarticles.com/index.php?product=11373

If you are performing a greenfield or clean install of SharePoint, it is a good idea to install the latest version (which as of today would be Service Pack 2 with the April Cumulative Update). The latest install media for SharePoint, however, only has SP1 integrated, so today I will show you how to slipstream the latest updates into your install media. To get started, you will need a copy of the SharePoint 2007 install media, the SP2 installers for both Windows SharePoint Services and Office SharePoint Server, and the latest Cumulative Updates for both WSS and MOSS. You can download them all here: •SharePoint Server Install Media (Note… you will be able to use your own product key, so don’t worry about the fact that this is the “Trial Version”. You will want to download the OfficeServer.exe file and not OfficeServerwithSP1.exe file, or else you will have the additional step of deleting the SP1 files that were slipstreamed in). •Windows SharePoint Services 3.0 Service ...

SELECT SERVERPROPERTY('productversion') as productversion, SERVERPROPERTY ('productlevel') as productlevel, SERVERPROPERTY ('edition') as edition

http://www.youtube.com/watch?v=6gefUOgE1Yg&feature=related

More detail http://support.microsoft.com/kb/224609

Sometimes its crazy when you are system admin and you are not able to tell what version of S/W are installed in your server...today Some one asked the same for Project server..and I was having no clue to where should I check that... finally I got to know from some one that for project server check the program files ..if 'Microsoft Office Servers'folder exist inside Program Files then its 64 bit otherwise it will be inside Program Files(x86)i.e 32 bit version.

Project Server 2007 Suite contains Windows SharePoint Services 3.0, Microsoft Office Project Server 2007, MS Project Professional 2007 The most current service pack level for MS Project Server 2007 is SP2 The most current service pack level for MS Project Professional 2007 is SP2 When using fixed duration tasks, it is strongly recommended that you upgrade both the server and client computers to SP2. Determine Service Pack (SP) level of Project Server 2007 Application: The easiest method to see if Office Project Server 2007 is updated with Service Packs on a server is to view the version of Project Server through Add/Remove Programs. View Project Server version information in Add or Remove Programs: On the Windows 2003 Server on which you are checking the Office Project Server 2007 version, click Start, click Control Panel, and then click Add or Remove Programs On the Add or Remove Programs page, in the list of Currently installed programs, click Microsoft O...

What is SPSReport? It is a Microsoft Public License (Ms-PL) based utility available @ http://spsreport.codeplex.com/ to gather detailed information about SharePoint configuration in a system. You can further share that information to a Microsoft Support Professional for your SharePoint related support case(s). SPSReport can be used to gather data for SharePoint Support Cases that involve the following SharePoint environments: Windows SharePoint Services 2.0 / SharePoint Portal Server 2003 Windows SharePoint Services 3.0 & Office SharePoint Server 2007 [MOSS 2007] Here are some points for you about SPSReport: 1. By default, the tool is installed to this folder: %Systemroot%\SPSReports\Portal\ 2. This is the default directory structure for SPSReport: %SystemRoot%\SPSReports\Portal > Bin > Rpt > Cab 3. SPSReports\Portal\bin\Readme.txt contains details about the tool - After extracting the data by running SPSReport.exe, this file can be accessed without r...

Notes: ======== 1)When added a new location user needs to given permission there because by default it doesn't get permission to view 2)Bamboos :- Installation of bamboos http://store.bamboosolutions.com/KB/article.aspx?id=12464 3)Project workspace Filter web part http://www.msprojectexperts.com/software/workspaces2007.aspx 4)Bamboos List Roll up http://store.bamboosolutions.com/onlinedoc/default.aspx#AppID=2535 5)SSRS Page Set Up http://blogs.msdn.com/b/bwelcker/archive/2005/08/19/alien-lanes-_2800_logical-and-physical-pagination-rules_2900_.aspx 6)VM Ware http://searchservervirtualization.techtarget.com/tip/Physical-to-virtual-migration-best-practices 7) Moving Project server from one server to another Domain http://blogs.msdn.com/b/brismith/archive/2009/06/22/project-server-2007-migration-from-one-domain-to-another.aspx 8) SQL server Clustering Detailed http://www.sql-server-performance.com/2002/clustering-intro/3/ Url describing the database tables where a list get stored as w...

Highlights about Project Professional 2010 and Project Server 2010. that Microsoft worked under for Project 2010 was:  Unified Project and Portfolio Management  Enhanced Collaboration and Reporting  Simple and Intuitive User Experience  Scalable and Connected Platform Even though I tried to separate Professional from Server for this list, many features and capabilities are now available on Server that we would traditionally think are Professional only. Highlights of Project Professional 2010:  The Ribbon – currently used in Office 2007 and 2010 o Known as “Fluent” user interface o Makes for a highly customizable interface o Organizes common tasks together  Runs on Windows 7, Vista and XP  Office Backstage o Puts printing options in one place – gives a WYSIWYG preview o Replaces the “file” view  Text Wrapping  Filter Improvements  Auto-Complete  Copy and Paste o Indentions stay in place when copying in or out of Project o Can copy and paste between many Office applications ...

Here Is a link to give basic understanding of Project 2007 ..how to use it Click Here to Go One more ..sweeter White Papers

One fine day,one customer mailed me that he is not getting any search result."not even a single search result"..well it was more than a panic to me as day after we had a project server training and ppl might use Search functionality alot to get their projects and documents. After hell lot of effort, finally I was able to find out the reason behind it. There may be many reasons to stop Moss search but in our case it was MS Security update in MOSS web server "MS08-068: Vulnerability in SMB could allow remote code execution" Basically,this security update stops client to log in in Server machine(so you can log in on any application outside server,but if you try to log in on same app inside MOSS server,it will not allow you to do so. Now,due to this patch,our search service account was not able to crawl( as access denied was occurring) .. to Fix this problem I published a paper as follows Search Crawl is not working in MOSS 2007 server Symptoms: whenever we try to crawl...

My client Kathy loves reporting and she can ask anything on report...well one day she asked me to change the data point to a line (big line..) and to be my surprise there is not automatic marker style in SSRS to make this happen...but thanks to her that she has given me license to Use dundas... well after trying it hard ..i found the way and it brought a smile on her face ... To implement this 1)Create a custom line image in mspaint and save this as a file in the folder where your report solution is located 2)Click on the series for which you want custom marker style ..select Data point and use marker image to locate the file which you have created 3)Use marker style none in data point --Marker style section... and you are done with custom marker

well,dundas as I think gives you more option to make your charting life easy.To day I came across a problem in chart where client wanted to reduce the width of stack column..what the heck I thought (right away I thought that I need to enter few dummy values at x-axis with null data)...but wanted to give a try if dundas provide any mean to set it ..and yes it does ... as shown in image set the value of point width in series value ...you are done ..:)..I avoided to enter dummy points and then keep testing the width (saved my couple of hrs.)

http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

http://www.stevebin.net/Articles.aspx?ArtId=QL08

http://www.youtube.com/watch?v=EJIhgL2zRwI

Windows SharePoint Services Infrastructure for Project Server Microsoft Office Project Server 2007 is now a full member of a Windows SharePoint Services server farm. Each Project Web Access site collection can include subsites and an optional project workspace site for each project. A server farm with one Project Server installation can include multiple Project Web Access applications and Shared Services Providers (SSPs). Project Server can import SharePoint task lists as project proposals. This article describes how Project Server and Windows SharePoint Services work together, as well as some of the ways to use SharePoint data. The article includes the following sections. * Windows SharePoint Services Infrastructure * PSI Methods and Datasets for Project Workspaces * Using SharePoint Data o Resource Name Conflicts o Getting the Site ID for Impersonation o Problems with Importing SharePoint ...

Link for web part Link To Create a Web Part

click Here Another

Click here