Link to home
Start Free TrialLog in
Avatar of sco505
sco505Flag for New Zealand

asked on

SQL Server 2008 R2 client won't connect to Server

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
User generated imageReservit.ini
Server.ini
Avatar of Russ Suter
Russ Suter

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.
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.
Avatar of sco505

ASKER

I'll give both a go.  Let you know how I get on.  Take a couple of days to get there and fix
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.
Avatar of sco505

ASKER

Disabled firewall.
Browser is running
No luck.  Still getting same error.

Attached server netstat file.  Shows no IP for sqlserver.exeUser generated image
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sco505

ASKER

Thanks Qlemo.  All it took was to delete the 2 leading backslashes and now it works 100%