Connect to MS SQL 2005 Cluster on IPSEC VPN

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?
LVL 1
jrigginAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jrigginConnect With a Mentor Author Commented:
We were using SQL authentication.  Apparently it was an issue between pfSense IPSEC and SonicWall.  Installation of the SonicWall client resolved the issue.
0
 
Jim P.Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.