Mostafa Elzoghbi - C# MVP

How to build your DB on MS SQL Azure

2009-12-11T19:59:00.004+03:00

Hi Folks,

I would like to share with you some tips for how to move your on-premise DB to MS SQL Azure on the cloud.

First, To be able to connect to SQL Azure Prepare your environment with the following:

1) Install MS SQL 2008 R2 on your machine - Nov CTP, having any other version of SQL 2008 will not give you the full functionality like working with object browser in SQL Server 2008 R2.

Tips :

a) Before installing SQL 2008 R2, please check your exisiting environment by using SQL Server upgrade advisor (it is a part of SQL 2008 R2).

b) Using your credientials in SQL Azure, you will be able to connect using SQL 2008 R2 with no issues and you will be able to navigate through your objects in the DB.

1) How to move your on premise Database to SQL Azure on the cloud:

1) Script your DB from your server.
2) There is some changes you have to do it on the script before executing it on the SQL Azure DB.

Tip: 1) Remove any reference to the file group such as : ON [PRIMARY] on your script.

Then when you remove the reference, you will be able to execute the script using SQL Management Studio and when you refresh the server you will be able to see your new created objects.

Hope this helps.

Regards,
Mostafa arafa @ Azure Cloud......

Cannot open a closed file error in asp.net ajax / SharePoint Site

2009-12-09T00:44:00.006+03:00

Hi Folks,

I was developing a webpart in sharepoint ( consider it as a asp.net usercontrol for ASP.Net Developers) and in the webpart i was uploading a document using AsyncFileUpload control in AJAX Toolkit.

And it was working fine, but for some files i was getting this error : "Cannot open a closed file" and i was thinking that the problem from the file or it is a code behind issue.

I figure out the problem was because of the file size threshold in the web.config, the default web.config is:

<httpruntime maxrequestlength="51200" />

I added this attribute:

<httpruntime maxrequestlength="51200" requestLengthDiskThreshold="4096" />

The resolution for the problem is: Set the length disk threshold to 4M ( or any other number in KB as per your application business rule) because by default the value is 80K.

Hope this helps.

Happy SharePointing.... or .Netting :)

Regards,
Mostafa arafa

SharePoint Error : Retrieving the COM class factory for component with CLSID {BDEADEE2-C265-11D0-BCED-00A0C90AB50F} failed

2009-12-08T17:18:00.002+03:00

Hi,

If you are trying to open your sharepoint 2007 site one day and you got this error message with yellow asp.net page:

"Retrieving the COM class factory for component with CLSID {BDEADEE2-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa."

The fix for this problem is to do iisreset for your IIS webserver and this will resolve the error.

Hope this helps.

Regards,
Mostafa arafa

Installing SharePoint 2010 on Windows 7 Tip

2009-12-07T18:01:00.003+03:00

If you are planning to install sharepoint 2010 on Windows 7, here is an excellent article in MSDN, just follow the steps and you will end up successfully installing SharePoint 2010 beta on windows 7.

http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

My Tip is: even if you follow the steps, and run the SharePoint Configuration wizard, the wizard might be failed , what you have to do is just to re-run it and it is going to work. the problem for that when you run in low of memory and the exception is saying failed provisioning central administration website.

Thanks.

Regards,
Mostafa arafa

Installing SharePoint 2010

2009-12-02T17:36:00.005+03:00

Hi Folks,

I'd like to share with all of you how to install SharePoint 2010 on your current platform and to remove any dilemma or milestones you might face or heard from others.

First Question : How can i install SharePoint 2010 on my 32 bit machine ?
Now, you can use either VM Ware Workstation (requires License) or Virtual Box (Free).
Till Today, MS Virtual PC doesn't support to build your 64 bit machine on a your host 32 bit machine.

Now, you don't have any problem to build a VM using either of these software.

I used Virtual Box, and this is my first experience with it, easy and you can use your experience with VPC with it.

