Can't connect to aliased SQL Server 2012
ngarris
Posts: 19
For security, we've given a new SQL Server default instance an alias with a non-standard port. Using the alias (and also using the server name) we are not able to connect using SQL Monitor, it says the Windows host is unreachable. We are able to connect using the alias from Management Studio on two DBA desktops. Can you help? Thanks!
Comments
Are you able to ping this machine (which hosts aliased SQL Server) from the machine which has SQL Monitor Base Monitor service installed? Windows host unreachable message indicates that machine hosting SQL Monitor Base Monitor is not able to see this machine which is hosting aliased SQL Server.
For connecting to SQL Server on non-standard port, select the SQL Server and then click 'Edit credentails'. After this, click 'Edit properties', you should be able to enter port number here.
Thanks,
Priya
Project Manager
Red Gate Software
Thanks,
Priya
Project Manager
Red Gate Software
1. Ping works.
2. Remote registry access does not work (PerfMon on SQL Monitor server, logged on as login used to access database server, will not access the database server).
3. WMI does not work when accessed from the SQL Monitor server.
4. Remote file access works.
5. The SQL connection fails for both Windows and SQL logins.
Thanks for your reply.
This help page lists the permission you require for monitoring a machine and SQL Server.
If you are using Base Monitor account to monitor this server then make sure that the account has required permission on the server and SQL Server.
Thanks,
Priya
Project Manager
Red Gate Software