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:

• Microsoft Dynamics CRM server
  http://go.microsoft.com/fwlink/?LinkID=94937 (http://go.microsoft.com/fwlink/?LinkID=94937)
• Microsoft Dynamics CRM Connector for SQL Server Reporting Services
  http://go.microsoft.com/fwlink/?LinkID=94940 (http://go.microsoft.com/fwlink/?LinkID=94940)
• Microsoft Dynamics CRM E-mail Router
  http://go.microsoft.com/fwlink/?LinkID=94939 (http://go.microsoft.com/fwlink/?LinkID=94939)

The following URLs are for x64-based platforms:

• Microsoft Dynamics CRM server
  http://go.microsoft.com/fwlink/?LinkID=104228 (http://go.microsoft.com/fwlink/?LinkID=104228)
• Microsoft Dynamics CRM Connector for SQL Server Reporting Services
  http://go.microsoft.com/fwlink/?LinkID=104230 (http://go.microsoft.com/fwlink/?LinkID=104230)
• Microsoft Dynamics CRM E-mail Router
  http://go.microsoft.com/fwlink/?LinkID=104229

####################################################################
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
<CRMSetup>
 <Server>
  <Patch update="true">D://Server_amd64_ENU.msp(downloaded from 1st link)</Patch>
<Server>
</CRMSetup>
command
SetupServer.exe  /CONFIG folderpath\Server_Config.xml

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

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

hope this helps...

thanks,
yes.sudhanshu
ref: http://support.microsoft.com/kb/948917 

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...

thanks,
yes.sudhanshu

Unrecognized attribute ‘targetFramework’ when deploying asp.net 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 asp.net 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:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319
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...

yes.sudhanshu

asp dot net multiline textbox maxlength not working

in asp.net 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...

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.

4. Under Export, click Export.

5. In the Import and Export Wizard, click Export to a file, and then click Next.
6. 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.

7. 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.

8. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
9. Click OK.
10. In the Export to a File dialog box, click Next.
11. Click Finish.

source http://office.microsoft.com/en-us/outlook-help/export-contacts-HA101870639.aspx

thanks,

yes.sudhanshu