[Updated 6/12/09]: VMWare Server is also free, you can try it and its performance is better than Virtual Box.

Once you build and start your VM, here is the steps you have to do:
1- Mount your Windows 2008 R2 64 bit to your VM software.
2- After installing Windows, Install all the updates before start installing the SharePoint 2010.

3- I Prefer to install Office 2010 before installing SharePoint 2010 since you are going to use it with SharePoint.

4- Run Your SharePoint installer and click on install your software prerequisities, this step will go with no errors as mentioned on other posts.

5- The installer will prompt you to run SharePoint Products and configuration wizard, At the end, you will get a failure message : "Failed to create sample data".
FYI: SharePoint is working without installing the hotfix, To download the hotfix:

http://blogs.msdn.com/sharepoint/archive/2009/11/19/installation-notice-for-the-sharepoint-server-public-beta-on-microsoft-windows-server-2008-r2-and-microsoft-windows-7.aspx

After installing the hotfix, restart the machine and run the SharePoint configuration wizard again to fix un-provisioned services-WCF.

** Some Other Error cases - Differ from one installation to another:

a) If you got this error :"failed to register sharepoint services", open stsadm tool and type this command:

stsadm -o spsearch -action stop

Then re-run the configuration wizard.

b) If you get this error message :"failed to register sharepoint services- search service" - step 5 in the configuration wizard.

Open the command prompt and type : regedit and navigate to the following key and delete it:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web ServerExtensions\14.0\WSS\Services\Microsoft.SharePoint. Search.Administration.SPSearchService

6- Done, Start exploring your sharepoint 2010 instance.

Hope this helps.

Mostafa Arafa
Twitter : @mostafaelzoghbi

The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

2009-12-01T19:43:00.003+03:00

Hi,

"The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again." This error message in sharepoint 2007 you will get it because of different actions you may perform on the site level:

-If you are trying to check out a document in Document library.
-If you are trying to add some columns in a custom list in sharepoint.
-If you are trying to call update() method in the object mode.
-And other actions....

The reason behind this error is when you enable anonymous access to a site with other authentication method such as basic authentication.

The solution or workaround for this problem is to open the central admin, then :
- Select application management.
- Under SharePoint Web Application Management, select Web Application general settings.
- Select your web application first.
- Under web page security validation turn it off.
- Reset your IIS.

Hope this helps.

Regards,
Mostafa arafa

My Interview in Microsoft Feed Website

2009-11-25T09:59:00.002+03:00

I'd like to share with all my blog readers this article, it is my interview with Microsoft Feed website team.

Read it, I think it will inspire you to do more in your career and to the community.

http://microsoftfeed.com/2009/meet-mostafa-elzoghbi-visual-c-mvp-from-egypt/

Regards,
Mostafa arafa

SharePoint 2010 BETA is available now to download

2009-11-19T08:34:00.002+03:00

Hi Folks,

SharePoint 2010 BETA is now available to download for Public, download link :

http://www.microsoft.com/2010/en/

SharePoint 2010 resources:

Devs: http://msdn.microsoft.com/en-us/sharepoint/ee513147.aspx

IT Professionals: http://technet.microsoft.com/en-us/sharepoint/ee518660.aspx

Read more :

http://blogs.msdn.com/sharepoint/archive/2009/11/18/sharepoint-2010-public-beta-is-now-available-for-download.aspx

Regards,
Mostafa arafa

Bulk delete in a SharePoint custom list

2009-11-11T04:33:00.002+03:00

Hi All,

I went through an issue to bulk delete a custom list items in a sharepoint site, I found a good tool to delete all items / selected items in a custom list in sharepoint.

You can download from codeplex:

http://customlistitemsdel.codeplex.com/

Hope this helps.

Regards,
Mostafa arafa

createwsp.bat exited with code 4 error

2009-10-29T22:52:00.003+03:00

Hi All,

