Navicat and HappyTool/GMTool

[jibi1996]

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?

[glossypvp]

You have to enable TCP/IP connections to access the database through navicat.

Open SQL server configuration manager and:

Turn on TCP\IP port (SQL Server Network configuration = > Protocols for <your database name>)

Fill up that form like this:


(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.

[jibi1996]

I dont want to acess HappyTool, this I already can do. I want acess Navicat to manage the database from another computer

[glossypvp]

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).

[jibi1996]

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.

[glossypvp]

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.

[jibi1996]

Thanks bro.