Cannot connect to database

Status
Not open for further replies.
E

Evelyn

In Startup BCM

* Create or Select BCM database

* Select an existing database

The problem I have is the user who tries to connect to the database, is the

owner of the database, why BCM cannot connect to the database?

Please provide some advice.
 
P

Poohbear

Is the database a shared database?

When you started the setup process for BCM 2007, did you create your

database? If so, you simply select select existing database, click connect,

and then you click next...wait for the database to load ( if you have an

existing database already started)...If it doesn't load after that, I suggest

you exit of out outlook and restart, if you are still having problems you can

use your second CD to run an error check.

Please Remember whatever you do to Back up your database in case something

goes wrong with your system and save it to a flash drive, you can take it

with you wherever you go; if something happens to your BCM on the computer

you have your flash drive to upload again. That's easy :)

You can also try microsoft.com web site under office-then Microsoft

outlook2007 w/BCM has demo info and troubleshooting examples.

"Evelyn" wrote:


> In Startup BCM
> * Create or Select BCM database
> * Select an existing database
> The problem I have is the user who tries to connect to the database, is the
> owner of the database, why BCM cannot connect to the database?

> Please provide some advice.
 
E

Evelyn

Hi Poohbear,

When I startup Outlook, I can create databases. They are listed in the drop

down menu. I only cannot connect to them.

In the beginning a message came up, that the database is no longer shared,

but it disappeared.

Message now: An unknown error occurred while connecting to the database.

Please click Retry. If the error recurs, click Help, which I did.

I checked SQL Server service log on is using the Network Service user account.

Permissions for the Folder BCM are set with the correct user groups.

Even in SQL I check off Collation for MSSMLBIZ Databases.

I added the owner user into the User of the BCM Database.

When I log on locally to my computer, BCM runs fine.

I do not have any trouble with MOA Databases running in the same Instance

locally and while connected to a server.

When I check with SQL Management Studio 2008 Express, Restrict Access =

Multiuser, Database State = Normal. I am a user with admin rights and I am

the owner of the BCM database.

Error message in the Application log is, while Outlook is trying to connect

to BCM database:

Log: Windows NT (Application)

Source: MSSQL$SQLEXPRESS2008

Category: Logon

Event: 3221243928

User: NT AUTHORITY\NETWORK SERVICE

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open

the explicitly specified database. [CLIENT: <local machine>]

Hopefully this helps to explain the status.

"Poohbear" wrote:


> Is the database a shared database?

> When you started the setup process for BCM 2007, did you create your
> database? If so, you simply select select existing database, click connect,
> and then you click next...wait for the database to load ( if you have an
> existing database already started)...If it doesn't load after that, I suggest
> you exit of out outlook and restart, if you are still having problems you can
> use your second CD to run an error check.
> Please Remember whatever you do to Back up your database in case something
> goes wrong with your system and save it to a flash drive, you can take it
> with you wherever you go; if something happens to your BCM on the computer
> you have your flash drive to upload again. That's easy :)

> You can also try microsoft.com web site under office-then Microsoft
> outlook2007 w/BCM has demo info and troubleshooting examples.

> "Evelyn" wrote:
>
> > In Startup BCM
> > * Create or Select BCM database
> > * Select an existing database
> > The problem I have is the user who tries to connect to the database, is the
> > owner of the database, why BCM cannot connect to the database?
> > Please provide some advice.
 
P

Poohbear

Hi, Evelyn

This is Microsoft Support Telephone Number 800-936-5700; If you've purchased

the product you may be entitled to free support but you have to call to find

out.

The support team who handles this would be Microsoft Outlook 2007 Business

Contact Manager Support; not the Outlook 2007 support they're different

support deparments.

If you have not called the microsoft support team previously regarding this

issue you may be entitled to free support for 90 day.

Please call they maybe able to help.

"Evelyn" wrote:


> Hi Poohbear,

> When I startup Outlook, I can create databases. They are listed in the drop
> down menu. I only cannot connect to them.

> In the beginning a message came up, that the database is no longer shared,
> but it disappeared.

> Message now: An unknown error occurred while connecting to the database.
> Please click Retry. If the error recurs, click Help, which I did.

> I checked SQL Server service log on is using the Network Service user account.
> Permissions for the Folder BCM are set with the correct user groups.
> Even in SQL I check off Collation for MSSMLBIZ Databases.
> I added the owner user into the User of the BCM Database.

