+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    312
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25

    Cannot connect to remote SQL server

    Hi,

    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?

    Thanks

  2. #2
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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

  3. #3
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    312
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25
    No just the one

  4. #4
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    312
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25
    Even with multiple instances you don't need to specify a port if your config is set to dynamic ports.

  5. #5

    Join Date
    Apr 2006
    Posts
    387
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    - what actual error is being reported?
    - how are you attempting to connect? (command line, via an app etc)

SHARE:
+ Post New Thread

Similar Threads

  1. Cannot connect to the Citrix XenApp Server
    By ozydave in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 16th October 2009, 09:25 PM
  2. Sophos cannot connect to update server
    By googlemad in forum Windows
    Replies: 6
    Last Post: 24th July 2009, 02:43 PM
  3. Cannot connect to any VNC or RDP servers
    By sidewinder in forum Mac
    Replies: 3
    Last Post: 3rd August 2008, 06:49 PM
  4. Localhost to Remote Host server
    By leco in forum EduGeek Joomla 1.0 Package
    Replies: 8
    Last Post: 28th January 2008, 09:49 PM
  5. WSUS not connecting to the upstream server
    By ticker in forum Windows
    Replies: 2
    Last Post: 11th June 2007, 01:18 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •