Saturday, July 11, 2015

Problem with remote connection to my sql server 2008 R2

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

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...