Connecting to remote SQL database on the sbs does not work but will work on the workstations
- From: MFreeman@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 24 Apr 2009 04:40:18 -0700 (PDT)
Hello we are soon creating a new system that will require our sql
database locally to update itself with information from the sql
database on our websites dedicated server. I have set up all the rules
for the ports etc in isa and now we can access the remote database
fine from our workstation but whenever you try and access it from the
sbs it will not work. I was wondering if there was a seperate firewall
or rules for the sbs that are not applied to the workstations? Is this
a special server to server protection or something else any ideas
would be much appriciated i have include serveral of the different
error messages below. Once again this ONLY happens on our sbs 2003 and
not the workstations that go throught the proxy and isa. Thanks
Error message ins Sql management studio 2005 when i try and connect
through TCIP
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. (provider: TCP Provider, error: 0 - A socket operation
was attempted to an unreachable host.) (.Net SqlClient Data Provider)
when i try and connect through the defualt
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. (provider: TCP Provider, error: 0 - A socket operation
was attempted to an unreachable host.) (.Net SqlClient Data Provider)
ISA firewall messages
Denied Connection (name of different protocols set up to allow ports
mainly netbios on port 139)
A packet generated on the local host was rejected because its source
IP address is assigned to one network adapter and its destination IP
address is reachable through another network adapter.
There are also various other denied connections but none have error
messages and are all stuff that i have setup to allow access, these
don't get denied when connecting from a workstation.
Any help would be greatly appricated thanks
Mark Freeman
.
- Prev by Date: Re: Network problems after a new server installation (2003 SBS R2 SP2)
- Next by Date: Mail loop for mail enabled contact
- Previous by thread: Maximum memory
- Next by thread: Re: Connecting to remote SQL database on the sbs does not work but will work on the workstations
- Index(es):
Relevant Pages
|
Loading
