Connecting to DB Remotely

Soumyxorp · Feb 21, 2013

Hello

I have mssql2000 and i want to connect to my db remotely like i'm hosting my website on a web hosting site and connect it to my db in my vps. But how is it gonna work if i can't event connect my MuMaker on my vps db remotely? it keeps saying that i can't connect i have portforwarded on my vps 1433 and still doesnt work MuMaker is saying that my db actively refuses it bla bla bla

so the real question is how do i connect to my db remotely?
on my mumaker i put my vps ipaddress , correct sa login details but it just doesnt work

Thanks

mikesmtih2 · Mar 2, 2013

go to Start>Programs>msq>ServerNetworkUtility > Enable the TCP/IP > then properties and then write 1433.

PheonixMU · Mar 3, 2013

actually i have the same problem.
btw mikesmith2, this doesnt work ( or at least with me :mellow: )

Soumyxorp · Mar 3, 2013

yes it still doesnt work

: but still thanks for trying to help

afonsolage · Mar 3, 2013

You first need to check for port, do a telnet on port 1433 (If you dont know what is telnet, search on Google).

If it pass, you need to check if your DB user has remote connection permission.

Also if telnet doesnt go ok, check Windows firewall on your VPS, disable it for a while and test. And dont forget to reenable windows firewall.

Soumyxorp · Mar 16, 2013

afonsolage said:
You first need to check for port, do a telnet on port 1433 (If you dont know what is telnet, search on Google).

If it pass, you need to check if your DB user has remote connection permission.

Also if telnet doesnt go ok, check Windows firewall on your VPS, disable it for a while and test. And dont forget to reenable windows firewall.

Bump.. sorry for the long reply i forgot about this thread anyway can you please tell me how to do this telnet thingy step by step i tried searching it on google and i still cant figure what that is.. those passing things... pls

EDIT: Okay i tried the command telnet (ipaddress) (port) and it keeps saying connection failed i have 1433 open both tcp/udp i tried testing it too without firewall still connection failed
pls help what should i do now?