Monday, April 2, 2012

How to install the updates required for MS CRM 2011, MS CRM 4.0

Sometimes when installing the MS CRM(2011 or 4.0), this needs some updates and its recommened by MS, as attached in the image.

So if the serever is not connected to Internet, then it could not be updated.
Sometimes the installation passed succesfully and installed MS CRM.
But sometimes some weired errors will come.
I will share this in my next blog.

So to get the updates, we can use the config files and the start the installation in the command prompt.
the list of the updates required for Server,srsConnector,email router are as folllows
The following URLS are for x86-based platforms:
The following URLs are for x64-based platforms:
while downloading the above make sure about your version of OS 64 or 32
config file for server and command
save the below file in Server_Config.xml
  <Patch update="true">D://Server_amd64_ENU.msp(downloaded from 1st link)</Patch>
SetupServer.exe  /CONFIG folderpath\Server_Config.xml

like this the other two can be set up for srsConnector and the email Router
save the below file in SrsConnector_Config.xml
<Patch update="true">D://SRS_ENU_amd64.msp(downloaded from 1st link)</Patch>
SetupSrsDataConnector.exe /CONFIG folderpath\SrsConnector_Config.xml

Exchange Router
save the below file in SrsConnector_Config.xml
<Patch update="true">D://SRS_ENU_amd64.msp(downloaded from 1st link)</Patch>
Setupexchange.exe /CONFIG folderpath\SrsConnector_Config.xml

hope this helps...


Tuesday, March 27, 2012

Exception Details: System.Data.SqlClient.SqlException: Login failed for user

this is an error i got while doing DB connection in C# .
i was wondering if my connectionstring is not correct.. but that was correct...
connection string is "connectionString="Data Source=<serverName>;Database=<DBName>;User ID=<Username>;pwd=<password>;""
what i found is, things should be as follows...
1st of all the user should have teh credentials of SQL Authentication.
and next the DB instance should be of mixed security mode...
if its only Windows Authentication, and you have created the above user in SQL Authentication, then it will throw the same error...
so to make the server in moxed mode login to the server with SQL Admin credential and right click on the server name and click properties...
then got to the "Security" link and select the "SQL Server and Windows Authentication Mode"
then restart the server and try..
this should work...


Unrecognized attribute ‘targetFramework’ when deploying 4.0

after hosting a site in IIS 7.0 , while accessing any server pages, i got the below error..
"Unrecognized attribute ‘targetFramework’ when deploying 4.0"

is most likely because of either of 2 reasons:

1. You installed the .net 4.0 bits after IIS was set up, resulting in the wrong version of the .NET framework beeing registered with IIS.

Most often the above results in conflicting versions of the framework, and so the easiest way of solving this is to re-register the .NET extensions with IIS using the aspnet_regiss tool. Make sure you run it from an elevated command prompt and that you use the correct version (in the v4.xx folder that is, not the v2.xx one). On my dev machine this tool is located in:
and you run it with the -iru flags like so:
aspnet_regiis.exe -iru
then just restart the IIS if possible.

2. You haven’t set the framework of the IIS application to the correct version of .NET (4.0 that is)

Change this using either the IIS(7.) Manager or the command line. In IIS Manager you select ‘Application Pools’, just double click and you will get a pop up as in the image and change as per the highlighted one in the image.

Hope this helps...


Monday, March 26, 2012

asp dot net multiline textbox maxlength not working

in the maxlength attribute does not work, if the textbox is multiline.
<asp:TextBox ID="txtEvent" runat="server" MaxLength="500" TextMode="MultiLine"
                        Width="783px" Height="64px"></asp:TextBox>
if its not multiline the maxlength works properly...
this is a known issue and every body shouts...
so the work around is nothing other than the big Javascript.
so do as follows...

<asp:TextBox ID="txtEvent" runat="server" MaxLength="500" TextMode="MultiLine"
                        Width="783px" Height="64px" onKeyUp="Count(this,500);" onChange="Count(this,500);"></asp:TextBox>

The Javascript is

//check the length of the textbox(multiline)
        function Count(text, long) {
            var maxlength = new Number(long); // Change number to your max length.
            if (text.value.length > maxlength) {
                text.value = text.value.substring(0, maxlength);
                alert(" Maximum " + long + " characters allowed.");

hope this helps...

Tuesday, January 3, 2012

Export contacts from Outlook 2010

You can export contacts to a file that can then be imported into other applications, such as Web mail clients, Excel spreadsheets, or database applications.
The most common export file format is a comma separated value (CSV) file. If you are exporting contacts for use in another copy of Outlook, we recommend that you choose an Outlook Data File (.pst) in step 6 below.
  1. Click the File tab.
  2. Click Options.
  3. Click Advanced.
Advanced command in the Outlook Options dialog box
  1. Under Export, click Export.
Export command in the Backstage view
  1. In the Import and Export Wizard, click Export to a file, and then click Next.
  2. Under Create a file of type, click the type of export that you want, and then click Next.
The most common is Comma Separated Values (Windows), also known as a CSV file.
  1. Under Select folder to export from, select the contact folder that you want to export, and then click Next.
 Note    Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time.
  1. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
  2. Click OK.
  3. In the Export to a File dialog box, click Next.
  4. Click Finish.