Is it possible to monitor a SQL Server 2000 server only installed as an instance?
SQL Enterprise manager uses: [servername]\[instancename] For monitoring MS SQL 2000 Server, you have to specify the Host Name or IP Address of the machine in which MS SQL Server is running. What is shown in Enterprise Manager is [servername]\[instancename]. Here servername refers to the machine in which the MS SQL 2000 Server is running and instancename refers the name of the MS SQL 2000 Server. Hence while adding the MS SQL 2000 server, you have to specify only the servername part in the Hostname / IP Address field and not the instancename. [Questions] 21. I’ve configured Monitors and created actions and threshold profiles in one of my machines, say Beta. Is there a way to export this data (alerts, monitors & threshold profiles) to some file, which can then be imported onto another application manager in the deployment server?
SQL Enterprise manager uses: [servername]\[instancename] For monitoring MS SQL 2000 Server, you have to specify the Host Name or IP Address of the machine in which MS SQL Server is running. What is shown in Enterprise Manager is [servername]\[instancename]. Here servername refers to the machine in which the MS SQL 2000 Server is running and instancename refers the name of the MS SQL 2000 Server. Hence while adding the MS SQL 2000 server, you have to specify only the servername part in the Hostname / IP Address field and not the instancename. To monitor an instance, give the host name of the machine in which MSSQL instance is running in the Host Name field. DO NOT give the MSSQL instance Name in the Host Name field. When you are running multiple instances of SQL Servers in one computer, you will have different ports associated for each instance. You can add each instance in Applications Manager by specifying the port for that instance. To find the port in which each instance is running
SQL Enterprise manager uses: [servername]\[instancename] For monitoring MS SQL 2000 Server, you have to specify the Host Name or IP Address of the machine in which MS SQL Server is running. What is shown in Enterprise Manager is [servername]\[instancename]. Here servername refers to the machine in which the MS SQL 2000 Server is running and instancename refers the name of the MS SQL 2000 Server. Hence while adding the MS SQL 2000 server, you have to specify only the servername part in the Hostname / IP Address field and not the instancename. [Questions] 20. I’ve configured Monitors and created actions and threshold profiles in one of my machines, say Beta. Is there a way to export this data (alerts, monitors & threshold profiles) to some file, which can then be imported onto another application manager in the deployment server?
