Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connect to MS SQL 2005 Cluster on IPSEC VPN

Posted on 2009-04-07
2
Medium Priority
?
598 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 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