If you got this error while building a sharepoint solution file, this happens when the CabLib.dll which is used to build WSP SharePoint Solution files in VS.Net is a 32 bit running on a 64 bit machine.

The issue behind this is that your server is a x64 bit server, and you have to change this CabLib.dll with a 64 bit version.

You can download the updated dll from codplex:

http://www.codeplex.com/wspbuilder/Release/ProjectReleases.aspx?ReleaseId=16820

Hope this helps.

Regards,
Mostafa arafa

Performance Point Server 2007 SP3 is available

2009-10-28T03:22:00.002+03:00

Hi All,

If you are building KPIs and performance point reports using Performance Point server 2007 with SharePoint 2007. A new Service pack is available to download with all important aggregated hotfixes.

Download link and important hotfixes information:

http://support.microsoft.com/kb/975249/en-us

Hope this helps.

Regards,
Mostafa arafa

Error when trying to open XAML options in VS 2008

2009-10-20T20:21:00.002+03:00

Hi All,

After installing Silverlight 3.0 tools with VS 2008 SP1 i was not able to open XAML options in VS 2008 IDE.

I was submitted a ticket in MS Connect website, and the fix is:
1) Close all VS 2008 instances.
2) Open VS 2008 Command prompt
3) Type : devenv /resetskippkgs

This is the fix for the problem by resetting all IDE packages.

Ticket url:

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=496402

Hope it helps.

Regards,
Mostafa arafa

Session management in WCF service - client & server

2009-10-20T17:06:00.003+03:00

Hi Folks,

I got the following email from one of my blog readers, here is his email:
"
Hi.. Marafacs,
I have a problem about WCF chat based on client-server. How to make a deal between server and client? So server can send message, show active client list, kick user.
Thanks for response.
"

To do this, you have first to configure your WCF to accept only client calls with sessions, and this is can be achieved by configuring the WCF with Service Throttling and configuring MaxConcurrentCalls,MaxConcurrentInstances and MaxConcurrentSessions.

Read this section to know how to configure this - page 331:
http://books.google.com/books?id=-AUyj6S7etwC&pg=PA331&dq=how+to+get+active+sessions+in+WCF&ei=tsTdStrhKITUNc_B9IEP#v=onepage&q=&f=false

To know, how the client can generate sessions and unique identifiers to the server, check below KB article, this is related to instance context sharing:

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

Hope this helps.

Regards,
Mostafa arafa

MS Training website.... for solution providers

2009-10-16T04:59:00.002+03:00

Hi Folks,

Interesting site By Microsoft, it provides training for solution providers, what you have to do is to write your topic, then you will find your material.

I was looking for silverlight 3, here is the link:
http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=122

This is the site url, keep it in your records...

http://www.msdev.com/

Hope it helps.

Regards,
Mostafa arafa

TechEd Middle East - March 2010

2009-10-07T05:04:00.004+03:00

Hi All,

Big chance for all professionals in the middle east, TechEd Middle east in Dubai at 1 March 2010, TechEd is one of the most premier events for Microsoft in technology and networking.

"Microsoft’s premier technical education and networking conference is coming to the Middle East.
Connect one-on-one with Microsoft insiders and IT peers, get your toughest questions answered and hear expert advice - right from the source, right in your region."

http://www.TechEd.ae/

-- RSVP on Facebook:

http://www.facebook.com/event.php?eid=162414912532&ref=nf

See you there....

Regards,
Mostafa arafa

'AntiXssLibrary' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)

2009-09-30T21:39:00.002+03:00

Hi Folks,

If you got the error message from MS CRM 4.0 which is running on a VM on your test or production Hyper-V manager server, After i checked the the error message on the server, the error message which was :

"'AntiXssLibrary' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)"

Just trun off your VM, Then expand desk space allocated for the VM will fix the issue.

Hope this tip helps.

Regards,
Mostafa arafa

Access denied when try to sign your project in VS 2008

2009-09-28T22:08:00.003+03:00

Hi Folks,

