> 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...
>
> "Fatih Yildiz [MSFT]" wrote:
>
> > 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
> >
> > "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message
> > news:209A0126-128A-4E3B-862A-4D2E7DF09C25[ at ]microsoft.com...
> > > 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?
> >
> >
> >