?
Solved

SQL connection Issues

Posted on 2012-04-03
7
Medium Priority
?
246 Views
Last Modified: 2012-04-16
Trying to connect to SQL server 2008 r2 and i get the attached error message. Server is 2008 r2 Express, client is Windows 7 Pro. Both Firewalls have been disabled.
Untitled.jpg
0
Comment
Question by:nidul2004
7 Comments
 
LVL 16

Expert Comment

by:Deepak Chauhan
ID: 37802693
0. make sure tcpip is enabled

1. Use 'ping server' to test the network.
2. Use 'telnet server 1433' to ensure that the SQL Server is listening
on the port.

3. Check the Net-Library protocol configured by using 'Client Network
Utility'
on the client. Are they supported by the SQL Server? If you use Named
Pipes,please try to change it to TCP/IP.

4. Add an entry in the hosts file on the
client machine.
0
 

Expert Comment

by:expert9
ID: 37802704
you can try either of these solutions

1. Add an entry in the hosts file on the
client machine.
2. Check the Net-Library protocol configured by using 'Client Network
Utility'
on the client. Are they supported by the SQL Server? If you use Named
Pipes,please try to change it to TCP/IP.
3. Use 'ping server' to test the network.
4. Use 'telnet server 1433' to ensure that the SQL Server is listening
on the port.
5. Try again.

or

Change the dns server address form automatically to dedicated one(Network Connection>TCP/IP Protocol), then ping again
0
 
LVL 16

Expert Comment

by:Deepak Chauhan
ID: 37802721
other one but dont  work everytime

1. run sqlserver as administrator

2. click on option button on the login screen  and change default to tcpip in the network protocol section drop down box
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:nidul2004
ID: 37802915
0. TCPIP and Named pipes are enabled
1. Can ping yes
2. Can not telnet to port 1433.

My SQL Server Agent is set to auto, but will not stay started.
0
 
LVL 8

Expert Comment

by:POracle
ID: 37818472
Your port might be block or sql server might listening to other port.

Read this article, it explain in detail
http://support.microsoft.com/kb/823938

Let us know if your prob. still not resolved
0
 

Accepted Solution

by:
nidul2004 earned 0 total points
ID: 37834859
Port was open, but for some reason SQL browers service was not started. Set to automatic, problem solved.
0
 

Author Closing Comment

by:nidul2004
ID: 37850379
Solved own problem
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

579 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