> When I log on locally to my computer, BCM runs fine.
> I do not have any trouble with MOA Databases running in the same Instance
> locally and while connected to a server.

> When I check with SQL Management Studio 2008 Express, Restrict Access =
> Multiuser, Database State = Normal. I am a user with admin rights and I am
> the owner of the BCM database.

> Error message in the Application log is, while Outlook is trying to connect
> to BCM database:
> Log: Windows NT (Application)
> Source: MSSQL$SQLEXPRESS2008
> Category: Logon
> Event: 3221243928
> User: NT AUTHORITY\NETWORK SERVICE
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open
> the explicitly specified database. [CLIENT: <local machine>]

> Hopefully this helps to explain the status.

> "Poohbear" wrote:
>
> > Is the database a shared database?
> > When you started the setup process for BCM 2007, did you create your
> > database? If so, you simply select select existing database, click connect,
> > and then you click next...wait for the database to load ( if you have an
> > existing database already started)...If it doesn't load after that, I suggest
> > you exit of out outlook and restart, if you are still having problems you can
> > use your second CD to run an error check.
> > Please Remember whatever you do to Back up your database in case something
> > goes wrong with your system and save it to a flash drive, you can take it
> > with you wherever you go; if something happens to your BCM on the computer
> > you have your flash drive to upload again. That's easy :)
> > You can also try microsoft.com web site under office-then Microsoft
> > outlook2007 w/BCM has demo info and troubleshooting examples.
> > "Evelyn" wrote:
> >
> > > In Startup BCM
> > > * Create or Select BCM database
> > > * Select an existing database
> > > The problem I have is the user who tries to connect to the database, is the
> > > owner of the database, why BCM cannot connect to the database?
> > > > Please provide some advice.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
R Shared database greyed out and cannot connect BCM (Business Contact Manager) 10
C Cannot Connect to BCM Database BCM (Business Contact Manager) 4
T Cannot connect to main BT email account, sub accts okay Using Outlook 0
T Outlook 2016 cannot connect after transition to Outlook Mail Using Outlook.com accounts in Outlook 4
R BCM 2010 Problem with remote office (VPN) users cannot connect BCM (Business Contact Manager) 12
J BCM 2010 - New user cannot connect to remote DB BCM (Business Contact Manager) 5
E Outlook cannot connect to your incoming (POP3) e-mail server/Cannot send mess. Using Outlook 0
O Cannot expand the folder. The set of folders cannot be opened. You do not have permission to log on. Using Outlook 1
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 2
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
D cannot view emails in View pane (in the right pane), I only see one line or nothing Using Outlook 21
M Cannot read the calendar Using Outlook 9
T The Linked Image Cannot Be Displayed in Outlook Using Outlook 7
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 3
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
G Cannot Move Autocomplete File to New Computer Using Outlook 15
rubaboo The vew cannot be found Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
L Cannot open PST file for first session each day Using Outlook 6
David in Mississippi New (Feb 2020) install of Outlook 365 - Cannot specify PST for different accounts Using Outlook 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
noshairwan Registry cannot be found, Outlook Security Using Outlook 2
Marc2019 Cannot input Vietnamese Characters on my MSOutlook 2016 in Windows 7 Using Outlook 0
T Cannot remove needless PST Using Outlook 1
Marc2019 Cannot setup Outlook Account on Mac Os 10.6.8 Using Outlook 3
N pst files are recreating automaticaly and cannot be deleted Using Outlook 5
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
A Created a new user account and the local account cannot see email Using Outlook 3
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
O The page that you are trying to access cannot be loaded. Using Outlook 0
M Daily Task List Minimized Cannot Display Using Outlook 2
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
C Outlook 2016 cannot delete, email showing in root Exchange Server Administration 5
S Outlook.com cannot edit some contacts Using Outlook.com accounts in Outlook 5
B Search: Cannot find which Folder Contains a Message Using Outlook 3
C Outlook - cannot save subject line changes Using Outlook 2
M cannot change delivery folders with IMAP accounts Using Outlook 0
S Appointment-Cannot set Categories because ConversationID is not set Outlook VBA and Custom Forms 1
Fozzie Bear Cannot post "Sneaky URL"!! Using Outlook.com accounts in Outlook 2
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
S Outlook 2010 Cannot Open Attachments Using Outlook 14
A Cannot Figure Out This VBA Outlook VBA and Custom Forms 2
A Cannot Figure Out One Thing on VBA Outlook VBA and Custom Forms 2

Similar threads

Top