Solved

SQL Server 2008 R2 client won't connect to Server

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

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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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 68

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now