MSO OL sp2 for BCM broke SQL Database connection

Status
Not open for further replies.
M

MaitreMind

Two days ago an MS update for MSO OL sp2 for BCM wanted to be installed so I

left it get installed. After the installation I noticed that my data

connection to the BCM database was broken.

I am using MSSQLSERVER instance name for SQL Server Developer Edition

instead of MSSQL instance name which is for SQLEXPRESS. I have been usine SQL

Server Developer edition with BCM for quite awhile without any problem but

now after sp2 was installed I cannot connect to the database as it cannot

find it.

I ran the database Admin tool to share it and everything ran successfully

with a pretty instruction page that opened in IE to walk one through

connecting to the database in OL. The initial connection failed when I

selected the connect to an existing databse as it wanted to connect to the

default SQLEXPRESS instance, then I typed in the computer name

localhost\MSSQLSERVER,1433 and it cannot find the database to connect.

Has anyone else had this ridiculous issue and how can I solve it?

Thanks,

MaitreMind
 
On May 17, 10:58 pm, MaitreMind <MaitreM...
wrote:
> Two days ago an MS update for MSO OL sp2 for BCM wanted to be installed so I
> left it get installed. After the installation I noticed that my data
> connection to the BCM database was broken.

> I am using MSSQLSERVER instance name for SQL Server Developer Edition
> instead of MSSQL instance name which is for SQLEXPRESS. I have been usineSQL
> Server Developer edition with BCM for quite awhile without any problem but
> now after sp2 was installed I cannot connect to the database as it cannot
> find it.

> I ran the database Admin tool to share it and everything ran successfully
> with a pretty instruction page that opened in IE to walk one through
> connecting to the database in OL. The initial connection failed when I
> selected the connect to an existing databse as it wanted to connect to the
> default SQLEXPRESS instance, then I typed in the computer name
> localhost\MSSQLSERVER,1433 and it cannot find the database to connect.

> Has anyone else had this ridiculous issue and how can I solve it?

> > Thanks,

> MaitreMind


By default, BCM creates and uses a sql instance named MSSMLBIZ, and

not the default instances. If Sql is installed by BCM Setup, it

doesn't even create the default instances.
 
Also the port number has to be 5356

Regards

Rahul Thomas [MSFT]

The posting is provided "AS IS" with no warranties and confers no rights.

https://blogs.msdn.com/rathomas

"Luther Blissett" <enowning@gmail.com> wrote in message

news:8b76678d-07df-4a7d-90ec-302034f49ca5@y33g2000prg.googlegroups.com...
> On May 17, 10:58 pm, MaitreMind <MaitreM...
> wrote:
> > Two days ago an MS update for MSO OL sp2 for BCM wanted to be installed
> > so I
> > left it get installed. After the installation I noticed that my data
> > connection to the BCM database was broken.
>

>> I am using MSSQLSERVER instance name for SQL Server Developer Edition
> > instead of MSSQL instance name which is for SQLEXPRESS. I have been usine
> > SQL
> > Server Developer edition with BCM for quite awhile without any problem
> > but
> > now after sp2 was installed I cannot connect to the database as it cannot
> > find it.
>

>> I ran the database Admin tool to share it and everything ran successfully
> > with a pretty instruction page that opened in IE to walk one through
> > connecting to the database in OL. The initial connection failed when I
> > selected the connect to an existing databse as it wanted to connect to
> > the
> > default SQLEXPRESS instance, then I typed in the computer name
> > localhost\MSSQLSERVER,1433 and it cannot find the database to connect.
>

>> Has anyone else had this ridiculous issue and how can I solve it?
>

>> > > Thanks,
>

>> MaitreMind


> By default, BCM creates and uses a sql instance named MSSMLBIZ, and
> not the default instances. If Sql is installed by BCM Setup, it
> doesn't even create the default instances.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Max. length of MSO MailItem.EntryID Outlook VBA and Custom Forms 6
P BCM 2013, Microsoft SQL Server 2008 R2 (SP2), attachment issue n database size BCM (Business Contact Manager) 2
B Promoting and demoting dns w/ exchange 2007 sp2 environment Exchange Server Administration 1
J [outlook-users] outlook 2007 Sp2: Error message to quit outlook Using Outlook 9
R Clean out the "Other Calendars" form Outlook 2007 sp2 Using Outlook 1
Z Outlctl disabled (Outlook2007 SP2) Outlook VBA and Custom Forms 2
N Support for outlook 2003 addin in xp home sp2 Outlook VBA and Custom Forms 3
S Re: Cannot attach a file to an Outlook 2007 template after installingOffice 2007 SP2 Outlook VBA and Custom Forms 3
J Outlook 2007 with BCM - Out of Memory after MSO12 SP2 installation BCM (Business Contact Manager) 4
D Outlook 2007 + BCM & SP2 - windows7 ? BCM (Business Contact Manager) 6
Y Outlook 2007 SP2 issues Outlook VBA and Custom Forms 7
R Office 2007 SP2 Install: BCM Update Failure BCM (Business Contact Manager) 25
T Appoinments Not Updating after Outlook 2007 SP2 Outlook VBA and Custom Forms 1
A After update to SP2 (office 2007) Launching a campaign fails BCM (Business Contact Manager) 3
C After Office 2007 SP2 install - Outlook 2007 macro no longer worki Outlook VBA and Custom Forms 11
J BCM no longer loads sqlserver after SP2 upgrade BCM (Business Contact Manager) 2
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM Using Outlook 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2

Similar threads

Back
Top