Can't Share Database

Status
Not open for further replies.
J

J.J. Zwada

I certainly hope someone can help, we have been working on this for days now

with no luck. To give you a little background, my associate recently

upgraded his computer and since that time we can no longer share the database

that he hosts on that machine. We are using Outlook 2007 with BCM, he is

operating on a windows XP pro system and the client computer that cannot

access the database is on an XP home system. We are networked through a

workgroup. This same computer also hosts an Act 9.0 Database that is working

fine and hosts a database for 8 users, whereas we are only trying to host the

BCM database with two users.

Up to this point we have made sure that both the client and host computer

has the same user profile on each machine with the same password. We have

went through the process of sharing the database on the host's computer, we

have set the MSSMLBIZ instance on SQL 2005 to run automatically and to allow

both local & remote connections using TCP/IP. I have checked windows

firewall and we actually have it fully disabled (though I did find it odd,

when turned on, under the exceptions tab there isn't an option to make an

exception for the MSSMLBIZ).

When we try to connect to the database on the hosts computer, we get this

error message: "Cannot access the database server on computer J-IPO. For

more information, click Help."

I've tried through the DOS command prompt to to ping the host machine from

the client machine and I can do this successfully. However, when I attempt

to verify the connection to the SQL database using this command: C:\>SQLCMD

-E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response: HResult

0x274D, Level 16, State 1 TCP Provider: No connection could be made because

the target machine actively refused it. Sqlcmd: Error: Microsoft SQL

Native Client : An error has occurred while establishing a connection to the

server. When connecting to SQL Server 2005, this failure may be caused by

the fact that under the default settings SQL Server does not allow remote

connections.. Sqlcmb: Error : Microsoft SQL Native Client : Login timeout

expired.

That obviously doesn't make sense to me being that we have SQL set up to

allow remote connections. I'm wondering if when my associate installed

Office and BCM on his new machine (host) he did something incorrectly.

Additionally, I believe when he backed up his database on his old machine he

did so by exporting the database as opposed to using the BCM back-up

tool.....could this have an effect?

Any help or guidance would be greatly appreciated!

J.J. Zwada
 
On Mar 24, 7:28 am, J.J. Zwada <JJZw...
wrote:
> I certainly hope someone can help, we have been working on this for days now
> with no luck.  To give you a little background, my associate recently
> upgraded his computer and since that time we can no longer share the database
> that he hosts on that machine.  We are using Outlook 2007 with BCM, he is
> operating on a windows XP pro system and the client computer that cannot
> access the database is on an XP home system.  We are networked through a
> workgroup.  This same computer also hosts an Act 9.0 Database that is working
> fine and hosts a database for 8 users, whereas we are only trying to hostthe
> BCM database with two users.

> Up to this point we have made sure that both the client and host computer
> has the same user profile on each machine with the same password.  We have
> went through the process of sharing the database on the host's computer, we
> have set the MSSMLBIZ instance on SQL 2005 to run automatically and to allow
> both local & remote connections using TCP/IP.  I have checked windows
> firewall and we actually have it fully disabled (though I did find it odd,
> when turned on, under the exceptions tab there isn't an option to make an
> exception for the MSSMLBIZ).  

> When we try to connect to the database on the hosts computer, we get this
> error message:  "Cannot access the database server on computer J-IPO. For
> more information, click Help."

> I've tried through the DOS command prompt to to ping the host machine from
> the client machine and I can do this successfully.  However, when I attempt
> to verify the connection to the SQL database using this command:  C:\>SQLCMD
> -E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response:  HResult
> 0x274D, Level 16, State 1 TCP Provider:  No connection could be made because
> the target machine actively refused it.  Sqlcmd:  Error:  MicrosoftSQL
> Native Client : An error has occurred while establishing a connection to the
> server.  When connecting to SQL Server 2005, this failure may be causedby
> the fact that under the default settings SQL Server does not allow remote
> connections..  Sqlcmb:  Error : Microsoft SQL Native Client : Login timeout
> expired.

> That obviously doesn't make sense to me being that we have SQL set up to
> allow remote connections.  I'm wondering if when my associate installed
> Office and BCM on his new machine (host) he did something incorrectly.  
> Additionally, I believe when he backed up his database on his old machinehe
> did so by exporting the database as opposed to using the BCM back-up
> tool.....could this have an effect?

> Any help or guidance would be greatly appreciated!

> J.J. Zwada


I'm confused. You have one server machine (with the BCM database) and

several BCM client machines, and all but one of the clients can access

the database on the server. Is that correct?
 
Luther,

Thanks for your question!

We have one machine acting as a server. It hosts an Act database (company

database) with multiple users and is working fine. This same machine also

hosts an Outlook BCM database that is the personal database of my assoicate

who works on this machine. We are attempting to connect only one client

machine to this BCM database (my associates assistant).

I simply provided the information on the Act database that is running on

that computer in the event there is some conflict with using Act and BCM on

the same machine. Though I would have to imagine this wouldn't be a problem

because we had no problem sharing the BCM database prior to my associates

computer upgrade.

Thank you in advance for any help you can provide,

J.J. Zwada

