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