tag:blogger.com,1999:blog-88368362024-03-08T16:55:00.449-05:00TechLearningMy technical notes about SharePoint, DotNet, JAVA and other technical learnings.Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-8836836.post-44789212478418018562014-03-05T06:39:00.004-05:002014-03-05T06:39:44.744-05:00Yammer is Microsoft's big bet for enterprise social....Yammer is now Microsoft's big bet for enterprise social and that makes sense: Yammer gets the kind of viral adoption SharePoint used to have before IT teams got their hands on it, when people were looking for a way to share documents. When they want to actually have a conversation with colleagues and partners, Yammer is where they turn.
http://www.zdnet.com/yammer-is-microsofts-big-bet-for-enterprise-social-and-heres-why-7000026956/
Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-10473751955280846362014-02-01T06:42:00.000-05:002014-03-05T06:43:40.529-05:00Microsoft discontinues its InfoPath electronic-forms productMicrosoft is "working on migration guidance" as it is building its "next generation of forms technology," officials added in the post, noting that Microsoft will continue to support InfoPath 2013 and InfoPath Forms Services for SharePoint Server 2013 through April 2023. Execs said Microsoft will provide more specifics on the future of Office forms "later this year" and will provide a sneak peek of what's being built at the company's SharePoint Conference 2014 in March.
http://www.zdnet.com/microsoft-discontinues-its-infopath-electronic-forms-product-7000025844/Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-53461565274457094102009-12-04T17:15:00.000-05:002009-12-05T17:21:18.765-05:00SharePoint 2010 Enhancements – Part2<p> </p> <p>As I learn, taking notes of some noticeable enhancements in SharePoint 2010 ( in my point of view)</p> <p><strong>Backup and Restore</strong></p> <ul> <li>SharePoint Server 2010 uses two different tools (Central admin and PowerShell) to configure backup and recovery. What happened to STSADM? It is still there, for only backward compatibility.  New backup plans should be incorporated with Windows PowerShell in place of Stsadm.</li> <li>Windows PowerShell provides administrators a way to perform backup and recovery with additional options such as file compression or working with SQL snapshots</li> <li>SharePoint Server 2010 provides several new features that provide a granular level of backup for various components of site content (site, subsite, and list level)</li> </ul> <p><strong>Database</strong></p> <ul> <li>In SharePoint Server 2010, you can restore site collections, sites, and lists from unattached content databases. You can simply do a SQL Server restore of the content database to any computer running SQL Server, then tell SharePoint to connect to it. This eliminates the need to build a second farm for granular recovery</li> <li>It has the ability to recognize read-only SQL databases. Whenever SharePoint Server is connected to a SQL database that has been placed in read-only mode, SharePoint Server will security trim all site collections in the database so that they are read-only to all users, removing all add and edit functionality from the sites, even for administrators</li> <li>It supports SQL mirroring natively. This allows a farm administrator to configure the SQL environment to mirror a SharePoint content database. Whenever a new database is created, the SharePoint administrator will be prompted to enter the failover server.</li> </ul> <p><strong>Managed Accounts</strong></p> <ul> <li>It reduces the load of managing various service accounts. SharePoint will take control all the service accounts we use inside the SharePoint (like changing the password automatically as per the policy or send a reminder when it is about to expire)</li> </ul> <p>More to come…..</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-22464470917775356432009-12-03T17:57:00.000-05:002009-12-03T18:03:04.755-05:00SharePoint 2010 Enhancements<p> </p> <p>My first look at noticeable enhancements in SharePoint 2010.</p> <p><strong>1. Developer Dashboard.</strong></p> <ul> <li>Determining what part of the system is causing a delay or consuming resources was difficult in previous versions. With dashboard, it records and displays performance statistics related to the code that executed to produce the page (with elapsed time as well as the load placed on the system by queries and tracking of exceptions ) </li> <li>It can be turned on by the following command. <ul> <li>stsadm -o setproperty -pn developer-dashboard -pv OnDemand </li> </ul> </li> <li>It is like ASP.Net tracing, so it should be turned on only in test servers , no on production server ( for performance reason). </li> </ul> <p><strong>2. Silverlight Web Part</strong></p> <ul> <li>To provide rich interactive experience, sharepoint now provides native support to Silverlight files (XAP) </li> </ul> <p><strong>3. Chart Web Part (Only with sever edition, not on foundation)</strong></p> <ul> <li>Different chart creation webparts are available, like ASP.NET Charts. </li> </ul> <p><strong>4. SharePoint List</strong></p> <ul> <li>Lookup Field to display fields from another list with the site. </li> <li>Lookup field relational enforcement. </li> <li>automatic creation of indexes on lists when necessary </li> </ul> <p><strong>5. LINQ support</strong></p> <ul> <li>LINQ is a new data access paradigm and can improve performance by allowing the back <br />end data source to decide the best way to solve the query. </li> </ul> <p>More in the next.</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-43874393971710714042009-11-30T14:47:00.000-05:002009-12-03T22:28:27.694-05:00Drives are running out of space<p> </p> <p>I have nearly 20% free space in my development VM</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SxbFWqT1fxI/AAAAAAAAEKM/sd57I04g4xo/s1600-h/image%5B2%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxbFWwz44YI/AAAAAAAAEKQ/DgH-5hyN-s0/image_thumb.png?imgmax=800" width="244" height="73" /></a> </p> <p>SharePoint 2010 is complaining about drives running out of space and also listed as critical error.</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/SxbFXLZoDCI/AAAAAAAAEKU/mDw2e-Jfspk/s1600-h/image%5B5%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxbFXZsYN-I/AAAAAAAAEKY/lM-1mqGy6So/image_thumb%5B1%5D.png?imgmax=800" width="244" height="47" /></a> </p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/SxbFXksyHlI/AAAAAAAAEKc/a_l5yG6-EYU/s1600-h/image%5B8%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/_VLn55faW3c8/SxbFYts6V9I/AAAAAAAAEKg/B9cw_yU-w_Y/image_thumb%5B2%5D.png?imgmax=800" width="244" height="44" /></a> </p> <p>I don’t know why this nagging error is displayed at home page of the central admin. But I figured out to clear out the error temporarily.  </p> <p>Go to central admin –> monitoring</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SxbFY4k8QJI/AAAAAAAAEKk/zZARbrvHMi0/s1600-h/image%5B11%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxbFZBs9rVI/AAAAAAAAEKo/RlwnzfZw2CE/image_thumb%5B3%5D.png?imgmax=800" width="244" height="89" /></a> </p> <p>click review rule definition</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/SxbFZSEzQaI/AAAAAAAAEKs/EJSw2jUF4h4/s1600-h/image%5B14%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxbFZ1_K0wI/AAAAAAAAEKw/Zy90hZHhdFM/image_thumb%5B4%5D.png?imgmax=800" width="244" height="42" /></a> </p> <p>Select the check box and click the edit button from the ribbon.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxbFaElZHNI/AAAAAAAAEK0/AdIORSC13o0/s1600-h/image%5B17%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/_VLn55faW3c8/SxbFau_aOKI/AAAAAAAAEK4/xfIMRx_ahQM/image_thumb%5B5%5D.png?imgmax=800" width="244" height="155" /></a> </p> <p>uncheck the enabled option.</p> <p>Go to the health reports and clear out the error. </p> <p>Select the checkbox and delete it from ribbon.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxbFa4xSYII/AAAAAAAAEK8/FAYan4Qqtkk/s1600-h/image%5B20%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxbFbM9HBxI/AAAAAAAAELA/oegYDoRIOSY/image_thumb%5B6%5D.png?imgmax=800" width="244" height="92" /></a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-33878206319464271072009-11-23T15:13:00.000-05:002009-12-01T15:32:57.590-05:00Installing 64bit SQL2008 On Windows 2008 R2<p> </p> <p><u>My system Configuration</u>: Intel Xeon Processor 64 bit with Windows 2008 R2.</p> <p>When I try to install SQL server 2008, the following error message was displayed.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV5lz1DHGI/AAAAAAAAEIA/sR1ge_6thRU/s1600-h/image2.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV5mJ_ntHI/AAAAAAAAEIE/H3R7smgrZ10/image_thumb.png?imgmax=800" width="244" height="118" /></a> </p> <p>Then I realized that, only SQL Server 2008 SP1 can be installed on Windows 2008 R2. </p> <p>Download <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19">SQL Server 2008 SP1</a>, and follow the method mentioned in this article to <a href="http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx">slipstream SQL Server 2008 SP1</a></p> <p>Note: If you want to use the SQL server 2008 with SharePoint 2010, you also need CU2 for Sp1 which can be found here (<a href="http://support.microsoft.com/kb/970315">http://support.microsoft.com/kb/970315</a>)</p> <p>Select “Run Program” and rest of the screen shots are self explanatory.</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SxV5nB78eRI/AAAAAAAAEII/nc4TZGYXrq8/s1600-h/image5.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV5nXrOp3I/AAAAAAAAEIM/38a_uQSdp1U/image_thumb1.png?imgmax=800" width="244" height="161" /></a> </p> <p>select installations and then select SQL server Standalone edition.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV5oPxuzqI/AAAAAAAAEIQ/h-rfAOZxq9s/s1600-h/image8.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxV5ok-8CJI/AAAAAAAAEIU/pF7zlJRDNkY/image_thumb2.png?imgmax=800" width="244" height="165" /></a> </p> <p> </p> <p>Enter Product Key and Accept License Agreement.</p> <p>Then install setup support files…</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/SxV5p57Kt-I/AAAAAAAAEIg/hDfExRpYS4Q/s1600-h/image14.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxV5qXYfdKI/AAAAAAAAEIk/O79Y5b7vI4s/image_thumb4.png?imgmax=800" width="244" height="75" /></a></p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SxV5qwLIC3I/AAAAAAAAEIo/arvPrhmtNfw/s1600-h/image17.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV5rCcXboI/AAAAAAAAEIs/L5gOSkPKMnU/image_thumb5.png?imgmax=800" width="244" height="96" /></a> </p> <p>Fix any issues..</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SxV5sHWr78I/AAAAAAAAEIw/orLvikXWqS0/s1600-h/image26.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxV5ssXe_JI/AAAAAAAAEI0/qZtM6MYYnBY/image_thumb8.png?imgmax=800" width="244" height="160" /></a> </p> <p>Select the required components from the next screen.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SxV5tayW9EI/AAAAAAAAEI4/cWkjxlaHDv0/s1600-h/image29.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/_VLn55faW3c8/SxV5t-IG8fI/AAAAAAAAEI8/n_xtJdU54qI/image_thumb9.png?imgmax=800" width="244" height="184" /></a> </p> <p>Select the location for SQL server files</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/SxV5ujfvumI/AAAAAAAAEJA/Wu26Vz4Y_3M/s1600-h/image32.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxV5vP7iz2I/AAAAAAAAEJE/ZiBbttEvOW4/image_thumb10.png?imgmax=800" width="244" height="185" /></a> </p> <p>Select an account name for each service. you can also use the button at the bottom of the screen to assign one account for all the services. It is easy some time to use local system account.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV5wNBSUaI/AAAAAAAAEJQ/h0L3ivNIhPE/s1600-h/image38.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxV5wtoeuWI/AAAAAAAAEJU/lF60xgiVD48/image_thumb12.png?imgmax=800" width="244" height="199" /></a> </p> <p>Select the authentication method and assign at least one administrator to the server.</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SxV5xIvQsuI/AAAAAAAAEJY/AQPlbS0r8bg/s1600-h/image41.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV5xpeZXpI/AAAAAAAAEJc/-ESB4GurGp0/image_thumb13.png?imgmax=800" width="244" height="172" /></a> </p> <p>On the FILESTREAM tab of the Database Engine Configuration page, select the <br />options for Enable FILESTREAM for Transact-SQL access and Enable FILESTREAM <br />for file I/O streaming access. FILESTREAM can also be enabled later, if you don’t know whether this option is required or not.</p> <p> </p> On the Analysis Services Configuration page, specify an administrator as an <br />Analysis Services administrator by clicking the <u>Add Current User</u> button at the bottom <br />of the page <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV5yUEdIQI/AAAAAAAAEJg/lBQiou8NNe8/s1600-h/image44.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV5zBB7llI/AAAAAAAAEJk/9z47-BmRuT8/image_thumb14.png?imgmax=800" width="244" height="183" /></a> </p> <p> </p> <p>Select the <u>Install the native mode default configuration </u> on reporting services configuration section. The report server will be usable after the configuration.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV5z_I3FQI/AAAAAAAAEJo/hmN8UuULHW4/s1600-h/image47.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV50WoSmvI/AAAAAAAAEJs/VhSfh24epbo/image_thumb15.png?imgmax=800" width="244" height="171" /></a> </p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SxV51C3Wx-I/AAAAAAAAEJ0/twgsLyg66uw/s1600-h/image50.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SxV51TfOvII/AAAAAAAAEJ4/iqm2-zN_3PE/image_thumb16.png?imgmax=800" width="244" height="122" /></a> </p> <p>Now you are ready to install and make sure the slipstream is defined properly as shown below.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SxV51gt9zeI/AAAAAAAAEJ8/DvdirBi5338/s1600-h/image53.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SxV52GV-QpI/AAAAAAAAEKA/6PDiSDNBP4U/image_thumb17.png?imgmax=800" width="244" height="98" /></a> </p> <p>If everything goes well, you should see success screen as shown below.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SxV52YgqpMI/AAAAAAAAEKE/heqS-iNCB_o/s1600-h/image56.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SxV525S9WsI/AAAAAAAAEKI/Ri0FuOd5trg/image_thumb18.png?imgmax=800" width="244" height="156" /></a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-64135072649988482612009-10-20T08:34:00.000-04:002009-10-20T15:35:52.083-04:00SharePoint 2010 Beta<p>Pre-register today and get notified when SharePoint 2010 Beta becomes available in November. Follow the link to pre-register <a title="http://sharepoint2010.microsoft.com/try-it/Pages/Trial.aspx" href="http://sharepoint2010.microsoft.com/try-it/Pages/Trial.aspx">http://sharepoint2010.microsoft.com/try-it/Pages/Trial.aspx</a></p> <p> </p> <p>Also Microsoft just released documents (Visio files) about SharePoint 2010 System requirements and upgrade process (from SharePoint 2007).</p> <p><a href="http://www.microsoft.com/downloads/info.aspx?na=47&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=8a6ce527-1ac3-4642-bd04-5e93efc364f6&u=details.aspx%3ffamilyid%3dEEF6F604-9FAA-4EA8-B000-569C656B7420%26displaylang%3den">Microsoft SharePoint Server 2010 Upgrade Planning</a></p> <p>It includes </p> <ul> <ul> <li>Upgrade requirements </li> <li>Hardware, operating system, and database Upgrade process </li> <li>Specific steps to follow before, during, and after the upgrade </li> </ul> </ul> <p> </p> <p><a href="http://www.microsoft.com/downloads/info.aspx?na=47&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=eef6f604-9faa-4ea8-b000-569c656b7420&u=details.aspx%3ffamilyid%3dE8B66EB3-27C7-4A39-A2E1-3E7D18B12EE1%26displaylang%3den">Microsoft SharePoint Server 2010 Upgrade Approaches</a></p> <p>It helps you understand the in-place, database attach, and hybrid approaches to upgrading from Office SharePoint Server 2007 to SharePoint Server 2010</p> <p> </p> <p><a href="http://www.microsoft.com/downloads/info.aspx?na=47&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=eef6f604-9faa-4ea8-b000-569c656b7420&u=details.aspx%3ffamilyid%3d8A6CE527-1AC3-4642-BD04-5E93EFC364F6%26displaylang%3den">Microsoft SharePoint Server 2010 — Services Upgrade</a></p> <p>It covers the unique issues of upgrading services by using either the in-place or database attach approach are discussed. </p> <p> </p> <p><a href="http://www.microsoft.com/downloads/info.aspx?na=47&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=eef6f604-9faa-4ea8-b000-569c656b7420&u=details.aspx%3ffamilyid%3dD7389D9F-F70F-4226-89AA-A96A05A497F0%26displaylang%3den">Microsoft SharePoint Server 2010 — Test Your Upgrade Process</a></p> <p>It explains the methodology for testing the upgrade process before upgrading from Office SharePoint Server 2007 to SharePoint Server 2010.</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-71403166118055531112009-10-06T13:13:00.000-04:002009-10-06T13:17:39.250-04:00Create an Event Handler Feature with VSeWSS1.3<p><b>How to: Create an Event Handler Feature with VSeWSS1.3</b></p> <p><b><u>Prerequisites:</u></b></p> <p>Read the following to understand about Event model and Feature in SharePoint.</p> <p>· <a href="http://msdn.microsoft.com/en-us/library/ms442323.aspx">Event Fundamentals</a></p> <p>· <a href="http://msdn.microsoft.com/en-us/library/ms460318.aspx">Working with Features</a></p> <p>· <a href="http://msdn.microsoft.com/en-us/library/aa543214.aspx">Solutions Overview</a></p> <p><b><u>Software Environment:</u></b></p> <p>· VM with MOSS 2007 SP2</p> <p>· Visual Studio 2008 Professional</p> <p>· <a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fb9d4b85-da2a-432e-91fb-d505199c49f6#filelist">VSeWss 1.3</a><u></u></p> <p><b><u>Object Model:</u></b></p> <p>SharePoint Object Model exposes several event classes inherited from Microsoft.SharePoint assembly. There are four important classes:</p> <p>· <a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spitemeventreceiver.aspx">SPItemEventReceiver Class</a></p> <p>· <a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splisteventreceiver.aspx">SPListEventReceiver Class</a></p> <p>· <a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spwebeventreceiver.aspx">SPWebEventReceiver Class</a></p> <p>· <a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfeaturereceiver.aspx">SPFeatureReceiver Class</a></p> <p><b><u>Building the Feature:</u></b></p> <p>It shows how to add a simple event handler that prevents items from being added to a list. Two procedures are involved in this task: </p> <p>· Creating an event handler in Microsoft Visual Studio</p> <p>· Adding the event handler as a Feature in Windows SharePoint Services </p> <p><b>1. </b>Create a new project in Visual Studio by clicking <strong>File</strong>, pointing to <strong>New</strong>, and then clicking <strong>Project</strong>.<b><u></u></b></p> <p><b><u><a href="http://lh4.ggpht.com/_VLn55faW3c8/Sst7Czh1_gI/AAAAAAAAD_g/FBgAdLf7gqQ/s1600-h/clip_image002%5B3%5D.jpg"><img title="clip_image002" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="255" alt="clip_image002" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7DT6PkNI/AAAAAAAAD_k/smI-fC0wcxs/clip_image002_thumb.jpg?imgmax=800" width="376" border="0" /></a></u></b></p> <p>Select <b>Empty</b> project from the SharePoint template list and give a name to the project</p> <p>2. Select GAC from the Trust Level ( Event Handlers must be deployed only in GAC)</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/Sst7DoGbEKI/AAAAAAAAD_o/13eUCXQSnv8/s1600-h/clip_image004%5B3%5D.jpg"><img title="clip_image004" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="213" alt="clip_image004" src="http://lh5.ggpht.com/_VLn55faW3c8/Sst7EEBhphI/AAAAAAAAD_s/0SIzLYLY3mU/clip_image004_thumb.jpg?imgmax=800" width="360" border="0" /></a></p> <p>3. In Solution explorer, Right click on the project, and Add a new Item to the project</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/Sst7EiogaQI/AAAAAAAAD_w/9NBhxv7fx9U/s1600-h/clip_image006%5B3%5D.jpg"><img title="clip_image006" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="260" alt="clip_image006" src="http://lh6.ggpht.com/_VLn55faW3c8/Sst7FAoK2tI/AAAAAAAAD_0/KscqWLCEhiA/clip_image006_thumb.jpg?imgmax=800" width="271" border="0" /></a></p> <p>Select <b>SharePoint </b>category and select the ‘<b>event receiver’</b> template.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/Sst7FYD4xfI/AAAAAAAAD_4/iaf9P0Czo50/s1600-h/clip_image008%5B3%5D.jpg"><img title="clip_image008" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="228" alt="clip_image008" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7F7YBO8I/AAAAAAAAD_8/EqAHPGftOJE/clip_image008_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>Select <b><u>‘Document Library’</u></b> from the list</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/Sst7GcWykpI/AAAAAAAAEAA/18WxDOD0dgg/s1600-h/clip_image010%5B3%5D.jpg"><img title="clip_image010" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="172" alt="clip_image010" src="http://lh3.ggpht.com/_VLn55faW3c8/Sst7G8b0ZrI/AAAAAAAAEAE/1_9bPbO_eRU/clip_image010_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>4. This would have created set of files for <u>ItemEventReceiver</u> and <u>ListEventReceiver</u>, as shown below. Depending on the situation you can delete either one of the EventReceiver.</p> <p><a href="http://lh3.ggpht.com/_VLn55faW3c8/Sst7HJvvskI/AAAAAAAAEAI/Ha7_NKC2SWs/s1600-h/clip_image012%5B3%5D.jpg"><img title="clip_image012" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="260" alt="clip_image012" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7HnU6uLI/AAAAAAAAEAM/R_f1nGPkqaI/clip_image012_thumb.jpg?imgmax=800" width="174" border="0" /></a></p> <p>5. Open the ItemEventReceiver.cs file and add code to the <u>ItemAdding</u> event as shown below. The code will prevent adding new item to the list.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/Sst7H2ltV2I/AAAAAAAAEAQ/zUAi6CBOS9U/s1600-h/clip_image014%5B3%5D.jpg"><img title="clip_image014" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="95" alt="clip_image014" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7IetPJQI/AAAAAAAAEAU/w3Xx-9q9qBE/clip_image014_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>6. Similarly add code to the <u>ListEventReceive</u>r as shown below. The sample code will prevent adding new column to the list.</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/Sst7I3zrBFI/AAAAAAAAEAY/CjQcUoDo-Ec/s1600-h/clip_image016%5B3%5D.jpg"><img title="clip_image016" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="67" alt="clip_image016" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7JAxsVYI/AAAAAAAAEAc/pEi2Q9HxN0M/clip_image016_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>7. Select Project Properties and enter the URL location of website where you want to deploy the EventReceiver.</p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/Sst7Je8DakI/AAAAAAAAEAg/U4AQhrVlzjo/s1600-h/clip_image018%5B3%5D.jpg"><img title="clip_image018" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="81" alt="clip_image018" src="http://lh5.ggpht.com/_VLn55faW3c8/Sst7J2mKowI/AAAAAAAAEAk/77iDCcpsmEk/clip_image018_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>8. Next step is to create solution to deploy these two Features. Click on ‘WSP View’ (or press Ctrl+W,I), you can see list of files required for the Solution with two Features.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/Sst7Ks__eaI/AAAAAAAAEAo/ugEecqUFQ04/s1600-h/clip_image020%5B3%5D.jpg"><img title="clip_image020" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="221" alt="clip_image020" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7LIqcTnI/AAAAAAAAEAs/D4Y8yJ1yAT0/clip_image020_thumb.jpg?imgmax=800" width="278" border="0" /></a></p> <p>9. Open the ‘feature.xml’ under ItemEventReceiver and change the title to meaningful one. If required add ‘Description’ also.</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/Sst7LdElzsI/AAAAAAAAEAw/0uyVmLnIp54/s1600-h/clip_image022%5B3%5D.jpg"><img title="clip_image022" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="62" alt="clip_image022" src="http://lh3.ggpht.com/_VLn55faW3c8/Sst7Lmf9AEI/AAAAAAAAEA0/FZeEkqbOIEc/clip_image022_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>10. DO the same for the other Event receiver.</p> <p>11. Press F5 to compile and deploy the solution. Also this would create a WSP file under <b><u>bin/debug</u></b> directory. You can use this WSP file to deploy this in different website.</p> <p>12. Go to SharePoint website, SiteActions->Site Settings->Site Feature and check that the two Features are deployed and activated properly. </p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/Sst7MOxZuKI/AAAAAAAAEA4/tT_gCns3RxM/s1600-h/clip_image024%5B3%5D.jpg"><img title="clip_image024" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="20" alt="clip_image024" src="http://lh5.ggpht.com/_VLn55faW3c8/Sst7MZ2cGWI/AAAAAAAAEA8/LPqYctvFkeA/clip_image024_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/Sst7MnVELEI/AAAAAAAAEBA/KfoSvr1Dzy0/s1600-h/clip_image026%5B3%5D.jpg"><img title="clip_image026" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="20" alt="clip_image026" src="http://lh4.ggpht.com/_VLn55faW3c8/Sst7M761ksI/AAAAAAAAEBE/wzeJVnqpksA/clip_image026_thumb.jpg?imgmax=800" width="376" border="0" /></a></p> <p>13. Open the Document Library within the website and try to add an Item / a column. This should generate a custom error like this.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/Sst7NaD8WvI/AAAAAAAAEBI/cSkFu54iCtg/s1600-h/clip_image028%5B3%5D.jpg"><img title="clip_image028" style="border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="138" alt="clip_image028" src="http://lh6.ggpht.com/_VLn55faW3c8/Sst7NstAQTI/AAAAAAAAEBM/VhpTydl-DV8/clip_image028_thumb.jpg?imgmax=800" width="279" border="0" /></a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-42506501090744960742009-09-10T17:20:00.001-04:002009-09-10T17:20:39.980-04:00SharePoint 64-Bit<p></p> <p> </p> <p>It is highly recommended to prepare for migration of your applications to the next SharePoint version 2010, if any one of the following is applicable.</p> <ul> <li>performance of the server farm is not meeting customers’ expectations, </li> <li>the user base is growing rapidly, </li> <li>the application pools are recycling more and more often</li> <li>a scheduled equipment upgrade is approaching.</li> </ul> <p>The basic requirement for 2010 is listed below..</p> <ul> <li>SharePoint Server 2010 will be 64-bit only. </li> <li>SharePoint Server 2010 will require 64-bit Windows Server 2008 </li> <li>SharePoint Server 2010 will require 64-bit SQL Server 2008 / 2005. </li> <li>SharePoint 2010 will support only Internet Explorer 7, Internet Explorer 8 and FireFox 3.x IE6 is not supported.</li> </ul> <p>Things to know/remember about 64 bit environment.</p> <ul> <li>Not all 64-bit processors are supported. For example, Intel’s Itanium series of 64-bit processors uses a proprietary design that is not compatible with Microsoft SharePoint Products and Technologies. So research before ordering new hardware.</li> <li>A 64-bit system architecture that is running a 64-bit edition of Windows Server can support up to 1,024 GB of both physical and addressable memory.</li> <li>64-bit environment does not require worker processes to cycle as often, so it can support more user base/server. So basically you can reduce number of servers in the farm to support more users compared to 32 bit environment.</li> <li>In 64 bit environment(hardware/server/DB all 64 bit), it is possible for SQL Server to get very large working data sets entirely into RAM, thereby improving performance and scalability.</li> </ul> <p>Best places to get more information about the new version and migration process:</p> <ol> <li><a href="http://technet.microsoft.com/en-us/library/dd630764.aspx">Advantages of 64-bit hardware and software (Office SharePoint Server 2007)</a></li> <li><a href="http://technet.microsoft.com/en-us/library/cc262485.aspx">Determine hardware and software requirements (Office SharePoint Server)</a> </li> <li><a href="http://technet.microsoft.com/en-us/library/dd622865.aspx" target="_blank">Migration strategy to a 64-bit environment (Office SharePoint Server 2007)</a></li> <li><a href="http://msdn.microsoft.com/magazine/dd458798.aspx">10 best practices for building SharePoint solutions</a></li> </ol> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-24872452561738297022009-08-11T12:57:00.000-04:002009-08-11T12:57:00.125-04:00IE to Support the Proposed HTML 5 Standard.<p> </p> <p>After years of veiled and even outspoken criticism from <a href="http://news.softpedia.com/news/Internet-Explorer-to-Support-the-Proposed-HTML-5-Standard-118722.shtml#">browser</a> makers and many web developers, Microsoft has decided to start supporting the proposed HTML 5 standard in its Internet <a href="http://news.softpedia.com/news/Internet-Explorer-to-Support-the-Proposed-HTML-5-Standard-118722.shtml#">Explorer web</a> browser. While known for its spotty support of even ratified standards, Internet Explorer has been moving in the right direction in recent years with IE 7 and the new IE 8. The current HTML 5 draft brings a number of advanced features and improvements and has seen great support from Google, Mozilla and Apple.</p> <p><a title="http://news.softpedia.com/news/Internet-Explorer-to-Support-the-Proposed-HTML-5-Standard-118722.shtml" href="http://news.softpedia.com/news/Internet-Explorer-to-Support-the-Proposed-HTML-5-Standard-118722.shtml">http://news.softpedia.com/news/Internet-Explorer-to-Support-the-Proposed-HTML-5-Standard-118722.shtml</a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-14263370510239764522009-08-10T12:54:00.000-04:002009-08-10T12:55:03.037-04:00Microsoft’s SharePoint Thrives in the Recession<p> </p> <p>Hang around at Microsoft’s Redmond, Wash., headquarters for five or ten minutes and someone dressed in khaki pants and a blue shirt is bound to tell you about the wonders of SharePoint — one of the company’s most successful and increasingly controversial lines of software. Think of SharePoint as the jack-of-all-trades in the business software realm. Companies use it to create Web sites and then manage content for those sites. It can help workers collaborate on projects and documents. And it has a variety of corporate search and business intelligence tools too. To read more, click here…</p> <p><a title="http://bits.blogs.nytimes.com/2009/08/07/microsofts-sharepoint-thrives-in-the-recession/" href="http://bits.blogs.nytimes.com/2009/08/07/microsofts-sharepoint-thrives-in-the-recession/">http://bits.blogs.nytimes.com/2009/08/07/microsofts-sharepoint-thrives-in-the-recession/</a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-33362167941269417442009-07-09T15:20:00.000-04:002009-07-09T15:20:00.489-04:00Prevent making changes to WSS content types.<p> </p> <p>There are <strong><u>three ways</u></strong> you can prevent users from making changes to SharePoint (WSS) content types. Also there are few things to consider before taking these steps.</p> <p><strong>1: Read-Only content types:</strong> </p> <p>You can set it read-only using the interface, like this..</p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SlTxuiEPNPI/AAAAAAAADuA/Z0W1bO0GdLg/s1600-h/image%5B11%5D.png"><img title="image" style="border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px" height="132" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SlTxu0sSD2I/AAAAAAAADuE/iObRhStfueg/image_thumb%5B3%5D.png?imgmax=800" width="354" border="0" /></a> </p> <p>But once you set it read-only, then:</p> <ul> <li>You cannot make changes to the content type thro WSS interface.</li> <li>YOU CAN only make Changes programmatically using object model.</li> <li>Pushing down parent content type changes (if any) is little tricky.</li> </ul> <p><strong>2. Sealed Content Type.</strong></p> <p>This provides more control, but a content type can only be made sealed type by editing the XML definition of the content type.</p> <p>But once you set it sealed, then:</p> <ul> <li>You cannot make changes to the content type thro WSS interface.</li> <li>You cannot make changes programmatically using object model.</li> <li>Pushing down parent content type changes to the sealed content type is not possible.</li> </ul> <p><strong>3. Hidden type.</strong></p> <p>You can assign a content type to a predefined group called, “_Hidden” (case sensitive). You can set it as shown below..</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SlTxvcqj0bI/AAAAAAAADuI/xh63JcovxSM/s1600-h/image%5B14%5D.png"><img title="image" style="border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px" height="61" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SlTxvoWxuQI/AAAAAAAADuM/zCjhnSacIGE/image_thumb%5B4%5D.png?imgmax=800" width="354" border="0" /></a> </p> <p></p> <p></p> <p></p> <p>But once you set it to hidden group, then:</p> <ul> <li>Hidden types are not visible, so you cannot make changes to the content type thro WSS interface.</li> <li>You can make changes programmatically using object model ( including inheriting).</li> <li>Pushing down parent content type changes to the child content type is possible.</li> </ul> <p>For hidden , see here for more information. <a href="http://msdn.microsoft.com/en-us/library/ms460561.aspx" target="_blank">Content Type Access Control</a></p> <p>Hope it helps.</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-27767106693406953822009-07-08T10:30:00.000-04:002009-07-08T10:50:48.034-04:00Deleting content type…<p><font face="Arial" size="2"></font></p> <p><font size="2"></font></p> <p><font size="2"></font></p> <p><font size="2"></font></p> <p><font size="2">In SharePoint 3.0, Can you delete a content type, if it is being used in other site or list ? No, you cannot. We know that we can create a content type based on other content type and each content type contains reference to the content type on which it is based on. SharePoint checks that before deleting a content type whether it is being used somewhere as a base of content type. You have to remove first the content type from all lists and sites that are using it.   But, the good thing is , WSS won’t consider the items ( that are using the deleted content type) in the recycle bin. So when you try to restore the list item after their content type has been deleted, the list items are assigned to default content type ( instead of giving strange error like “content type not found”.)</font></p> <p><font face="Arial" size="2"></font></p> <p><font face="Arial" size="2"> </font></p> <p><font face="Arial" size="2"> </font></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-50893045623016829912009-04-29T07:48:00.000-04:002009-04-29T08:01:13.772-04:00Mirrored Accounts<p><u><strong>ASP.NET Application with mirrored accounts.</strong></u></p> <p>If your Web server and database server are not in the same or trusted domain, then you cannot use windows based authentication. The workaround is to use mirrored accounts (other than storing username/pwd in the config file). To use this, create a local account with the same user name and password on each server and then create a SQL Server login for the local account on the database server (article collected from MSDN articles).</p> <p><strong>Create a local account (on Application Server)</strong></p> <ol> <li>Create a local Windows account. </li> <li>Run the following Aspnet_regiis.exe command to assign the relevant ASP.NET permissions to the account: aspnet_regiis.exe -ga machineName\userName  </li> <li>Use the Local Security Policy tool to grant the Windows account the <u>Deny logon locally</u> user right. </li> <li>Use IIS Manager to create an application pool running under the new account's identity and assign the ASP.NET application to the pool. </li> </ol> <p><strong>Create an application pool that runs using a custom service account</strong></p> <ol> <li>Start Internet Information Services (IIS) Manager. </li> <li>In the left pane, expand the local computer and then expand Application Pools. </li> <li>Right-click the Application Pools node, click New, and then click Application Pool. </li> <li>In the Add New Application Pool dialog box, type TestPool in the Application Pool ID text box. Leave the Use default settings for new application pool option selected, and click OK. This creates a new application pool called TestPool. </li> <li>Right-click the new application pool. and click Properties. </li> <li>Click the Identity tab. </li> <li>In the Application pool identity section, click Configurable. </li> <li>Type CustomASP in the User name text box. </li> <li>Type the password for the CustomASP account in the Password text box, and click Apply. </li> <li>The Confirm Password dialog box appears. Type the password again, click OK, and then click OK again. </li> </ol> <p><strong>Create a local account (on Database Server)</strong></p> <p>Create a local account on the database server using the same username and password as the account you created on the Web server (in the previous step).</p> <ol> <li>Create a local Windows account. </li> <li>Use the Local Security Policy tool to grant the Windows account the <u>Deny logon locally</u> user right. </li> </ol> <p> </p> <p><strong>Grant database access to the Custom Service account</strong></p> <ol> <li>Create a SQL Server login for the Network Service account. If your database is on a separate server, create the login for the <i>domainName</i>\<i>WebServerMachineName</i>$ identity. You can use Enterprise Manager or run the following SQL statement in the osql command line tool to create the SQL login. </li> </ol> <p>            exec sp_grantlogin '<i>domainName</i>\<i>WebServerMachineName</i>$'</p> <p>    2.  Create a database user in the required database, and map the login to the database user. Alternatively, you can run the       following SQL statements: </p> <p>use targetDatabase</p> <p>go</p> <p>exec sp_grantdbaccess '<i>domainName</i>\<i>WebServerMachineName</i>$'</p> <p>go</p> <ol> <li>Grant permissions to the role. Ideally, you should grant execute permissions to selected stored procedures and provide no direct table access. </li> </ol> <p><strong>Change In Web.config</strong></p> <p>The connection string used with Windows authentication must include either the Trusted_Connection=Yes attribute,  as shown here.</p> <p><connectionStrings></p> <p><add name="MyDbConn1" </p> <p>connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/></p> <p></connectionStrings> </p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-69642147886010127832009-04-23T14:21:00.000-04:002009-04-23T14:24:27.590-04:00Could not able to uninstall SharePoint<p><b><u>Configuration</u></b>:</p> <p>MOSS (2007 with SP1) installation on windows 2003 R2 (SP2) standalone machine. (Contains WFE, Appserver, and SQLDB with Embedded Edition)</p> <p> </p> <p><b><u>Reason for crash:</u></b></p> <p>The latest change in <u>Auto update</u> configuration of the machine, automatically updated the SQL server with SP2. This machine contains only MS embedded edition (which comes with basic installation of MOSS) of SQL server, not standard or higher. I think the SP2 is not for EE, and obviously corrupted the config DB.</p> <p> </p> <p><b><u>Detail:</u></b></p> <p>After the latest MS patch, the MOSS server stopped working. It gave couple of error like this in the event viewer.</p> <p>· Unknown SQL Exception 33002 occurred. Additional error information from SQL Server is included below.</p> <p>Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.</p> <p>· The description for Event ID ( 33002 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: module, dbo.proc_GetRunnableWorkItems.</p> <p>· Cannot start service SPAdmin on computer…. (part of configuration wizard rerun process).</p> <p> </p> <p><b><u>Explored Solution:</u></b></p> <p>1. Ran the SharePoint configuration wizard did not help. It stopped at the 4 or 5th point.</p> <p>2. Server reboot did not give any help. Tried configuration wizard again….no luck.</p> <p>3. <code>Tried to upgrade the DB with the following command. %commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\BIN\psconfig -cmd upgrade -inplace b2b -wait -force</code></p> <p>4. So tried to remove the MOSS installation, Using Add/Remove programs. But I could not able to uninstall SharePoint trial version. The uninstall option quit without any error.</p> <p>5. Ran the MOSS installation program(using installation CD) and chose the ‘remove’ option to remove the existing MOSS installation. This also did not work (program stopped without any error).</p> <p>6. <u><strong>Finally</strong></u> I reinstalled the latest service pack, SP1, again on WSS and MOSS. Then I ran the configuration wizard, which went through without any error. The SharePoint sites started working (no errors in the log). </p> <p> </p> <p>Strange... but worked..</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-62816767870496539792009-04-23T13:58:00.000-04:002009-04-23T14:11:19.344-04:00Two DB with Standalone installation of SharePoint<p> </p> <p>When I installed SharePoint on a standalone machine, it installed two different installation of SQL server </p> <p>1. One is Embedded edition which stored the site content.  This database is located in Windows directory.  This one is running with service name of Microsoft##SSEE.</p> <p><a href="http://lh5.ggpht.com/_VLn55faW3c8/SfCvQeDXSJI/AAAAAAAADlA/L4T7UHF8bwY/image%5B5%5D.png"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="171" alt="image" src="http://lh5.ggpht.com/_VLn55faW3c8/SfCvQmCa02I/AAAAAAAADlE/zkvYXGMU0N8/image_thumb%5B1%5D.png" width="201" border="0" /></a> </p> <p>To connect to this use this as server name in SQL management studio:\\.\pipe\MSSQL$Microsoft##SSEE\SQL\query</p> <p> </p> <p>2. The second installation for Search content and the location of the content DB is within 12 hives. This one is running with service name of OFFICESERVERS.</p> <p> </p> <p><a href="http://lh6.ggpht.com/_VLn55faW3c8/SfCvQ9Siw2I/AAAAAAAADlI/cIa6wBjrEY0/image%5B2%5D.png"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="155" alt="image" src="http://lh4.ggpht.com/_VLn55faW3c8/SfCvRe4G7XI/AAAAAAAADlM/3bHp7blnLL0/image_thumb.png" width="197" border="0" /></a> </p> <p> </p> <p>I am just wondering why do we need two instances of SQL server? We could have achieved with one SQL server instance. Any Idea?</p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-91377611323685255342009-01-27T07:04:00.001-05:002009-01-27T07:06:43.923-05:00IE Developer toolbar is a third party extension?<p> </p> <p>Problem: IE developer toolbar stopped working</p> <p>Environment : Windows 2003 Server</p> <p>IE version: 7.0.5</p> <p>When I installed the latest patch, it upgraded IE6 to IE7. The IE toolbar was working fine with IE6, and it stopped working with IE7. After lot of experimentation, it started working when I enabled third-party extension. Here is the screen shot.</p> <p> </p> <p><a href="http://lh4.ggpht.com/_VLn55faW3c8/SX74Rcr4QzI/AAAAAAAADd0/4QpwC5K3A5g/image2.png"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="244" alt="image" src="http://lh6.ggpht.com/_VLn55faW3c8/SX74RhA9b7I/AAAAAAAADd4/cCbTKsq4JjE/image_thumb.png" width="198" border="0" /></a></p> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-64099879413546063762008-05-16T14:47:00.000-04:002008-05-22T17:20:16.065-04:00WSP Deployment ErrorI was trying to deploy WSP file into my Sharepoint Server, I got this error... <br id="vzwa0" /> <br id="vzwa1" /><span id="vzwa2" style="font-family: arial"><u><font size="4">administrative service for this server is not enabled <br id="amo30" /> <br id="vzwa4" /></font></u></span>To fix this error, just enable Sharepoint Administrative Services in the Service section.. <br id="amo31" /><img id="amo32" style="width: 583px; height: 109px" src="http://docs.google.com/File?id=adhk5ng4zxxm_41cjgzh9c3_b" /><span id="pxd00" style="font-family: arial"> <div id="zw-s" style="padding-right: 0pt; padding-left: 0pt; padding-bottom: 1em; padding-top: 1em; text-align: left"> <div id="x9.8" style="padding-right: 0pt; padding-left: 0pt; padding-bottom: 1em; padding-top: 1em; text-align: left"> <div id="rwtp" style="padding-right: 0pt; padding-left: 0pt; padding-bottom: 1em; padding-top: 1em; text-align: left"> <br id="t8g60" /></div> <br id="l..11" /></div> <br id="h7_v0" /></div> </span> <br id="vzwa7" /> Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-19075751782222526982008-05-16T14:06:00.000-04:002008-05-16T15:55:33.483-04:00Posting Video in Sharepoint BlogHow to post Video in <span class="blsp-spelling-error" id="SPELLING_ERROR_0">sharepoint</span> Blog. There are some tricks to learn. Read more...<br /><a href="http://www.piflar.com/boris/Docs/EmbedFlashInWSS/embedFlashInWSS.html">Created by <span class="blsp-spelling-error" id="SPELLING_ERROR_1">Camtasia</span> Studio 3</a>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-65201006201415631702008-05-16T14:02:00.000-04:002008-05-16T14:02:38.759-04:00Silverlight Essential Training - lynda.com Online Training Library®<span style="text-decoration: underline;">Read this to learn sliverlight </span><br /><a href="http://movielibrary.lynda.com/html/modPage.asp?ID=473">Silverlight Essential Training - lynda.com Online Training Library®</a>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-1156432728736180062006-08-24T11:18:00.000-04:002006-10-25T13:20:20.821-04:00 <br><font size="2"><b>Astronomers meeting in the Czech capital have voted to strip Pluto of its status as a planet.<br><br></b></font><font size="2">The eight planets are Mercury, Earth, Venus, Mars, Jupiter, Saturn, Uranus and Neptune," said the IAU resolution, which was passed following a week of stormy debate.<br><br></font><a title="More info on this." href="http://news.bbc.co.uk/2/hi/science/nature/5282440.stm">More info on this.</a> <br><br>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-1152758622948345632006-07-12T22:39:00.000-04:002006-10-25T13:20:20.503-04:00Javascript & AJAX FrameworksDojo is opensource framework that makes professional web development easier and faster.<br /><br /><a href="http://dojotoolkit.org/">http://dojotoolkit.org/</a><br /><br />Rico is also opensource Javascript framework with Ajax support.<br /><br /><a href="http://openrico.org/rico/home.page">http://openrico.org/rico/home.page</a>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-1152757692435705282006-07-12T22:28:00.000-04:002006-10-25T13:20:20.439-04:00Agile Development ResourcesWhat is Agile development? It may be a philosophy or effective methodology or mix of methodologies or adaptive best practices or something else. Is it all these things? The answer is "yes." It's all of these and more.<br /><br />Nice collection of resources on Agile development, compiled by Brent Sheets, is an introduction to the Agile movement.<br /><br /><a href="http://www.theserverside.net/tt/articles/showarticle.tss?id=AgileResources">Enterprise .NET Community: Agile Development Resources</a>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-1145816565558983722006-04-23T14:22:00.000-04:002006-10-25T13:20:20.182-04:00Top 10 Windows XP Tips Of All Time - Yahoo! News<a href="http://news.yahoo.com/s/cmp/20060422/tc_cmp/186500837;_ylt=AutASNgKD2gY9THsUjTXWrus0NUE;_ylu=X3oDMTA3ODdxdHBhBHNlYwM5NjQ-">Top 10 Windows XP Tips Of All Time - Yahoo! News</a>Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0tag:blogger.com,1999:blog-8836836.post-1145649430512095672006-04-21T15:52:00.000-04:002006-10-25T13:20:20.122-04:00WINK ---Presentation creation software<table border="0"><tbody><tr><td colspan="2">Wink is a Tutorial and Presentation creation software, primarily aimed at creating tutorials on how to use software (like a tutor for MS-Word/Excel etc). Using Wink you can capture screenshots, add explanations boxes, buttons, titles etc and generate a highly effective tutorial for your users.</td></tr> <tr><td><br />Tutorials can be found <a href="http://www.debugmode.com/userforums/viewforum.php?f=34">at the User Forums</a>.<br /><br />This is a good example of how you can create tutorials in Wink, by capturing screenshots, mouse movements and specifying your own explanations with them. And all this in a standard Windows-based UI with drag-and-drop editing makes it very easy to create high quality tutorials/documentation.<br /><br />It works fine with Macromedia player. Using Wink you can create content viewable across the web in all these users' desktops. Wink is <b>free</b> with unrivaled features.<br /></td></tr></tbody></table><br />Download the software from here. http://www.debugmode.com/wink/Kasi Krishnamoorthyhttp://www.blogger.com/profile/05925095047248759750noreply@blogger.com0