DCSIMG
December 2010 - Posts - Dudi Nissan's Blog

Dudi Nissan's Blog

SharePoint, ASP .Net, SQL

Links

SharePoint 2010 Custom Fields

December 2010 - Posts

Configuration Forms Based Authentication - FBA on SharePoint 2010

נתקלתי ב-2 מאמרים מומלצים בנושא ביצוע קונפיגורציה של Forms Based Authentication ל-SharePoint 2010:
1. באתר ה-TechNet של מיקרוסופט כאן
2. הפוסט כאן

Error occurred in deployment step 'Recycle IIS Application Pool': The communication object, System.ServiceModel.InstanceContext, cannot be used for communication because it has been Aborted

נתקלתי ב-Error הבא ב-Visual Studio 2010:
Error occurred in deployment step 'Recycle IIS Application Pool': The communication object, System.ServiceModel.InstanceContext, cannot be used for communication because it has been Aborted

פתרון
סגירה ופתיחה מחדש של Visual Studio 2010 פתרה את הבעיה.
Posted: Dec 28 2010, 10:17 PM by dudin | with no comments
תגים:,

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance

נתקלתי בהודעת השגיאה הבאה ב-SharePoint 2010:

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (c3d4bce6-e4d9-4363-ab46-e06fa2610d5d).

Reason: An update conflict has occurred, and you must re-try this action. The object SearchDataAccessServiceInstance was updated by DOMAIN/UserName, in the OWSTIMER (2348) process, on machine SERVER_NAME.  View the tracing log for more information about the conflict.


הפתרון
מאמר ב-KB מספר 939308 באתר מיקרוסופט.

Script to Stop or Start SharePoint 2010 Services

Stop SharePoint 2010 Services
net stop "IISADMIN" /y
net stop "W3SVC" /y
net stop "SPAdminV4" /y
net stop "SPTimerV4" /y
net stop "SPTraceV4" /y
net stop "SQLWriter" /y
net stop "MSSQLSERVER" /y
net stop "MSSQLServerOLAPService" /y
net stop "MsDtsServer100" /y
net stop "ReportServer" /y
net stop "OSearch14" /y

Start SharePoint 2010 Services
net start "IISADMIN" /y
net start "W3SVC" /y
net start "SPAdminV4" /y
net start "SPTimerV4" /y
net start "SPTraceV4" /y
net start "SQLWriter" /y
net start "MSSQLSERVER" /y
net start "MSSQLServerOLAPService" /y
net start "MsDtsServer100" /y
net start "ReportServer" /y
net start "OSearch14" /y

הערה: ניתן לשים בקובץ bat.

How to Configure Silverlight Business Application to use SQL Server

כאשר יוצרים פרויקט חדש מסוג Silverlight Business Application ב-Visual Studio 2010, האפליקציה מוגדרת לעבוד מול SQL Express מקומי בשרת הפיתוח.
כדי שאפליקציית ה-Silverlight תעבוד מול SQL Server, יש להוסיף לקובץ web.config הגדרה של Connection String. לדוגמא:

<connectionStrings>
   <
remove name="LocalSqlServer" />
   <
add name="LocalSqlServer"
      connectionString="Password=SQLPassword;Persist Security Info=True;
            User ID=SQLUser;Initial Catalog=DB_Name;Data Source=ServerName
"
     
providerName="System.Data.SqlClient" />
</
connectionStrings>

T-SQL: Credit Card Type

SELECT
   CASE
WHEN LEN(CreditCardNum) = 16 AND SUBSTRING(CreditCardNum, 1, 1) = 5
     
THEN 'Mater Card'

            WHEN LEN(CreditCardNum) = 16 AND
     
SUBSTRING(CreditCardNum, 1, 1) = 4 THEN 'Visa'

            WHEN LEN(CreditCardNum) = 15 AND 
      
(SUBSTRING(CreditCardNum, 1, 2) = 37 OR
     
SUBSTRING(CreditCardNum, 1, 2) = 34) THEN 'American Express'

            WHEN LEN(CreditCardNum) = 14 AND
     
(SUBSTRING(CreditCardNum, 1, 2) = 36 OR
     
SUBSTRING(CreditCardNum, 1, 2) = 38) THEN 'Diners'

            WHEN LEN(CreditCardNum) =OR
       LEN(CreditCardNum) = 9
