I have written several applications using Delphi. These applications use ADO to access a SQL Server 2000 database on one of our servers. One system has had the database access stop working. All other systems are still working well. When I try to use Management Studio Express to connect to the database from the computer I get:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Server Network Interfaces, error: 26 - Error locating Server/Instance Specified)(Microsoft SQL Server)
Now, there should be no discussion of whether or not I have TCP/IP enabled on the server as it is working with other systems. There should be no discussion of turning off the firewall on the server as it is working with other systems. From what I have seen there is an issue in how the client talks to the server using UDP. How would I go about trying to diagnose this problem?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.