You are a Community Credit Winner - April 2007

Won 14th Prize in the April 2007 Contest

The Classic Wind-Up Robot

Third time i'm winning prize in Community Credit.

Infopath 2007 - Multiple submit buttons

Running InfoPath 2007, If i would like to have 2 Submit buttons on my form. One to email the form to an e-mail address provided by a form field and the another to publish to a Sharepoint site.

I can easily create these using Infopath button properties, but when I create the second button and change it's properties it also changes the properties of the first buttom.

Is it possible to have multiple submit buttons performing different tasks? If so, how.

In this case, you need to go for 'Rules and Custom Code' option in the button property.

For more reference: microsoft released doc.

Other reference:
http://office.microsoft.com/en-us/infopath/HA101067271033.aspx

Silverlight - Developing next generation interactive media applications for the Web

Microsoft Silverlight

Developing next generation interactive media applications for the Web, Microsoft last week unveiled Silverlight, formerly code-named Windows Presentation Foundation Everywhere (WPF/E). The cross-browser, cross-platform plug-in enables fast delivery of high-quality audio and video and offers consistent experiences to both Macintosh and Windows users on a variety of browsers including Internet Explorer, Firefox, and Safari. For more...

Downloads

Pocket-sized reference for IT professionals who administer and support Microsoft Exchange Server 2007

The practical, pocket-sized reference for IT professionals who administer and support Microsoft Exchange Server 2007.

Three sample chapters - free for download.

Chapter 2: Deploying Microsoft ExchnageServer 2007.
Chapter 6: Configuring Microsoft ExchangeServer With Exchange Management shell.
Chapter 8: MailBox Administration.

Download Here...

Anti-Virus with SharePoint 2007 - Security for MOSS 2007

Antigen for SharePoint - Sybari

Enforce Content Policies and Prevent Viruses on Microsoft Collaboration Systems

Portal Protect for SharePoint - Trend Micro

Virus protection and content filtering for Microsoft SharePoint

McAfee PortalShield for Microsoft SharePoint - McAfee

Keep your Microsoft SharePoint server free of viruses and other threats

AVG 7.5 for SharePoint - AVG(grisoft)

Security protection against worms, trojans, spyware and adware for any file server, regardless of workloads

Microsoft SharePoint Certification

The following are the certification for SharePoint 2003

Exam 74-132: Designing a Portal Solution with Microsoft® SharePoint® Products and Technologies more...

Exam 74-133: Customizing Portal Solutions with Microsoft® SharePoint® Products and Technologies more...

The following are the certification for SharePoint 2007

Exam 70-630 - Office SharePoint Server 2007, Configuring more...

Exam 70-631 - Windows SharePoint Services 3.0, Configuring more...

Exam 70-541 - Microsoft Windows SharePoint Services 3.0 - Application Development more...

Exam 70-542 - Microsoft Office SharePoint Server 2007 - Application Development more...

ExamCentres:

Through http://www.prometric.com/ you can do any specific brand certification like Microsoft, Suc, etc,... same as http://www.vue.com/

Excel Services in MOSS 2007 - Sharing your excel

Introduction:

Excel Services is a new technology that ships as part of Shared Services and allows you to calculate and display Excel spreadsheets using MOSS 2007 without necessarily having a copy of Excel on the client machines. With Excel Services you can simply share a spreadsheet using the browser. Excel Services has a calculation engine that supports calculating spreadsheets on the server in order to offload resource intensive calculations.

The three main components of the Excel Services are

1) Excel Web Access web part

2) Excel Calculation Services

3) Excel Web Services

To start with, first check your Excel Calculation Services is running. How to check this? go to Central administrator and click the operations tab and Topology and Services select Services on server, the services will be listed as in the below image.

And now you need to create a trusted work location for your Excel. To do that create or configure a shared services. First open the shared Services Administration and create new SSP, after creating your new SSP open your administration page of your newly created SSP. In your SSP administrator page Under Excel Services Settings select Trusted file locations. Use the URL address of the document library which you created in the site and Location Type as "Windows SharePoint Services" and then click OK.

Now you need a simple Excel which should do some simple canculation for our Excel services demo. Now start creating a new excel with sample data with calculation in it. And after that publish the excel using Excel services option in your Excel 2007.

SharePoint publishes your workbook into the document library. If you browse to this document from IE, you'll see an Excel-like generated interface. This Excel service that allows you to publish your Excel documents to a server library and let users run them successfully.

MOSS 2007: OnLick A Link Open in Separate Window using SharePoint Designer

Open in New Window when you click a link in your sharepoint 2007. Do do this in your sharepoint 2007, first open your sharepoint site in your SharePoint Designer as follows.

