Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

remote connetion to SQL server 2008 doesent work

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
Torsleff-Experten
Asked:
Torsleff-Experten
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
Torsleff-ExpertenAuthor Commented:
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
 
Torsleff-ExpertenAuthor Commented:
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
 
QlemoC++ DeveloperCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now