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
 
L

Luther Blissett

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.
 
R

Raul Thomas

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

Top