Red Gate forums :: View topic - Can't connect to aliased SQL Server 2012
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Can't connect to aliased SQL Server 2012

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Tue Nov 19, 2013 11:16 pm    Post subject: Can't connect to aliased SQL Server 2012 Reply with quote

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!
Back to top
View user's profile Send private message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Tue Nov 19, 2013 11:50 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Nov 21, 2013 12:41 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Thu Nov 21, 2013 5:25 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Thu Nov 21, 2013 5:26 pm    Post subject: Reply with quote

P.S. I can successfully ping the server I want to add from the server which is running SQL Monitor.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Nov 22, 2013 2:08 pm    Post subject: Reply with quote

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/viewpage.action?pageId=17270677?

Thanks,
Priya
Back to top
View user's profile Send private message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Fri Nov 22, 2013 4:40 pm    Post subject: Reply with quote

No, SQL Monitor cannot reach the Windows host, it is unreachable.
Back to top
View user's profile Send private message
ngarris



Joined: 17 Jun 2010
Posts: 10

PostPosted: Fri Nov 22, 2013 11:37 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Tue Nov 26, 2013 11:04 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group