Solved

Connect to MS SQL 2005 Cluster on IPSEC VPN

Posted on 2009-04-07
2
592 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

895 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

16 Experts available now in Live!

Get 1:1 Help Now