SQL Server 2008 & BCM

[kb9jlo]

I can't seem to get BCM to connect or even find my SQL server. Our intention
is to install BCM on a few clients and then point them to a BCM database on
our SQL Server 2008 server (running on Server 2003 R2).
I can connect to the SQL Server, the instance, even to the BCM database we
created with Excel or some other method. When I attempt to connect to it from
within Outlook I get the dreaded, "SQL Server does not exist or access is
denied" error.
It's not security - it's like it never even gets to the SQL server as you
never get to choose a DB - ever. I've looked through this forum and Googled
and searched but I'm stuck and could sure use some help.
I've looked at these KB articles: http://support.microsoft.com/kb/901164;
http://support.microsoft.com/default.aspx/kb/928166
I also thought this would help me but I still ended up with "SQL Server does
not exist or access is denied" :
http://whitepapers.techrepublic.com.com/thankyou.aspx?&docid=349630&view=349630
Thanks,
Dan

 

[Luther]

I can't seem to get BCM to connect or even find my SQL server. Our intention
is to install BCM on a few clients and then point them to a BCM database on
our SQL Server 2008 server (running on Server 2003 R2).
I can connect to the SQL Server, the instance, even to the BCM database we
created with Excel or some other method. When I attempt to connect to it from
within Outlook I get the dreaded, "SQL Server does not exist or access is
denied" error.
It's not security - it's like it never even gets to the SQL server as you
never get to choose a DB - ever. I've looked through this forum and Googled
and searched but I'm stuck and could sure use some help.
I've looked at these KB articles:http://support.microsoft.com/kb/901164;http://support.microsoft.com/default.aspx/kb/928166
I also thought this would help me but I still ended up with "SQL Server does
not exist or access is denied" :http://whitepapers.techrepublic.com.com/thankyou.aspx?&docid=349630&v...
Thanks,
Dan

Does the osql command in 901164 work?

 

[kb9jlo]

Does the osql command in 901164 work?

Not for port 56183. How do I get my SQL server to (also) respond on that port.
I tried what I thought would work but it didn't.

 

[kb9jlo]

Does the osql command in 901164 work?

I think I have the port setup now. I went back and under SQL Srvr 2008 I put
in multiple ports under the IP ALL section.
Under the IP Addresses tab, under the IP ALL section I have 1433,56183 and
it is responding from a client computer via the osql command!
Thanks. I guess I just wasn't 'brave' enough to change it there but when I
found I could put multiple ports in I felt safer.
Now to see if BCM works.

 

[kb9jlo]

Luther, the OSQL command works just fine now but Outlook BCM still cannot see
the server or the instance - even though everything else can.

Is this the correct port? What port is BCM 'looking' for?

Installing/upgrading the SQL server and moving our databases wasn't as
difficult as setting this up!

Dan

 

[Luther Blissett]

Luther, the OSQL command works just fine now but Outlook BCM still cannotsee
the server or the instance - even though everything else can.

Is this the correct port? What port is BCM 'looking' for?

Installing/upgrading the SQL server and moving our databases wasn't as
difficult as setting this up!

Dan

Read this about port numbers and BCM versions:
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html

The database must be accessible through the expected port. If you
specify the port with OSQL and it connects to the database from
another machine, the sql instance is correctly configured. If OSQL
only connects if you do not specify the port, then the problem is that
the sql instance hasn't been configured for use with BCM.

 

[kb9jlo]

Luther, thanks! That was the ticket. BCM now sees the server/instance and
databases.
BUT - the BCM database we created it does not like.
Any tips on how to get a 'blank' database started on the SQL server end? We
had used the scripts and other information we found around but it didn't work.
Can we backup the local DB and restore it to the SQL 2008 server?

Thanks again. Any help would be appreciated.

Dan

 

[kb9jlo]

Scratch my last message. I can 'osql' from the client computer successfully.

Now when I attempt to connect, through 'Create or select a Business Contact
Manager database' I get the error message: "Cannot find any Business Contact
Manager databases on computer bldd_intranet\sql2003..." (that's my server and
instance - same thing I'm using in the 'osql' connect statement)

It does not give me a choice of what database to connect to as I thought it
would. Is it actually attempting to connect to the SQL server? How do I know?
What the heck am I doing wrong?

Dan

 

[kb9jlo]

I still need help with this problem. Please my last post. Can anyone help me
connect BCM to SQL 2008?