SQL connection from client to server

Hi Experts,

How can I test a connection from my SQL Managemnet Studio 2014 client to my SQL 2014 server ?
The server is in a workgroup not in the domain.
I can connect to the server via RDP.
But the connection from my lokally installed Management Studio to the server is not possible.
Can you help me out ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Muhammad BurhanManager I.T.Commented:
please turnoff firewall on sql server just for testing, if this connects you then please modify firewall incoming rules in advance firewall settings.
allow:
TCP 1433
TCP 1434
UDP 1434
TCP 2383
TCP 2382
TCP 135
TCP 7022

also please consider
http://knowhow.visual-paradigm.com/hibernate/solving-sql-server-connection-problem/
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David SankovskySenior SysAdminCommented:
I'm trying to understand if it's a networking issue or otherwise.
Can you telnet to your server over port 1433?
if you can't - you need to make sure that there's a firewall that allows you to connect to said server (if it's behind a firewall - Windows Firewall can also be blocking you)
if you are on the same network and there is no FW between you and the server - the question is what sort of authentication is set up on your SQL server (SQL only / mixed mode) etc..
0
MlandaTCommented:
You basically need to do two things:
Ensure the firewall is open to accept connections on the SQL Server port (the above two deal with this)
Ensure that the SQL Server itself is configured to accept remote connections. Instructions here: https://msdn.microsoft.com/en-us/library/ms191464.aspx
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Don't forget to start the SQL Browser service. Without that service running you can only connect through TCP.
1
Eprs_AdminSystem ArchitectAuthor Commented:
Thanks to all, it was a DNS issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.