Solved

Connect to MS SQL 2005 Cluster on IPSEC VPN

Posted on 2009-04-07
2
591 Views
Last Modified: 2012-06-21
I have an IPSEC VPN through my pfSense to my clients local network via their SonicWall.  

I can connect to any authorized server or share on the local subnet, and an MS SQL instance running on a single server.  

I can NOT connect to the 2-server cluster on the same subnet.  Permissions, logins and users are the same for the cluster and the single instance. (they were copied) Everyone on the local subnet connects with no problem.  

It is configured for remote connections, named pipes, dynamic TCP/IP, just as the single server was.  

I don't know what to try next.  Any ideas?
0
Comment
Question by:jriggin
2 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 24117416
How are you doing authentication -- SQL or Windows? If Windows, are the users in a trusted domain?

>> It is configured for remote connections, named pipes, dynamic TCP/IP,...

Disable Named Pipes. They are nothing but trouble.
0
 
LVL 1

Accepted Solution

by:
jriggin earned 0 total points
ID: 24118183
We were using SQL authentication.  Apparently it was an issue between pfSense IPSEC and SonicWall.  Installation of the SonicWall client resolved the issue.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now