Connecting to DB Remotely
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
Re: Connecting to DB Remotely
go to Start>Programs>msq>ServerNetworkUtility > Enable the TCP/IP > then properties and then write 1433.
Re: Connecting to DB Remotely
actually i have the same problem.
btw mikesmith2, this doesnt work ( or at least with me :mellow: )
Re: Connecting to DB Remotely
yes it still doesnt work :(: but still thanks for trying to help
Re: Connecting to DB Remotely
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.
Re: Connecting to DB Remotely
Quote:
Originally Posted by
afonsolage
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?