up vote 0 down vote favorite
share [g+] share [fb]

I wanted to use my PC as SQL Server and connect to it from my notebook but I can't connect to it via public IP adress. Later i will need to create connection string to my c# application but for now I'm just using SSMS for testing. Few details about my configuration :

  • I'm allowing remote connection to this server.
  • Server authentication is in mixed mode.
  • SQL Server browser is on.
  • TCP/IP protocol is enable.
  • I'm forwarding port 1433 on my router.
  • I turned off my firewall and AV for testing.
  • I can ping my PC by it's public IP adress.
  • I can connect to SQL Server by it's local IP adress...

I can't figure out what I'm doing wrong...

link|improve this question
feedback

migrated from stackoverflow.com Jun 26 '11 at 16:58

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 0 down vote

If you're using a named instance of SQL Server, then you must also forward SQL Server Browser port ( by default UDP 1434 )

link|improve this answer
I forwarded 1434 port too. Still can't connect via public IP. – Disper Jun 26 '11 at 16:08
feedback

Your Answer

 
or
required, but never shown
discard