Someone succeed installing BCM DB on SQL Server 2005 ???????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre D. - 28 Mar 2007 02:14 GMT

Hi,

As many people I try to follow the guidelines describe in the "famous"
document to create the BCM database within my SQL Server 2005.
I thought I haven't made mistake but no way to connect to the BCM database I
create following the document . I can connect with my applications to my SQL
server ... but can't connect with Outlook/Bcm 2007.
I can also connect to SQL using "management studio" using "Windows
authantication" and so the username used by BCM.
I can see the db.

So what's the problem ?
Is some one succeed doing it ?

Any guidelines to understand what's happening with BCM ?

Some help from Microsoft ?

Hope guys will come with solution, for me and others !, as I'm completly
stuck and really need a "crm solution".

Thanks thanks and THANKS !!!

Pierre

Reply to this Message

Dsparks - 28 Mar 2007 19:04 GMT

I have succeeded the install. I learned some things that are mentioned in the
document but not blatantly obvious. Here's where one of your problems might
lie:

A) You need to create a new instance of SQL. I tried to build the database
within my current instance but I was unable to connect - the next point
answers why.
B) You NEED to change the port the SQL instance listens on to 5356. You will
not connect otherwise. BCM and Accounting use this port specifically and I
cannot find where to change it (yet).
C) You need to name the instance MSSMLBIZ if you want to use MS Accounting
2007 also because I do not think you can specify the instance name. If you
can, then ignore this point.

After making sure of the above three, I followed the steps as listed and
connected instantly.

-Dave

> Hi,
>
[quoted text clipped - 20 lines]
>
> Pierre

Reply to this Message

Nanjuan Shi (MSFT) - 28 Mar 2007 21:46 GMT

Hi,
Can you check the following things?

1. As the reply above mentions, what is the name of the sql instance
that this server database is located in? If it is not 'MSSMLBIZ', when you
try to connect to that database in BCM, can you type
"ServerName\InstanceName" than just
"ServerName"?

2. And if the above still won't work, you may want to find out what tcp
port is opened for that sql instance. The port number is shown in SQL Server
2005 -> configuration manager -> Sql Server 2005 Network Configuration ->
TCP/IP property. If 'IPAll\TCP Port' property is set to a port other than
'5356', you can try typing 'ServerName\InstanceName,portNumber' when
connecting from bcm.

Thanks.

> Hi,
>
[quoted text clipped - 20 lines]
>
> Pierre

Reply to this Message

Pierre D. - 07 May 2007 20:59 GMT

Hi,

I finally succeed after changing the registry key of eCRM from MSSMLBIZ (for
default instance) to the instance name of my SQL server 2005.
After that, I had the possibility to connect to the server (SQL 2005) and
connect to the DB with BCM and share the DB.

I connect with client without problem.

Since that ... I re-install my server (Longhorn beta 3) and had some problem
with a lock file (see other post). After removing the file, I install without
problem and share the DB.

I can connect to my SQL 2005 from client with applications and with SQL
studio. I see the BCM DB I create on the server and I shared.

Problem ? YES ... I can't connect from cllient !!
It is really a nightmare to have BCM working if you don't know exactly what
to do and what to change.

I have no idea what's happening now.

Any help ?

Many thanks

Pierre

> Hi,
> Can you check the following things?
[quoted text clipped - 38 lines]
> >
> > Pierre

Reply to this Message

Nanjuan(MSFT) - 17 May 2007 19:26 GMT

Hi,
Please refer to http://blogs.msdn.com/bcm/ there are a list of
troubleshootings for sharing issues. Hope it helps.

> Hi,
>
[quoted text clipped - 66 lines]
> > >
> > > Pierre

Reply to this Message