Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

I'm trying to connect to my SQL Server on my VPS but i can't get this to work.

  • I have enabled the TCP/IP protocol on SQL.
  • I also have the SQL Server and SQL Browser service running as a network service.
  • I turned off my firewall on my server and on the client (I won't keep it like this it's just for testing).

After doing all this it still doesn't work.

It seems that i can't reach port 1433 or 1434 either:

C:\>telnet myserver 1433
Connecting To mrsoundless.com...Could not open connection to the host, on port 1
434: Connect failed

C:\>telnet myserver 1434
Connecting To mrsoundless.com...Could not open connection to the host, on port 1
433: Connect failed

Could someone explain why this could be happening?

  • Note1: I'm new to MSSQL.
  • Note2: The server is a VPS for personal use.
  • Note3: I use SSMS to try to connect to SQL Server 2008 Express
share|improve this question

4 Answers

up vote 1 down vote

Sounds to me like your VPS host has a firewall or other filtering device sitting in between you and your server. Give them a call and see if this is the case and if so see if they can change the configuration to allow connections through to your VPS.

share|improve this answer
I will try doing that. Thanks – MrSoundless Aug 29 '10 at 3:00
up vote 0 down vote

After you change connection settings, such as enabling TCP/IP and listening on a static port, you need to restart the MSSQL service for that instance for those changes to take effect.

share|improve this answer
I did. I even restarted the server to make sure the right service was restarted! – MrSoundless Aug 29 '10 at 1:40
up vote 0 down vote

Is it listening on port 1433? Try running from the command prompt:
netstat -ano
If it doesn't say TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING in there it's not listening. If it does, try connecting to localhost instead of myserver - if that works, you sir have yourself a firewall issue. Check Windows Firewall then phone your provider.

share|improve this answer
I used portqry to check if the ports are listening. It seems that 1434 is listening. When I run portqry from the client it says it's filtered. 1433 is not listening at all which I think is weird because the port is set to 1433 by default in the SQL Configuration Manager. Also, as stated in the main post, both firewalls on server + client are turned off (unless you're talking about hardware firewalls, not sure about that...) – MrSoundless Aug 29 '10 at 1:39
up vote -4 down vote

By default, Express allows only Windows Authentication mode, so you should "enable remote connections":

Also, telnet service should run on your VPS server for quering with telnet?

BTW, where from are you telnetting?

Related question:

share|improve this answer
I get the 26 error shown on that webpage. I have already done everything shown there except that my SQL browser is running as a network service. So just changed that to run as a local service. I still have the same problem. Where from? If you mean geologically: From Netherlands to Netherlands. – MrSoundless Aug 29 '10 at 1:51
No, I mean geographically. Is it from computer from the same AD? I thought that VPS are rented remotely. – Геннадий-Ванин Aug 29 '10 at 2:02
What do you mean under "I get the 26 error shown on that webpage"? – Геннадий-Ванин Aug 29 '10 at 2:04
4  
I just read through this conversation chain. It's somewhat disturbing. Very little of what you are saying makes sense or is even applicable to the problem. 1) Windows authentication mode and remote connections have nothing to do with each other. 2) telneting into a host does not require a telnet service on the remote host. It requires an open socket, that is all. 3) there is no connection string at play here. He's just trying to get SSMS to connect, not code. – squillman Aug 29 '10 at 3:19
1  
Based on this and other answers you've submitted it is clear that you have a lot to learn about system administration. If you don't know, please don't pretend you do. Please don't answer and lead people down wild goose chases. – squillman Aug 29 '10 at 3:20
show 26 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.