If you are facing a problem that you can't sign your project using VS 2008, this is not because there is a problem in VS 2008 but this is because the User Access control (UAC) feature in Vista. The User Access Control enabled in your system, you have to disable it to enable signing to your assembly in VS 2008.

OR

If you can't publish your project using ClickOnce deployment in VS 2008 and your are getting an error message : "publish aborted, can't create a default certificate"

The cause for above 2 errors messages are because of the UAC is enabled.

To do/fix this:
1) Open Run windows in Vista: Accessories -> Run.
2) Type MSCONFIG command.
3) select tools tab, select Disable UAC and click on Luanch button.
4) Reboot your system (Important).

Once you reboot your system, open your project and you will be able to sign your assembly.

Hope it helps.

Regards,
Mostafa arafa

My first SQL azure Application on the Cloud !!!

2009-09-23T23:47:00.002+03:00

Hi Folks,

Few months ago, i worked with Azure Services, and since i'm interested to develop applications over the cloud which extensively use SQL Server as a backend, i used BLOBS to store my data... actually it wasn't that easy to use, but the product was still in beta in that time.

Recently, I have some time to develop and start using SQL Azure services, A big start by allowing us to create the Database over the website, then all other operations ( CRUD ) for the Database design and object model can be done using ADO.Net classes.

C# Code for connecting and creating a table over the cloud:

SqlConnectionStringBuilder connString2Builder;
connString2Builder = new SqlConnectionStringBuilder();
connString2Builder.DataSource = "MyServer.ctp.database.windows.net"; // check your profile to know server name.
connString2Builder.InitialCatalog = "YourDB"; // you can create your own their.
connString2Builder.Encrypt = true;
connString2Builder.TrustServerCertificate = true;
connString2Builder.UserID = "myUserName";
connString2Builder.Password = "myPassword";

// Connect to the sample database and perform various operations
using (SqlConnection conn = new SqlConnection(connString2Builder.ToString()))
{
using (SqlCommand command = conn.CreateCommand())
{
conn.Open();

// Create a table
command.CommandText = "CREATE TABLE MostafaTable(Col1 int primary key, Col2 varchar(20))";
command.ExecuteNonQuery();

// Insert sample records
command.CommandText = "INSERT INTO MostafaTable(col1, col2) values (1, 'string 1'), (2, 'string 2'), (3, 'string 3')";
int rowsAdded = command.ExecuteNonQuery();

// Query the table and print the results
command.CommandText = "SELECT * FROM MostafaTable";

using (SqlDataReader reader = command.ExecuteReader())
{
// Loop over the results
while (reader.Read())
{
Console.WriteLine("Col1: {0}, Col2: {1}",
reader["Col1"].ToString().Trim(),
reader["Col2"].ToString().Trim());
}
}
}
}

-- To read more about SQL Azure services:
http://msdn.microsoft.com/en-us/library/ee336279.aspx

-- SQL Azure Forums:
http://social.msdn.microsoft.com/forums/en-US/ssdsgetstarted/threads/

Hope it helps.

Regards,
Mostafa arafa

SortedSet new collection type in .Net 4.0 beta 1

2009-09-18T16:46:00.008+03:00

Hi folks,

This post based on my readings in .Net 4.0 beta 1, one of the new enhancements in .Net 4.0 is SortedSet<T> collection type, which implements red-black sorting algorithm with complexity O(log n) for the entire list.

Red-Black tree is an efficient sorting algorithm and using this collection will help alot from performance of sorting large sets in the run time.

C# code:

var mySet=new SortedSet <int>() {3,2,7,23,12,879,345,122,98};
foreach(int x in mySet)
{
Console.WriteLine(x);
}

// output: sorted list.

To read more about .Net 4.0 enhancements, kindly check below links:

http://blogs.msdn.com/bclteam/archive/2009/05/22/what-s-new-in-the-bcl-in-net-4-beta-1-justin-van-patten.aspx

http://msdn.microsoft.com/en-us/netframework/dd819232.aspx

