Tcp\ip

Quote:

---

Originally Posted by HappyHardcore

It sounds like a protocol problem, use the client management utility and look around through the tcp/ip protocol. Try all IP variances in it.

---

^ If you have everything then try the advice.

lol Okie Dokie...

• Open up the configuration manager.
• Now hit the plus next to Network Configuration
• Click on the Protocols.
• On the right side double click TCP/IP
• Click the IP Addresses Tab
• Under IP1, make it...
  Active=yes
  Enabled=yes
  IP Address=WAN IP
  TCP Dynamic Ports=1433
  TCP Port=Leave Blank
  
  Leave IP2 Alone.
  
  For IP All
  TCP Dynamic Port=1433
  TCP Port=Leave Blank

Do not fill in both TCP Dynamic Port and TCP Port with the the port 1433. It will in most cases cause your SQL server not to start, and your SQL Server Browser not to turn on.

While you are At it, in the Configuration Managment Utility, Restart both the SQL Server, and the SQL Browser. Both need to be started.

Now when it comes time to connect to your server from the there remote server, there's different ways you can attempt to connect.

Your WAN IP,1433
or
Your LAN IP,1433

Examples

Code:

---

24.123.456.789,1433
or
192.168.1.78,1433

---

Another Method would be to add your \SQLINSTANCE name after the IP and port.

Your WAN IP,1433\SQLINSTANCENAME
Your LAN IP,1433\SQLINSTANCENAME

Examples

Code:

---

24.123.456.789,1433\SQLEXPRESS
or
192.168.1.78,1433\SQLEXPRESS

---

You will also need to make sure the port 1433 is open in your router for the computer that will be running the SQL server.

It worked!! Thank you HappyHardcore and thank you SiK for helping me...