Windows Server

[macca]

just upgraded after a long absence and can get to work on Linux servers with cPanel.

Cannot get to work on a Windows Server. Do I have to put in a file path on Windows.

Thanks in anticipation

Macca

[macca]

Forgot to say that this is a web server NOT a local server

Macca

[peterlaursen]

The statement 'cannot make it work' does not help us to understand the problem you are facing. We need to understand the full environment and more details about the problem/error. What happens (that should not) and what does not happen (that should)?

Please

1) Confirm we are talking about SQLyog? Exactly what version?

2) Confirm that you have installed SQLyog on a local machine. You can connect to a specific Linux server but not a specific Windows server. Is this correct? On did you install SQLyog on the servers?

3) Tell if you use any kind of tunnelling?

4) What exact error do you get ? Please provide both error no. and error message (if applies). A screensshot could be useful too. And for conection porblems read read FAQ's here: http://www.webyog.co…ion-issues.html

5) I understand that you have been using an older version before. Can you comfirm that the older version worked with both (and same) servers? If you have installed SQLyog on the Windows server, you should know that support for Windows 2000 stopped from version 8.6 onwards (Windows 2000 will report that it is not a valid Win32 program).

6) BTW: any reference to any other application (Cpanel or whatever) is irrelevant. SQLyog has no dependencies on any server administration software or client on the server. What SQLyog needs is 'compiled in' (or 'statically linked' if you prefer).

[macca]

'peterlaursen' wrote:

The statement 'cannot make it work' does not help us to understand the problem you are facing. We need to understand the full environment and more details about the problem/error. What happens (that should not) and what does not happen (that should)?

Please

1) Confirm we are talking about SQLyog? Exactly what version? –

Answer : Yes SQLyog

2) Confirm that you have installed SQLyog on a local machine. You can connect to a specific Linux server but not a specific Windows server. Is this correct? On did you install SQLyog on the servers?

Answer : Naturally – how else would you install it.

3) Tell if you use any kind of tunnelling?

Answer : Using your PHP file in the root directory

4) What exact error do you get ? Please provide both error no. and error message (if applies). A screensshot could be useful too. And for conection porblems read read FAQ's here: http://www.webyog.co…ion-issues.html

Answer : Error 2003 Can't connect to MySql Server on 'localhost' (10061)

5) I understand that you have been using an older version before. Can you confirm that the older version worked with both (and same) servers? If you have installed SQLyog on the Windows server, you should know that support for Windows 2000 stopped from version 8.6 onwards (Windows 2000 will report that it is not a valid Win32 program).

Answer : never used an older version on a Windows Web server. What I dis when I could not get access to MySQL on windows I used the same, But relevant information, on a Linux web server and I was able to Tunnel to MySQL. Obviously there is something different that is necessary when tunneling to a Windows Server.

Please note that both these are web servers and not hosted locally.

Macca

[macca]

Further to point 1

1) Confirm we are talking about SQLyog? Exactly what version? –

Answer : Yes SQLyog and since I have just upgraded then the answer is the latest.

Macca

[macca]

'macca' wrote:

Further to point 2

http Tunneling

Macca

[peterlaursen]

Error 2003 is described here:

http://www.webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

In this case it is connection between the tunneller/webserver/PHP-system and MySQL that fails (it is not a problem to connect to the tunneler). You would get same error with any PHP script using same connection details. Also note that this is a *connection problem* and not an *authentication problem* (so it is not user/password that is not recognized).

If you use 'localhost' as host-specifier, please try once '127.0.0.1' instead. You may check your host file (normally C:WindowsSystem32driversetchosts) for alias'es to use for '127.0.0.1'. Is 'localhost' listed as an alias here?

(and the reason why I asked if you had installed on a local machine is that some people will install on the server and connect via a VPN-tunnel. But we generally recommend to install on local machine)

[macca]

Yes changed to 127.0.0.1 got error 2003 Can't connect to MySQL server on '127.0.0.1' (10061)

Regrds

Macca

[peterlaursen]

Did you verify all possible reasons listed in the FAQ including firewall settings for the MySQL port (normally 3306) and 'skip_networking' setting in the MySQL configuration?

[macca]

I know that my firewall allows 3306 as I can get to MySql on my Linux sites and I have tunneling ticked and the correct php file in the root of the Windows server.

Regards

Keren

[peterlaursen]

1) Please try to go to the 'advanced' button in the 'HTTP' tab and try the various HTTP content types. Also try with base 64 encoding.

2) Please try to put the tunneler file in another folder. It is seen before that PHP scripts in root directory is not allowed to connect.

3) Maybe you could share phpinfo() from this server?

4) You could let us try. You may create a private support ticket by sending a mail to [email protected]

[Author]

Posts