"Luther Blissett" wrote:


> On Mar 24, 7:28 am, J.J. Zwada <JJZw...
> wrote:
> > I certainly hope someone can help, we have been working on this for days now
> > with no luck. To give you a little background, my associate recently
> > upgraded his computer and since that time we can no longer share the database
> > that he hosts on that machine. We are using Outlook 2007 with BCM, he is
> > operating on a windows XP pro system and the client computer that cannot
> > access the database is on an XP home system. We are networked through a
> > workgroup. This same computer also hosts an Act 9.0 Database that is working
> > fine and hosts a database for 8 users, whereas we are only trying to host the
> > BCM database with two users.
> > Up to this point we have made sure that both the client and host computer
> > has the same user profile on each machine with the same password. We have
> > went through the process of sharing the database on the host's computer, we
> > have set the MSSMLBIZ instance on SQL 2005 to run automatically and to allow
> > both local & remote connections using TCP/IP. I have checked windows
> > firewall and we actually have it fully disabled (though I did find it odd,
> > when turned on, under the exceptions tab there isn't an option to make an
> > exception for the MSSMLBIZ).
> > When we try to connect to the database on the hosts computer, we get this
> > error message: "Cannot access the database server on computer J-IPO. For
> > more information, click Help."
> > I've tried through the DOS command prompt to to ping the host machine from
> > the client machine and I can do this successfully. However, when I attempt
> > to verify the connection to the SQL database using this command: C:\>SQLCMD
> > -E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response: HResult
> > 0x274D, Level 16, State 1 TCP Provider: No connection could be made because
> > the target machine actively refused it. Sqlcmd: Error: Microsoft SQL
> > Native Client : An error has occurred while establishing a connection to the
> > server. When connecting to SQL Server 2005, this failure may be caused by
> > the fact that under the default settings SQL Server does not allow remote
> > connections.. Sqlcmb: Error : Microsoft SQL Native Client : Login timeout
> > expired.
> > That obviously doesn't make sense to me being that we have SQL set up to
> > allow remote connections. I'm wondering if when my associate installed
> > Office and BCM on his new machine (host) he did something incorrectly.
> > Additionally, I believe when he backed up his database on his old machine he
> > did so by exporting the database as opposed to using the BCM back-up
> > tool.....could this have an effect?
> > Any help or guidance would be greatly appreciated!
> > J.J. Zwada


> I'm confused. You have one server machine (with the BCM database) and
> several BCM client machines, and all but one of the clients can access
> the database on the server. Is that correct?
>
 
On Mar 26, 8:21 am, J.J. Zwada <JJZw...
wrote:
> Luther,

> Thanks for your question!

> We have one machine acting as a server.  It hosts an Act database (company
> database) with multiple users and is working fine.  This same machine also
> hosts an Outlook BCM database that is the personal database of my assoicate
> who works on this machine.  We are attempting to connect only one client
> machine to this BCM database (my associates assistant).  

> I simply provided the information on the Act database that is running on
> that computer in the event there is some conflict with using Act and BCM on
> the same machine.  Though I would have to imagine this wouldn't be a problem
> because we had no problem sharing the BCM database prior to my associates
> computer upgrade.  

> Thank you in advance for any help you can provide,

> J.J. Zwada

> "Luther Blissett" wrote:
> > On Mar 24, 7:28 am, J.J.  Zwada <JJZw...
> > wrote:
> > > I certainly hope someone can help, we have been working on this for days now
> > > with no luck.  To give you a little background, my associate recently
> > > upgraded his computer and since that time we can no longer share the database
> > > that he hosts on that machine.  We are using Outlook 2007 with BCM,he is
> > > operating on a windows XP pro system and the client computer that cannot
> > > access the database is on an XP home system.  We are networked through a
> > > workgroup.  This same computer also hosts an Act 9.0 Database that is working
> > > fine and hosts a database for 8 users, whereas we are only trying to host the
> > > BCM database with two users.

>
> > > Up to this point we have made sure that both the client and host computer
> > > has the same user profile on each machine with the same password.  We have
> > > went through the process of sharing the database on the host's computer, we
> > > have set the MSSMLBIZ instance on SQL 2005 to run automatically and to allow
> > > both local & remote connections using TCP/IP.  I have checked windows
> > > firewall and we actually have it fully disabled (though I did find itodd,
> > > when turned on, under the exceptions tab there isn't an option to make an
> > > exception for the MSSMLBIZ).  

>
> > > When we try to connect to the database on the hosts computer, we get this
> > > error message:  "Cannot access the database server on computer J-IPO. For
> > > more information, click Help."

>
> > > I've tried through the DOS command prompt to to ping the host machinefrom
> > > the client machine and I can do this successfully.  However, when Iattempt
> > > to verify the connection to the SQL database using this command:  C:\>SQLCMD
> > > -E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response:  HResult
> > > 0x274D, Level 16, State 1 TCP Provider:  No connection could be made because
> > > the target machine actively refused it.  Sqlcmd:  Error:  Microsoft SQL
> > > Native Client : An error has occurred while establishing a connectionto the
> > > server.  When connecting to SQL Server 2005, this failure may be caused by
> > > the fact that under the default settings SQL Server does not allow remote
> > > connections..  Sqlcmb:  Error : Microsoft SQL Native Client : Login timeout
> > > expired.

>
> > > That obviously doesn't make sense to me being that we have SQL set upto
> > > allow remote connections.  I'm wondering if when my associate installed
> > > Office and BCM on his new machine (host) he did something incorrectly..  
> > > Additionally, I believe when he backed up his database on his old machine he
> > > did so by exporting the database as opposed to using the BCM back-up
> > > tool.....could this have an effect?

>
> > > Any help or guidance would be greatly appreciated!

>
> > > J.J. Zwada

>
> > I'm confused. You have one server machine (with the BCM database) and
> > several BCM client machines, and all but one of the clients can access
> > the database on the server. Is that correct?-




OK.

I think the core issue is this then:

SQLCMD -E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response:

HResult

0x274D, Level 16, State 1 TCP Provider: No connection could be made

because

the target machine actively refused it.

Given that ACT clients can connect to this machine, sql and the

machine must be setup to accept connections over the network.

Is the server's firewall open to TCP port 5356?
 


> OK.

> I think the core issue is this then:

> SQLCMD -E -E SERVER_NAME\MSSMLBIZ,5356 I get the following response:
> HResult
> 0x274D, Level 16, State 1 TCP Provider: No connection could be made
> because
> the target machine actively refused it.

> Given that ACT clients can connect to this machine, sql and the
> machine must be setup to accept connections over the network.

> Is the server's firewall open to TCP port 5356?


Luther,

We have completely disabled windows firewall and the new machine is running

without anti-virus software. One thing I found interesting is that I tried

turning on windows firewall and just allowing for the MSSMLBIZ exception to

port 5356 and the MSSMLBIZ option wasn't even there.....it was at that point

that I thought there might have been an issue with the install. Along this

same topic....do you think the client machines anti-virus/firewall could be

causing the issue?

Thanks again,

J.J.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
D can you share a bcm database with 2 different versions of windows? BCM (Business Contact Manager) 0
I Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool BCM (Business Contact Manager) 2
P Database User Share Disconnecting BCM (Business Contact Manager) 4
K How to share multiple calendar items Using Outlook 1
M Unable to share 2019 calendar Using Outlook 0
D How To Combine Share Task Folders in just one Folder Using Outlook 0
P Outlook 2013 Word Share doc as Email Attachment now brings up Eudora. Using Outlook 1
S automate save the .xlxs file to share Network Using Outlook 1
R Can't Send calendar share invite Using Outlook 5
G Unable to dismiss reminders from share point list calendar shared in Outlook Using Outlook 2
Patrick van Berkel Best way to share (and keep up-to-date) Macro's in Outlook 2010 Outlook VBA and Custom Forms 6
R Making Outlook default client in share charm Using Outlook 4
Miquela I need to make a calendar to share here at work with 40 other people Using Outlook 1
smokiibear Share Office 365 Tasks such that Other Users also Are Alerted with Reminder Using Outlook 1
T How to share Outlook SUBfolders Using Outlook 3
J Share calendar but don't share categories Exchange Server Administration 1
L Can't share email folders Exchange Server Administration 1
K Outlook keeps prompting for Microsoft username and password for share calendar Using Outlook 0
L Archive Shared Folders for all to Share Using Outlook 0
R Share mailbox issue Exchange Server Administration 0
B Is there a simple way to share email folders w/o exchange server? Using Outlook 0
C How do I share/post my calendar to public folders Exchange Server Administration 3
W Outlook 2010 Share calendar but keep color formatting Using Outlook 2
A Share recurrent events with others Using Outlook 2
P Created new profile, how do I share existing contacts/calendar? Using Outlook 1
S Can't share contacts in Outlook on MS Exchange Server??? Exchange Server Administration 1
S Share between 2000 and 2010 Using Outlook 3
R Disable request to share a calendar Using Outlook 1
S share Outlook folders with other old versions Using Outlook 1
H Cannot share calendar, global address book not updating Exchange Server Administration 1
P Share Outlook 2011 Calendar Using Outlook 2
R Best way to share outlook calendar with 10 laptops Using Outlook 9
R Share ost between connector and exchange cache mode = "everything everywhere" Using Outlook 3
J Can multiple exchange users share same categories? Exchange Server Administration 4
N How do you share your business contact manager with coworkers BCM (Business Contact Manager) 1
B Post form into share calendar Outlook VBA and Custom Forms 1
S share business contact manager BCM (Business Contact Manager) 3
S can't share databse BCM (Business Contact Manager) 1
Q Opening email from a share breaks add-in Outlook VBA and Custom Forms 15
A Moving Public Folders to New Database Exchange Server Administration 3
J No access to a Database BCM BCM (Business Contact Manager) 3
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
T Lost access to remote BCM database BCM (Business Contact Manager) 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
wallisellener "The database name cannot exceed 50 characters" BCM (Business Contact Manager) 2
S Encrypting Exchange Database Exchange Server Administration 0
R Outlook Database to a non-Outlook PC Using Outlook 10

Similar threads

Back
Top