Solved SQL server

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

oldman1943

Thread Starter
Joined
Oct 22, 2018
Messages
3
I have a server 2012 r2 running SQL server, on the server I have a application that attaches to a data base on this server. Whats happening : I can access the database from the server and the application runs fine. When I try to access from either a windows 10 or windows 7 client it fails. All client are apart of the domain. and seem to be working fine. The application is based on foxpro and passing information to SQL over the standard port (1433). I think the problem is some sort of a permission problem. By the way everything is on a local area network in house. I have tried every thing that I know. As you can tell by my username I am an old guy that be around computers and main frames for 50 plus years. I sure would appreciate some help as this is a side job to my retirement and I need the job.

Thanks in advance for your help
 

Fireflycph

Morten
Joined
Apr 1, 2016
Messages
1,537
Did you allow browsing on the server? And enable TCPIP and, maybe, Named Pipes in the SQL Protocol Management?
 

Fireflycph

Morten
Joined
Apr 1, 2016
Messages
1,537
Have you tried to disable firewalls on both the server and the station? I've had issues with Windows firewall where, even if that port was allowed, I had to disable the firewall, then connect and re-enable the firewall. You may also want to allow the Exe file access. Whatever the executionable file may be. It could be Foxpro.exe but more likely some other name as-so you state-the application is based on Foxpro.
Also disable any Antivirus s/w, just for testing purposes.
 

imstewart

Ian
Joined
Jun 18, 2015
Messages
22
Hi Setup SQL server for TCPIP can be a real pain, as there are so many little things that need to setup.

It basically fails to 2 camps.
  1. Setup the server to listen on the correct IP address/Port
  2. Ensure that the firewall is allowing the connection.

Here are a couple Microsoft doc that I use to setup all the parts of the jigsaw.

Hope this helps.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top