SQL Remote Connection Error 26

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Other SQL Server 2012 Topics

SQL Remote Connection Error 26

Author

Topic

intelligence
Starting Member

2 Posts

Posted - 2014-09-03 : 05:00:15

I have this problem but I digged everywhere on solution, I tried almost everything. I have a static IP from my ISP and I try to connect Sql Server 2012 via internet.

First I tuned my router for port forwarding (TCP: 1433 and UDP: 1434, IP for TURAN: 192.168.1.27):

Second I tuned SQL Server Configuration:

Third I tuned Protocols for SQLEXPRESS:

Then I tuned my Windows Firewall:

Then I checked if ports is open via portqry:

After all, I am able to connect SQLEXPRESS like this:

But Not like that: (That is what I need to connect remotely, XXX.XXX.XXX.XXX means my static IP from my ISP)

Could you help?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-09-04 : 01:44:30

Hi , Try the steps in this error 26 troublehooting checklist - and report back - http://www.sqlserver-dba.com/2011/05/sql-server-error-26-troubleshooting-checklist.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

intelligence
Starting Member

2 Posts

Posted - 2014-09-04 : 08:48:36

I solved!.. Thank you jackv.. I tried "tcp:XXX.XXX.XXX.XXX\SQLEXPRESS" for Server Name and I connected.. Thank you again.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-09-05 : 01:43:19

@intelligence - you're welcome

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources