Alarm Database problems

Alarm db viewer doesn't display historical data when I try to take it from in-sql. We have Microsoft SQL and INSQL both installed on one machine. While configuring (window maker) alarm I put the proper server name, login id (sa) and password. When I do test connection it shows connected but when I go to run time mode and try to take historical time it takes a long time and gives me message "Timeout expired". When I close message it shows disconnected at bottom right and bottom left it shows the name of server. What is the problem? Can anybody please tell me?

You can set the no. of alarms to be display as 100 at one time or assign the StartTime and EndTime properties within a certain period. This will filter the amount of alarms querying from the database and reduce the query time.