Windows Server 2008 R2 Thread, Cannot connect to remote SQL server in Technical; Hi,
I have installed SQL express 2012 on a win2008r2 server. For the life of me I cannot remotely connect ...
23rd April 2013, 11:46 AM #1
Cannot connect to remote SQL server
I have installed SQL express 2012 on a win2008r2 server. For the life of me I cannot remotely connect to the SQL instance.
I have allowed remote connections in the management Studio, windows firewall is disabled, TCP/IP is enabled in configuration manager with all IPs set to dynamic ports.
I can't seem to connect, what am I missing? Can I use a specific tool to diagnose what is stopping me?
IDG Tech News
23rd April 2013, 12:27 PM #2
Do you have just the one SQL instance installed? If you have two plus SQL instances installed on the same server, you have to include the TCP port being used by the instance you want to connect to. EG: SQL-SERVER-01\SIMS2008,1435
23rd April 2013, 02:04 PM #3
24th April 2013, 12:19 AM #4
Even with multiple instances you don't need to specify a port if your config is set to dynamic ports.
24th April 2013, 12:53 PM #5
- what actual error is being reported?
- how are you attempting to connect? (command line, via an app etc)
By ozydave in forum Thin Client and Virtual Machines
Last Post: 16th October 2009, 10:25 PM
By googlemad in forum Windows
Last Post: 24th July 2009, 03:43 PM
By sidewinder in forum Mac
Last Post: 3rd August 2008, 07:49 PM
By leco in forum EduGeek Joomla 1.0 Package
Last Post: 28th January 2008, 10:49 PM
By ticker in forum Windows
Last Post: 11th June 2007, 02:18 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)