And just go to the code view and simply add target="_blank" to each anchor tag , that will make your sharepoint 2007 site to open the links in new window.

Enterprise Library 3.0 April 2007

Enterprise Library 3.0 April 2007

The patterns & practices group is pleased to announce the latest addition to our library of architecture and development guidance, Enterprise Library 3.0

This deliverable is available on MSDN at:
http://msdn.microsoft.com/entlib

Download Enterprise Library 3.0 – April 2007

Windows Workflow Foundation Web Workflow Approvals Starter Kit released

Windows Workflow Foundation Web Workflow Approvals Starter Kit, A starter kit web application that includes task oriented workflow using Windows Workflow Foundation as beeb released my microsoft on 4/6/2007.

Windows Workflow Foundation Web Workflow Approvals Starter Kit, April 2007

Disable Custom Error Message in SharePoint 2007

Disable Custom Error Message in SharePoint 2007. To see the call stack when an error occurs in the sharepoint, instead of being redirected to the error page which as the custom user friendly error messages in sharepoint 2007.

1) First open the web.config file for your site, which will be located InetPub folder.
2) In the web.config file, search for the tag, in the tag, locate the tag and change it to CallStack="true".
3) In the web.config file, search for the tag, within the tag, locate the tag and change it to
4) And save the changes in the web.config file and close.

Now whenever the error occurs in the site it will display the original error message and not the custom error messages of the SharePoint 2007.

Adding Users in MOSS 2007 after Forms Authentication is enabled

How to add Users to MOSS 2007 after Forms Authentication is enabled

After enabling forms authentication in your MOSS 2007 site you can add user from your SQL database as a Administrator alone. For other users to access your site you need to do some small change in your machine.config file located at

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG

By default your machine.config file as the following connection string which is pointing to SQL express database.

<connectionStrings> <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=DataDirectoryaspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /> </connectionStrings>

change this connection string to your SQL database connection string which you already using for your forms authentication your MOSS 2007 site.

for example i'm using

<connectionStrings> <clear /> <add name="LocalSqlServer" connectionString="Server=SERVERNAME;Integrated Security=SSPI;Database=aspnetdb;" providerName="System.Data.SqlClient" /> </connectionStrings>

Now this will connect to your profile database which is used for Forms authentication in MOSS 2007.

And now to over come the following error

Go back to site Error: Access Denied
Current User You are currently signed in as:

Open your central administrator of your MOSS 2007 and select the Application Management tab. Under the Application Security select Policy for Web application after selecting just click on the add user button and proceed through the navigation and Choose Users you want to add and set rights for them in the process.

Another way is login with your site administrator. select Site Actions, then Site Settings, then People And Groups. Select the New button to add a user to the site. This will also works.

MOSS 2007 'no match found' when trying to add users from sqlmembership database as Administrators

'no match found' problem in MOSS 2007:

After enabling your Form Authentication using SQL Membership Provider, when you try to add users using Site collection administrators under the SharePoint Site Management inside Application Management of your Central administrator you will get 'no match found'. To resolve this problem.

Root through the path C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG and open your machine.config and get the membership and role provider details under your system.web tag.

<system.web>
<processModel autoConfig="true" />
<httpHandlers />
<membership>
<providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</profile>
<roleManager>
<providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
</system.web>

Use your machine.config membership, roleManager and other details in your central administrator and your web site's web.config.

Then your 'no match found' problem will be solved and you will get the perfect result like this...

MOSS Form Authentication -- EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'

When enabled form authentication in my MOSS 2007 i'm getting "EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'"

Later exploring the problem and found the solution. By executing the following SQL commands will solve the problem.

USE aspnetdb
GO
sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'

“Network Service” is your user name.

Forms Authentication with WSS 3.0 the best source i found in web...

Forms Authentication with WSS 3.0 the best source i found in web...
http://channel9.msdn.com/ShowPost.aspx?PostID=229709

Run the Video in this link and you will get the perfect solution for Forma Authentication for MOSS 2007.

Adding to the above:
http://meiyinglim.blogspot.com/2006/07/implementing-forms-authentication-in.html

Problem while enabling Form Authentication in MOSS 2007

While enabling the form authentication in MOSS 2007 i was facing this problem.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

This is because the Application Services Database for SQL Server is not configured in your Database in which you want to enable the form authentication. Run the Aspnet_regsql.exe your configuration problem will be solved. For more about the Aspnet_regsql.exe refer

http://msdn2.microsoft.com/en-us/library/x28wfk74.aspx

Joined the Elite Members Club - MVP

Finally this week i got my Microsoft MVP for Visual Developer - ASP/ASP.NET