Solved

SQL Server 2008 R2 client won't connect to Server

Posted on 2016-10-17
8
48 Views
Last Modified: 2016-10-24
Using a reservation app on Win 7 using SQL server 2008 R2.
Client also has SQL Server 2008 R2

Server works 100%

The client won't connect.  Also Win 7 + SQL server 2008 R2. I have attached error msg and both svr & client ini files.
Can ping server from client
Ensured the server has 'Allow connections' ticked.

Enabled TCP on server firewall. Opened port 1433 on server.  

Can't work it out
Error msgReservit.ini
Server.ini
0
Comment
Question by:sco505
8 Comments
 
LVL 20

Expert Comment

by:Russ Suter
ID: 41847217
It's possible that your SQL server instance isn't using the default port. A quick test would be to momentarily bring down your firewall and see if you can connect then. If you can then there is another port you will need to open.
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 41847244
You'll also have to make sure the SQL Browser service is running. It is used to find out about the non-default port (using an instance name implies it is a dynamic, non-default port). SQL Browser requires 1434/udp.
0
 

Author Comment

by:sco505
ID: 41847384
I'll give both a go.  Let you know how I get on.  Take a couple of days to get there and fix
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 41848032
To find out what port SQL is listening to, open a command prompt as administrator and run the following:

netstat -aon -b

Scroll until you find sqlserver.exe and see which port it is listening on as well as which IP it is binding to.
0
 

Author Comment

by:sco505
ID: 41851291
Disabled firewall.
Browser is running
No luck.  Still getting same error.

Attached server netstat file.  Shows no IP for sqlserver.exeNetstat-Svr.jpg
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 41852112
Port 1433 is fine and correct. Even without SQL Browser service the connection should get established (port 1433 is tried as last resort, even if using an instance name), it might just last a second longer.
The local application is using TCP on port 1433 too, so that works.

The ReservIt.ini contains this entry:  Data Source=.\sqlexpress
Server.ini: Data Source=\\\\reservit-pc\\sqlexpress
and both Provider=SQLOLEDB
Your screenshot however shows Provider=SqlNCli10.1; Data Source=192.168.1.25\sqlexpress

This info does not fit together. The first file refers to a local instance, the second has a misspelled data source (no leading backslashes are allowed), and the error message uses both a different data source and provider (Native Client 2008).
0
 

Author Closing Comment

by:sco505
ID: 41857566
Thanks Qlemo.  All it took was to delete the 2 leading backslashes and now it works 100%
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question