Solved

SQL Server 2008 R2 client won't connect to Server

Posted on 2016-10-17
8
54 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Code Manager | Snippits 2 37
Join with a SQL Server STUFF 5 37
Reverse DND setup 6 38
I'm wondering how windows server redirect perfomance 6 33
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

827 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