Can't connect to aliased SQL Server 2012

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Can't connect to aliased SQL Server 2012

Postby ngarris » Tue Nov 19, 2013 11:16 pm

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!
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby ngarris » Tue Nov 19, 2013 11:50 pm

I should add that on the server running SQL Monitor (which also hosts SQL Server and the SQL Monitor database), I added an alias for the aliased server using SQL Server Configuration Manager.
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby priyasinha » Thu Nov 21, 2013 12:41 pm

Hi,

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby ngarris » Thu Nov 21, 2013 5:25 pm

Thanks. I tried editing the properties to connect using TCP/IP and the correct port number (all other settings left at default). I tried both the alias and the actual server name. Both come up unreachable.
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby ngarris » Thu Nov 21, 2013 5:26 pm

P.S. I can successfully ping the server I want to add from the server which is running SQL Monitor.
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby priyasinha » Fri Nov 22, 2013 2:08 pm

Are you able to add the server itself in SQL Monitor? Ideally, if the connection issue exists with SQL Server only then you should still be able to add the server hosting SQL Server to SQL Monitor? Can you try doing data collection tests at listed here http://documentation.red-gate.com/pages ... d=17270677?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby ngarris » Fri Nov 22, 2013 4:40 pm

No, SQL Monitor cannot reach the Windows host, it is unreachable.
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby ngarris » Fri Nov 22, 2013 11:37 pm

Here are the results of the suggested tests to diagnose SQL Monitor connection problems. I have passed them along to our server admins to see if they can resolve these issues.
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.
ngarris
 
Posts: 10
Joined: Thu Jun 17, 2010 7:45 pm

Postby priyasinha » Tue Nov 26, 2013 11:04 am

Hi,

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest