Can't Share Database

[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

 

[Luther Blissett]

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?

 

[J.J. Zwada]

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]

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






- Show quoted text -

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?

 

[J.J. Zwada]

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.