Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Cannot install CRM Dynamics - Falis on Database Identifier RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm facing the following error:

    The identifier that starts with '[5b59e67d48493b8af732b6e5874692];

    IF NOT EXISTS(    SELECT  1

                                                                   FROM [[5b59e67d48493b8af732b6e5874692].sys.database_principals dp1' is too long. Maximum length is 128.

    Database '[5b59e67d48493b8af732b6e5874692];

    IF NOT EXISTS(    SELECT  1

                                                                   FROM [[5b59e67d48493b8af732b6e5874692].sys.database_principals dp1' does not exist. Make sure that the name is entered correctly.

    This query was intercepted using SQL Profile. It's a query from Dynamics CRM Installation. This error only occurs on SQL 2014. In SQL 2012 the same syntax works. 

    Is there any way to workaround or solve this? I've researched through sysname datatype, quoted_identifier session parameter but haven't any answers.  In Dynamics Server installation there is no option to set ODBC, so quoted_identiifer is always set to on through Native Client.

    Best regards, 

    Rafael Cuesta

    • Moved by Kalman Toth Thursday, October 1, 2015 2:40 PM Not T-SQL
    Saturday, September 19, 2015 12:30 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Rafael,

    Please check if your query is returning proper result, Seems extra '[' is coming in query.

    [[5b59e67d48493b8af732b6e5874692].sys.database_principals dp1

    Thanks, If my reply is helpful please mark as answer or vote as helpful.

    Saturday, September 19, 2015 2:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It seems that this question is best asked in a forum for CRM Dynamics.

    I would assume that Microsoft do not ship setups with such glaring errors in general, so I would guess that the problem is that your database has a name which the Setup does not handle properly.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Saturday, September 19, 2015 6:28 PM