Solved

Connect to MS SQL 2005 Cluster on IPSEC VPN

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Simple SQL query from two tables 13 54
TSQL query to generate xml 4 34
SQL view 2 27
Increment column based of a FK 8 22
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 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