Navicat and HappyTool/GMTool

02/24/2013 14:50 jibi1996#1
I tested with a friend and he can acess the HappyTool and GM Tool without being in the host computer, I wonder now if its possible to him acess the server database from Navicat, someone knows how to do this?
02/24/2013 17:23 glossypvp#2
You have to enable TCP/IP connections to access the database through navicat.

Open SQL server configuration manager and:
[Only registered and activated users can see links. Click Here To Register...]
Turn on TCP\IP port (SQL Server Network configuration = > Protocols for <your database name>)

Fill up that form like this:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
(replace IP to yours, TCP IP port is 1433 and use dynamic ports value is 0)

You can access HappyTool from other computer than localhost without any necessary configurations. Of course you must have a happy tool manager account.
02/24/2013 17:29 jibi1996#3
I dont want to acess HappyTool, this I already can do. I want acess Navicat to manage the database from another computer
02/24/2013 18:05 glossypvp#4
And there are the instructions to configure your TCP/IP connection.
Whoops I forgot that you have to put in your server's IP in navicat to conenct, and use account sa, and your specified password (yes .. you have to specify a password to make outside connections possible).
02/25/2013 22:56 jibi1996#5
Dude, this I already know, what I meant is : I'm not in my host server and I want to acess the server database through Navicat.
02/26/2013 10:16 glossypvp#6
Dude and I show you how to configure your server to allow TCP/IP configurations to make your server able to accept outside connections like Navicat.

In navicat just put in your IP, username: sa, password: your passsword. It won't work with windows authentication.
02/26/2013 21:00 jibi1996#7
Thanks bro.