THEN 'Isracard'

   ELSE 'N/A'
   END AS 'Credit Card Type'
FROM myTable

SharePoint 2010 Search Error: Internal server error exception

נתקלתי בהודעת השגיאה הבאה במנגנון החיפוש של SharePoint 2010:
Internal server error exception

הפתרון
בהגדרות של החיפוש, בחלק של Internal Partition ו-Query Component


שינוי של מיקום הדיסק/כונן ב-Location of Index, פתר את הבעיה

MOSS - Provisioning failed: The specified user or domain group was not found

נתקלתי ב-MOSS בהודעת השגיאה ב-Shared Services:
Provisioning failed: The specified user or domain group was not found

ניתן לראות פתרון לבעיה באתר ה-technet של מיקרוסופט כאן
הנה הפתרון כפי שנכתב באתר ה-technet של מיקרוסופט:

Reference - http://support.microsoft.com/kb/934838
cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12

1) On the server that hosts the Central Administration Web site, type the following line at the command prompt,
and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword

2) Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps:
Open SharePoint 3.0 Central Administration
click Operations, and then click Timer job definitions under Global Configuration.
Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list.

3) Update the password for the application pool account that is used by Web applications on the server farm.
stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin

4) Update the password for the account that is used to run the Windows SharePoint Services Help Search service
stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword

5) Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service
stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword

After this I was able to create SSP successfully

Posted: Dec 13 2010, 04:37 PM by dudin | with no comments
תגים:, ,

כיצד לשנות חשבונות שירות וסיסמאות חשבונות שירות ב-SharePoint Server 2007 וב-Windows SharePoint Services 3.0

http://support.microsoft.com/kb/934838
Posted: Dec 13 2010, 03:00 PM by dudin | with no comments
תגים:, ,

SharePoint 2010 - How to Add EventReceiver to List

הנה דוגמת קוד להוספת EventReceiver ל-Document Library או List של SharePoint 2010:

string SiteUrl = @http://server_name/;
Microsoft.SharePoint.
SPSite s = new Microsoft.SharePoint.SPSite(SiteUrl);
s.AllowUnsafeUpdates =
true;
s.CatchAccessDeniedException =
true;
Microsoft.SharePoint.
SPWeb w = s.OpenWeb();
w.AllowUnsafeUpdates =
true;

SPList list = w.Lists["ListName"];
Microsoft.SharePoint.
SPEventReceiverType SPEventReceiverType_ = 
                  Microsoft.SharePoint.SPEventReceiverType.ItemAdded
;

string assemblyName = "myNamseSpace, Version=1.0.0.0,
                       Culture=neutral, PublicKeyToken=..."
;
string className = "myNameSpace.myClass";
list.EventReceivers.Add(SPEventReceiverType_, assemblyName, className);

w.Dispose();
s.Dispose();


והפונקציה של ה-Event Receiver, תיראה לדוגמא כך: 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace myNameSpace
{
    public class myClass : Microsoft.SharePoint.SPItemEventReceiver
    {
        public override void ItemAdded(SPItemEventProperties properties)
        {
           // Event receiver code goes here //
           // ...
           // Event receiver code goes here //
        }
    }
}

Posted: Dec 12 2010, 12:41 PM by dudin | with no comments
תגים:, ,

Silverlight PivotViewer

Silverlight PivotViewer מאפשר להציג כמות מידע גדולה ב-Web באמצעות טכנולוגיה של Deep Zoom.


דוגמא לקישור כאן

לפני Zoom


ולאחר Zoom

Free Windows 7 E-book: Guidance on Deploying Windows 7

ניתן להוריד מאתר מיקרוסופט לאחר ביצוע Login ב-Microsoft Windows Live כאן או כאן ואז ללחוץ על Download

Posted: Dec 02 2010, 10:07 PM by dudin | with no comments
תגים:, ,

Download Microsoft Lync Server 2010

ניתן להוריד גיסרסת ניסיון ל-180 יום של שרת Microsoft Lync מאתר מיקרוסופט כאן
Posted: Dec 02 2010, 09:48 PM by dudin | with no comments
תגים:,