Tech Support > Microsoft Windows > Windows CRM > Missing MSCRMDistribution DB
Missing MSCRMDistribution DB
Posted by Need Some Help on September 7th, 2005


I installed CRM and the new organization key, everything
looks and works absolutely fine, however there are only three databases, the
companyname_MSCRMDistribution is missing.

So... Gone into Deployment Manager>Servers Manager>Configure SQL Server
which is supposed to create this database? I just get an error in the event
log:

Source: DMSNAPIN
Event ID: 0
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.


Posted by Dave Ireland on September 8th, 2005


Is SQL Replication enabled on your SQL Server? I think that if it were
enabled when you installed CRM, you would have the distribution database
already.

In SQL Enterprise Manager, left-click on the Replication Node and see if
there is an option to "Enable Replication". If so, then you need to enable
it, then redo the Deployment Manager>Servers Manager>Configure SQL Server
step from before. If you have registered your sql server as a nickname
(like "local") then you will need to re-register the server as the server
name before you can configure replication.

Dave Ireland
Salentica Systems Inc.


"Need Some Help" <Need@news.microsoft.com> wrote in message
news:%23rHZGk7sFHA.1168@TK2MSFTNGP11.phx.gbl...


Posted by Need Some Help on September 12th, 2005


Yes replication is Started .
if I go through Deployment Manager it still dont creat the DB
I get the Following Event Log Error
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.




"Dave Ireland" <direland@salentica.com> wrote in message
news:ufwzfXBtFHA.2492@tk2msftngp13.phx.gbl...


Posted by Dave Ireland on September 16th, 2005


I would open a ticket with MBS support - there appears to be something
missing from your system.

Dave

"Need Some Help" <Need@news.microsoft.com> wrote in message
news:OJv9Kj3tFHA.3068@TK2MSFTNGP14.phx.gbl...



Similar Posts