Solved

remote connetion to SQL server 2008 doesent work

Posted on 2010-08-16
6
394 Views
Last Modified: 2012-05-10
Hi Experts,

Remote connetions to Microsoft SQL server 2008 does not work, im getting followinbg error.

This is a new installation on windows server 2008, im getting following error:

TITLE: Connect to Server
------------------------------

Cannot connect to win2008test.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQ
l+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
0
Comment
Question by:Torsleff-Experten
6 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 62 total points
ID: 33443862
please check this article to start troubleshooting this kind of problems:
http://www.experts-exchange.com/A_1881-Connect-to-your-SQL-Server.html
http://www.experts-exchange.com/A_1881.html
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 63 total points
ID: 33482024
Sounds like you have a problem with the Firewall.  You can try to telnet to the servername :1434

Telnet to win2008test like this:

telnet win2008test 1434

If it fails then you cannot connect outside the machine on those ports, if it sits and waits for a command, then you can.  Then there are other reasons.
0
 
LVL 2

Author Comment

by:Torsleff-Experten
ID: 33509254
i have disabled the firewall to test, but still telnet win2008test 1434 doesent work.

it seems like we have had some problems with the domaincontroller, how can i make reconnect the sqlserver to the networks, i do not want to reinstall the server.

i can ping the server at make remote coneections but cant se the sql server from other sql servers.
0
 
LVL 2

Author Comment

by:Torsleff-Experten
ID: 33509448
after opening port 1433 and 1434, and rebooting domaincontroller an win2008test it seems to work.

So i think it was a firewall / domain controller problem.

Thanks for the help.

i will most of the point to dbaduck (100) for the firewall help, and the rest to angelll (25) for the links.
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 34459776
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

685 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