OBCM SP3 problem connecting to database now help

[AZ]

i installed SP3 for OBCM and now i can not connect to my database now.

It's been working just fine until the update and the way i have the database
setup is on an sql server on a remote machine in my lan.

So i have the following:
client machine with OBCM
server machine with OBCM MSBusinessContactManager database

and now i get the following message upon starting outlook:
the database server on computer <servername> is inaccessible. confirm that
the remo machine has business contact manager for outlook installed, that it
is running, and that shared databases are available at that location.
Firewall settings on the remote machine could also be blocking access.

And i know the following:
- no firewall on my remote server machine hosting the OBCM database
- i can connect to the database using a sql server enterprise utility
through the client machine
- i am not able to connect using the following command:
osql -E -S <servername>\microsoftsmbiz,56183
- the OBCM databse onthe server is named MSBusinessContactManager and has
been working fine until the SP3 update of OBCM

anybody have any ideas why this has happened?

thanks!
alex

 

[AZ]

doesnt nobody have any ideas as to why this might be happening

 

[AZ]

not sure how this was working before the SP3 update but all i had to do is
change the port for tcp/ip on the server to listen on 56183 and it worked no
problems again

very wierd

 

[Bunster147]

Alex, I am having the same problem connecting to the shared database but not
being a "techy" can you tell me how you fixed the problem, i.e. what do I
need to do to listen to port 56183.

Many Thanks

 

[FragHunter]

Well let me try to help you.

you have installed an SQL Server right?
If yes you have to make configurations at:

SQL Server COnfiguration Manager

and change the Standard SQL Ports to the new BCM SQL Ports...

 

[Bunster147]

Thanks for the information. It turned out to be a Windows Firewall problem,
so I opened up the 56183 port to the two other PCs in my office and bingo, it
works a treat.
Thanks for all of your help.

 

[Stewart F]

I have managed to set the dynamic ip to port 56183 and can connect to the sql
server using the osql -E -S <servername>\mssqlserver,56183 command, but when
configuring BCM to select the appropriate database, BCM returns back with the
following error when I hit the Connect button...

Cannot access the database server on computer <servername>.

Any suggestions?
Thanks, Stewart