Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

Troubleshooting: Error while instaling SprinxCRM

Problem

?xml version="1.0" encoding="utf-16"?>
<ErrorDetail xmlns:s="http://webservices.sprinx.com/ErrorService/Service.asmx">
<Attachments>
<Attachment>
<s:Name>Installation Data</s:Name>
<s:ContentType>text/xml</s:ContentType>
<s:Content>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTE2Ij8+DQo8SW5zdGFsbEF0dGF

jaG1lbnQgeG1sbnM6eHNpPSJodHRwOi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYS1pbnN0YW5jZSIge

G1sbnM6eHNkPSJodHRwOi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYSI+DQogIDxDb21tYW5kTmFtZT

5TcWxFeGVjPC9Db21tYW5kTmFtZT4NCjwvSW5zdGFsbEF0dGFjaG1lbnQ+</s:Content>
</Attachment>
</Attachments>
<Message>CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CRMSprinxStart.mdf' because it already exists. Change the file path or the file name, and retry the operation.</Message>
<MessageDetails>CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CRMSprinxStart.mdf' because it already exists. Change the file path or the file name, and retry the operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Sprinx.Crm.Deploy.Install.SqlExecTool.SqlExecute.&lt;&gt;c__DisplayClass8.&lt;Execute&gt;b__2() in C:\VSSPROJECTS\CRM 2.0\Main\Source\Sprinx.CRM.Deploy\Sprinx.CRM.Deploy.Install\SqlExecTool\SqlExecute.cs:line 123
at Sprinx.Crm.Deploy.Install.SqlExecTool.SqlExecute.SafeContext(SomeAction action) in C:\VSSPROJECTS\CRM 2.0\Main\Source\Sprinx.CRM.Deploy\Sprinx.CRM.Deploy.Install\SqlExecTool\SqlExecute.cs:line 45
HelpLink.ProdName=Microsoft SQL Server
HelpLink.ProdVer=09.00.3042
HelpLink.EvtSrc=MSSQLServer
HelpLink.EvtID=1802
HelpLink.BaseHelpUrl=http://go.microsoft.com/fwlink
HelpLink.LinkId=20476
SQLPATH=C:\Program Files\Sprinx Systems\Sprinx CRM\Install\createdb.sql
CONNSTRING=Data Source=.\CRMSprinxStart;Integrated Security=false;Initial Catalog=master;Uid=sa;Pwd=CRM1@FAKIT
LINENUMBER=22
</MessageDetails>
<SystemInfo>
<s:VersionString>Microsoft Windows NT 5.1.2600 Service Pack 3</s:VersionString>
<s:SQLServer>09.00.3042</s:SQLServer>

Cause

There can be an error during installation of Sprinx CRM, when previous version wasn't removed correctly.

Solution

You can solve this problem by manualy deleting files in directory: (standard)

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CRMSprinxStart.mdf.
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CRMSprinxStart_log.ldf

If the error details show any other file, you should delete that file. Then you can run the installation again and everything should be alright.

Article ID: 42, Created On: 10/14/2011, Modified: 10/14/2011