• User gets logon prompt when accessing Microsoft Dynamics CRM folders in Outlook

    You are prompted multiple times for the user name and for the password when you start Outlook or when you click any of the Microsoft Dynamics CRM folders in Outlook. This happens the first time the user accessec Microsoft CRM in every Windows user session.

    The solution is here:

    http://support.microsoft.com/kb/934243

  • Reports not working in Microsoft CRM

    When you try to open the Reports folder in Microsoft CRM you get the error:

    Error An error has occurred. For more information, contact your system administrator.

    This happens sometimes if you have separated CRM, SQL and reporting Services

    This hapaned on a clientcomputer with Windows 2000. The solution was to enable Integrated Windows Authentication in Internet Explorer under “Internet Options – Advanced – Security Section”

    Links

    http://microsoftdynamicscrm.blogspot.com/2007/11/error-message-when-you-try-to-access.html
    http://www.microsoft.com/downloads/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&DisplayLang=en

  • Problems with Managemnet Studio on x64 SQL 2005 server

    I had a problem today with editing maintenance plans in Management Studio 2005 on a server with Windows Server 2003 x64.

    The error I get is:

    Cannot show the editor for this task.
    Additional information:
    Exception from HRESULT:  0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

    The solution I found was this:

    %windir%syswow64regsvr32 “%ProgramFiles(x86)%Microsoft SQL Server90dtsbinndts.dll” 

    Source:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=609326&SiteID=1

  • SQL Server Tips and Tricks for non-DBAs

    I have collected some Good-To-Know-Things here and will add more as time goes by…

    Cleaning up backups in SQL 2005

    In SQL pre 2005 you could set up a backup job to delete backupfiles older than X number of days (see picture). This feature has been removed in SQL 2005.
     

    If you want to do the same thing in SQL 2005 you do the following:

    1. Goto the maintenance plan that does the backup
    2. Rightclick and select Modify
    3. Drag and drop a Maintenance Cleanup Task and connect it after the last task
    4. Edit the task
    5. Specify the Path to the backup files, the extension och the files and the number of days you want to keep the backups
    6. Click OK to save the job

    Adding more memory to a SQL Server

    1. Start Management Studio
    2. Open properties for the server
    3. Go to memory and change minimum and maximum memory
    4. Reboot the server

    Change the default path for databases and logs

    1. In management studio, right click on the server and select properties.
    2. Goto database Settings
    3. Change Database and Log paths

  • Reports in Microsoft CRM not working

    I just set up a Microsoft CRM server for a customer. After one of our developers had set up the Biztalk connection (and changed some settings in IIS to work with his web service 🙁 ) the reports in MS CRM did not work anymore.

    When I tried to connect directly to the ReportingServices virtual directory I got the message:

    Unable to generate a temporary class (result=1). error CS2001: Source file ‘C:WINDOWSTEMP9a1mhqzb.0.cs’ could not be found error CS2008: No inputs specified

    I tried to look at the permissions on C:WindowsTEMP but they seemed OK. Just for troubleshooting purposes I added Everyone Full Control to the folder.

    The error message changed to:

    “The report server is not responding. Verify that the report server is running and can be accessed from this computer.”

    I checked the SQL Reporting Services Service but it was running. Then I got a tip on a MS SQL tool called RS Config Tool (rsconfigtool.exe) which is installed with MS SQL 2005. When I ran this gave me an error in “Web Services Identity” which ment that the ASP.NET services was not running as the correct user. It seemed the the developer had changed it to IWAM_Computername instead of NETWORK SERVICE.

    To change this I went into IIS Manager under Application Pools. Righitclick on Default Application Pool and ReportServer, goto the tab Identity and change it to NETWORK SERVICE

    Links:

    Error CS2001 & CS2008
    Change the account that ASP.NET runs under

  • Installation av Microsoft CRM Server 3.0

    Installation av Microsoft CRM Server 3.0

    (Detta Àr en editerad version av postningen den 22/5 2006)

    FörutsÀttning: Microsoft CRM installeras i detta fall pÄ samma server som Microsoft SQL. Allt installeras pÄ en Windows Server 2003 SP2.

    Installera IIS med följande komponenter:
     – ASP.NET
     – WWW Publishing Service
     – SMTP Service

    Installera SQL Server 2005 (Jag installerades SP0. Har inte kunna testa med SP1 och SP2.)
     – SQL Server Database Service
     – Reporting Services (kan installeras av CRM om du anvĂ€nder SQL 2000)
     – Windows Authentication Mode
     – Finnish Swedish

    Skapa AnvÀndare mm i AD
     – Skapa OU Microsoft CRM
     – Skapa AnvĂ€ndare CRMAdmin (Domain Admin under installationen)
     – CRM Mail – Vanligt konto med mailbox (Mailrouter till Exchange)
     – Skapa DNS Pekare CRM till servern
     – Verifiera Full-Text Searching i SQL Enterprise Manager
     – Starta Indexing Service och sĂ€tt automatisk
     – Starta SQL Agent och sĂ€tt automatisk

    Installera Microsoft CRM som CRM Admin

    CD Key finns pĂ„ CDKit. om du inte hunnit fĂ„ detta kan du anvĂ€nda en utvĂ€rderingsnyckel (se nedan). Denna kan bytas mot den riktiga nyckeln inom 90 dagar.

      Create New Website
     – Ange Exchange Server (endast vid mailintegration)
     
     – Koppla upp http://localhost:5555

    Installera Microsoft CRM Rollup 1

    Edit: Jag installerade SQL SP1 i efterhand och det verkar fungera

    OBS Plocka inte bort den website som lÀggs upp av installation och Àndra inte port OBS

    Post Install Tasks

    Microsoft CRM

    Verifiera att AD grupperna (PrivUserGroup, SQL Access Group, Reporting Group och UserGroup) har skapats.

    LĂ€gg Microsoft CRM Service, IIS Service Account och SQL Server Service Account konton i “Pre-Windows 2000 Compatible” sĂ€kerhetsgruppen.

    Registrera CRM installationen inom 30 dagar

    Skapa ett nytt adminkonto i MS CRM. Kryssa i restricted access för detta konto. Kryssa ur Restricted access för CRMAdmin

    Reporting Services

    (Om CRM körs pÄ samma server som MS SQL 2005) Byt Application Pool pÄ den virtuella katalogen reports till Default Application Pool.

    Kopiera mscrm.css, mscrmx.css, mscrmp.css, mscrmxp.css frÄn wwwrootCRMReportsrsstyles pÄ MSCRM Installationsskivan till c:ProgramFilesMicrosoftSQL ServerMSSQLReportingServicesReportServerstyles

    Ändra rĂ€ttigheter pĂ„ ovanstĂ„ende filer: LĂ€gg till UserGroup Read

    Verifiera Reporting Services genom att öppna Workplace, under My Work, klicka Reports och vÀlj User Summary

    GĂ„ till Microsoft KB Artikel om Backup
    Microsoft CRM Implementation Guide – Planning the Backup and Restoration of the Microsoft CRM System

    Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available
    Update Rollup 1 for Microsoft Dynamics CRM 3.0 (KB922815)

    Tidbits on MS CRM

    Microsoft CRM 3.0: 90-Day Trial Versions

  • Find out which SP you have on your SQL Server

    From query analyzer run select serverproperty(‘productlevel’)

    Thanks Henk

  • DS_E_INVALID_ATTRIBUTE_SYNTAX when trying to edit Distribution Lists

    Q: I get an error DS_E_INVALID_ATTRIBUTE_SYNTAX when I try to edit a Distribution List in Exchange 5.5 (don’t know if this applies to 2000 och 2003)

    A: Try changing the DL Expansion Server in Exchnage System Administrator. Open Properties for the Distribution List and change Expansion Server on the General Tab.

  • Unable to add SQL Server ODBC DSN

    If you are unable to add a new SQL Server DSN in Datasources it is probably due to a missing or corrupt sqlsrv32.rll file in c:windowssystem32.

    Extract a new one from MDAC (the version you are currently using) with mdac_typ.exe /C /T:C:destination and copy the file to c:windowssystem32

    This has also been known to stop Axapta from starting.