Is it possible to use or develop an APM for a SQL 2005 UE which uses a port other than 1433?
Hello sotherls,
Currently it is not possible to specify port for SQL UE monitor in APM. However you can create alias for instance you want to monitor and monitor this alias instead. Creating aliases is described here:
www.mssqltips.com/tip.asp
ODBC User Experience Monitor might be used for this purpose.
I would suggest connection string in format: Driver={SQL Server};Server=${IP},1433\INSTANCE_NAME;DataBase=DBNAME;Uid=${USER};Pwd=${PASSWORD};
Where 1433 is port number.