SQLTeam.com | Weblogs | Forums

MSSQL 2012 R2 Remote Connection via IP

sql2012

#1

Hello,

I have a server running MSSQL Server 2012 R2, connections within the network is working but I can't seem to allow connections via IP from outside the network.

What is done:

  1. added Firewall inbound rule for TCP port 1433
  2. router is setup for Port forwarding to the server for port 1433
  3. SQL SERVER (MSSQLSERVER) service is running
  4. SQL Server Config Manager TCP/IP is enabled.

What am I missing?


#2

You need to follow the given steps which stated in very easy way. In this blog steps for 2008 Version of SQL Server, hope it will be helpful for you also. http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx


#3

I followed the steps exactly and got the error message

"Test connection failed becasue of an error in initializing provider. [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection."

:cry: Any ideas why?


#4

I can't believe this took me so long, but it's finally fixed! :0) Thanks Jason_clark!

Here's what I did:

  1. set IPALL Dynamic Port = 0, TCP Port = Blank
  2. restart SQL SERVER
  3. make sure SQL SERVER AGENT is Running
  4. SQL Server Browser is Running
  5. go back to check what the IPALL Dynamic Port is, for example 50230
  6. set new firewall Inbound rule, TCP Port 50230, Allow all connections, Check off Domain and Private and Public
  7. Port forward TCP 50230 to your server local IP on your router
  8. test connection with UDL or directly connect with SSMA, Server name [Server WAN IP], [dynamic Port] ex. 123.12.33.123, 50230