Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unable to connect to sql server via internal IP internally

Status
Not open for further replies.
19972003

19972003

MIS
Joined
Feb 16, 2007
Messages
205
Location
US
Hi, I am trying to connect to one of the sql servers within the NAT and I got Sql error: 17:
eg: Host(A) 192.168.2.3 Host (B) 192.168.2.5(this is the sql server 2005 SE/Windows 2003 EE)

if I try to connect to it via External Ip, it works fine. thoughts?

many thanks,
 
Sort by date Sort by votes
How are you tyring to connect: Windows Authentication or SQL Authentication.
Is there a login?
Has the login been granted permissions?
What are you using to connect with, an application, sql tools, other?
 
Upvote 0 Downvote
Windows Auth and SQL auth
yes
yes
sql tools


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
SQL Server in Windows
Replies
1
Views
987
pjw001
pjw001
CodeWell
  • Locked
  • Question Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
857
CodeWell
CodeWell
bethabernathy
  • Locked
  • Question Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
729
dhookom
dhookom
dgillz
  • Locked
  • Question Question
SQL View not available to Excel Power Query
Replies
1
Views
731
dgillz
dgillz
torquinian
  • Locked
  • Question Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
714
torquinian
torquinian

Part and Inventory Search

Sponsor

Back
Top