Trouble getting the MS SQL test to work

Wooltown · Joined: 22 May 2002 Posts: 115 Location: Sweden

Hi !

I have installed Client Connectivity and Client Tools, so I can from Enterprise Manager reach my MS SQL server, but it doesn't work, I just get No Answer, with SQL userid and password, any ideas of what to do !

/Sven

simonl · Joined: 03 Apr 2002 Posts: 49

What did you use when specify MS SQL server, name or ip address?. Go to client network utility from sql server program folder and create server alias as server name and server name as ip address. From Hostmonitor test method put MS Sql server ip address instead of server name.

Wooltown · Joined: 22 May 2002 Posts: 115 Location: Sweden

Thank you for the tip, but it didn't help

In client network utility I have tried to enter alias as SERVERNAME and \SERVERNAME but with no success, I get No answer all the time. I have entered IP-address with or without \, it's realy strange.

From SQL Query analyzer it works with any computername as alias, I tested to enter MONKEY as alias in client network Utility and then I connected to MONKEY from Query Analyzer and succeeded.

Any more ideas ?

simonl · Joined: 03 Apr 2002 Posts: 49

You did not provide what you try to check.
If it's MS SQL Server databases, service or process. If you try to check database select ip address for SQL Server, try "Master" database, sql server user name and password(for example "sa"). For other you have to provide domain/user with administrative rights to check SQL Server is running or not.

robweb · Joined: 06 Jun 2002 Posts: 12

Try turn on the checkbox 'Revert Alert'. This did it for me concerning Sybase Servers (which' basic connection setup is the same as for MS SQL Servers)

-Rob

robweb · Joined: 06 Jun 2002 Posts: 12

sorry, forget what I said. this is probably not it. (I tested some more and shutdown my Sybase Server, but HM still mentions status = 'OK' for this connection...). Revert alert probably means 'Say OK when it fails and say 'no answer' when it succeeds or something...'

Sorry,
Rob

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

Yes, you are right. There are information about "Reverse alert" option: http://www.ks-soft.net/hostmon.eng/news.htm#RevAlert

Regards
Alex

Wooltown · Joined: 22 May 2002 Posts: 115 Location: Sweden

Hi !

I am trying to connect to the SQL server to test if a database in answering, I am trying to test if I can log in to the master database.
From The Query Analyzer on the same machine, it works just fine, but not from Host Monitor.
I have entered all the information you gave me previously in this case regarding the "Client Network Utility", but the situation is still "No Answer".

/Sven

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

Lets check, does HostMonitor load ntwdblib.dll or does not. Please, open Test Properties dialog for this test. If you will see yellow box with error message on bottom of the dialog, it means HostMonitor cannot load library.
BTW: what version of client do you use?

Regards
Alex

Wooltown · Joined: 22 May 2002 Posts: 115 Location: Sweden

Hello !

No A Yellow box is not visible !

I am using SQL 2000 client trying to test both SQL 7 and SQL 2000 servers but none of the tests work

/Sven

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

I uploaded small program for testing purpose: http://www.ks-soft.net/download/mssqltest.exe It is console application, it has 4 command line parameters: Server Database UserName [Password]. mssqltest.exe uses the same code that uses HostMonitor but it displays diagnostic messages. Hope it will help to resolve problem.

Regards
Alex

Wooltown · Joined: 22 May 2002 Posts: 115 Location: Sweden

Hi Alex !

Yesterday I upgraded to version 3.16, and now it works, I don't know why, but it works great !

Perhaps some file was outdated, thank you very much for all your help !

/Sven