Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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...

share|improve this question

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

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

1 Answer 1

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.