Hope this helps.

Regards,
Mostafa arafa

CRM 4.0 Integration with your business applications/products

2009-09-12T09:31:00.002+03:00

Hi Folks,

MS Dynamics - CRM 4.0 is one of the recognized products for mid-size, large customers for customers' relationship management products in the market.

If you have a CRM 4.0 in your company, you might want to integrate CRM Data with other business applications. The way to do this is to use MS Biztalk server which comes now with a CRM 4.0 Adapter.

This means that you can make use of CRM schema and Data using Biztalk 2006/2009 in your business applications or other products using this new released CRM adapter in Biztalk.

To download and start integrating with CRM 4.0, this is the download link and some useful documents to wotk with Biztalk CRM Adapter.

http://www.microsoft.com/downloads/details.aspx?FamilyID=ABD3BB9E-A59A-4EB6-8DE8-FB25B77926D7&displaylang=en

Hope this helps.

Regards,
Mostafa arafa

Code for the power of Windows 7

2009-09-06T10:49:00.002+03:00

Hi All,

Do you want to develop for the power of windows 7 ? Do you want to earn money for the submission you will do ? Competition is full of challenge and prizes.... deadline for registration is end of 10th october, Register now :

https://www.code7contest.com/

Start today with Windows 7 development.

Regards,
Mostafa arafa

"an item with the same key has already been added" on CRM 4.0

2009-09-04T23:57:00.002+03:00

Hi Folks,

If you are experiencing this error on your CRM 4.0 instance, this means that your CRM 4.0 needs a hotfix to fix this problem.

The hotfix KB article:
http://support.microsoft.com/default.aspx/kb/949256

The error # : 951849

Hope it helps.

Regards,
Mostafa arafa

Add external sites to Sharepoint Search

2009-08-25T21:47:00.003+03:00

Hi Folks,

One of the most imoportant features in sharepoint 2007 is the enterprise search. Enabling search for extenral sites are extermely needed in any organization specially if the organization has other sites hosted on other platforms other than sharepoint sites.

To implement this, First make sure that crawling services configuration are set properly on your sharepoint "SharedServices" assigned to your site that you are working on.

From Central Administration:
- Select SharedServices.
- Select crawl rules.
- click on new crawl rule.
- set the url of your site, select include all items in this path.

Then click ok, wait till the next crawl service will run or run it manually, then you will get search results.

Hope this helps.

Regards,
Mostafa arafa

Exception when implement function overloading in WCF

2009-08-21T18:12:00.003+03:00

Hi Folks,

If you tried to develop a simple WCF function, and you tried to write in your WCF 2 overloading functions in WCF, you will not be able to deploy your serivce and the clients will get an exceptions.

The solution: give Aliases to the overloaded functions in the WCF service.

Code :

public interface IMyWCFSvc
{
[OperationContract(Name="GetCustomerById")]
string GetCustomerInfo( int CustId);

[OperationContract(Name="GetCustomerByEmail")]
string GetCustomerInfo( string CustomerEmail);
}

The proxy when you reference to your serivce, will create 2 methods with the Alias names and not with the actual overloaded name in C# code.

Hope this helps.

Regards,
Mostafa arafa

Service unavailable after changing the identity for a sharepoint site

2009-08-05T18:11:00.002+03:00

Hi Folks,

If you try to change the identity for the applicaiton pool that the sharepoint site is running under, You can do this from the iis manager open identity tab and change the account for the application pool.

After you change this, you will get "Service Unavailable" error message when you try to open your sharepoint site, to fix this:

1) Make sure that you type the password for the service account which the application pool will run under correctly.

2) Make sure that the Service account is part of the following groups: IIS_WPG and STS_WPG .

3) Reset your IIS.......MOST IMPORTANT STEP.

then, you can navigate to your website.

Hope this tip helps.

KB Article:
http://support.microsoft.com/kb/823552

Regards,
Mostafa arafa