Can't connect BCM to database

[ksurvell]

I'm at a loss to explain it, although I suspect there is a simple explanation
that I am simply not seeing.

I have MS SQL Server as the BCM database on a server machine. My clients can
connect to it just fine. I used the new "Business Contact Manager for Outlook
2007 Database Tool" to set it up and it worked great.

However, when I install Outlook (2007) and BCM (2007) on the server machine
itself... BCM can't connect to the database, and I don't know why.

From all the workstations, I used the following during the BCM Startup
Wizard: SERVER\MSSQLSERVER,1433. It worked fine for the workstations - why
isn't it working for the server? What have I missed?

 

[Fatih Yildiz [MSFT]]

Can you explain us which connection string did you use on local machine in
"Select or Create Business Contact Manager database" dialog? If you had just
use the name of local machine, it is not enough;

When you install BCM on your Server machine, BCM will create an instance on
your server machine named "MSSMLBIZ", you will have two instances named
MSSQLSERVER and MSSMLBIZ. The name of the computer is not enough for
connecting to local database. You need to say
"<serverName>\<InstanceNameThatYouWantToConnect>".

In your case you need to say, "SERVER\MSSQLSERVER".

 

[ksurvell]

The connetion string I used was:

SERVERNAME\MSSQLSERVER,1433

I used it sucessfully on the workstations, but it doesn't work on the
server. When I use the SQL Administration Console, I can type in that exact
connection string, and it loads and shows me the BCM database - so I know it
works (I guess).

Do you think that there is a problem when I installed BCM and it created its
own ... what is is called, SQL Express Edition or whatever... database, with
the same name? If so, I could try removing it, but I'm not exactly sure how...

Can you explain us which connection string did you use on local machine in
"Select or Create Business Contact Manager database" dialog? If you had just
use the name of local machine, it is not enough;

When you install BCM on your Server machine, BCM will create an instance on
your server machine named "MSSMLBIZ", you will have two instances named
MSSQLSERVER and MSSMLBIZ. The name of the computer is not enough for
connecting to local database. You need to say
"<serverName>\<InstanceNameThatYouWantToConnect>".

In your case you need to say, "SERVER\MSSQLSERVER".

--
Fatih YILDIZ [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights

I'm at a loss to explain it, although I suspect there is a simple
explanation
that I am simply not seeing.

I have MS SQL Server as the BCM database on a server machine. My clients
can
connect to it just fine. I used the new "Business Contact Manager for
Outlook
2007 Database Tool" to set it up and it worked great.

However, when I install Outlook (2007) and BCM (2007) on the server
machine
itself... BCM can't connect to the database, and I don't know why.

From all the workstations, I used the following during the BCM Startup
Wizard: SERVER\MSSQLSERVER,1433. It worked fine for the workstations - why
isn't it working for the server? What have I missed?

 

[Phil]

Instead of SERVERNAME\MSSQLSERVER,1433 use

..\MSSQLSERVER,1433

The connetion string I used was:

SERVERNAME\MSSQLSERVER,1433

I used it sucessfully on the workstations, but it doesn't work on the
server. When I use the SQL Administration Console, I can type in that exact
connection string, and it loads and shows me the BCM database - so I know it
works (I guess).

Do you think that there is a problem when I installed BCM and it created its
own ... what is is called, SQL Express Edition or whatever... database, with
the same name? If so, I could try removing it, but I'm not exactly sure how...

Can you explain us which connection string did you use on local machine in
"Select or Create Business Contact Manager database" dialog? If you had just
use the name of local machine, it is not enough;

When you install BCM on your Server machine, BCM will create an instance on
your server machine named "MSSMLBIZ", you will have two instances named
MSSQLSERVER and MSSMLBIZ. The name of the computer is not enough for
connecting to local database. You need to say
"<serverName>\<InstanceNameThatYouWantToConnect>".

In your case you need to say, "SERVER\MSSQLSERVER".

--
Fatih YILDIZ [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights

I'm at a loss to explain it, although I suspect there is a simple
explanation
that I am simply not seeing.

I have MS SQL Server as the BCM database on a server machine. My clients
can
connect to it just fine. I used the new "Business Contact Manager for
Outlook
2007 Database Tool" to set it up and it worked great.

However, when I install Outlook (2007) and BCM (2007) on the server
machine
itself... BCM can't connect to the database, and I don't know why.

From all the workstations, I used the following during the BCM Startup
Wizard: SERVER\MSSQLSERVER,1433. It worked fine for the workstations - why
isn't it working for the server? What have I missed?