Solved

Connecting SQL Server hosted on another domain via a VPN Connection

Posted on 2009-04-15
6
611 Views
Last Modified: 2012-05-06
we have sister company in a separate part of the country which we connect to via a VPN connection. We would like to connect to their SQL Server 2000 databases on their domain. We can ping the server ip address on their domain but when we try to register the server we get the following error message:

A connection could not be established to XXXXXX.
Reason: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection..
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the XXXXXX node) and try again.
0
Comment
Question by:NicholasSmith
[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
  • 3
  • 2
6 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24146256
is your server allowed SQL Authentication? check by right clicking in server instance and property.

0
 
LVL 1

Author Comment

by:NicholasSmith
ID: 24146268
The server is set to allow both windows and sql authentication
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24146301
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 31

Accepted Solution

by:
RiteshShah earned 250 total points
ID: 24146320
have updated you SQL Server with latest SP version? Right now I am not using SQL 2K but I faced same problem in my past due to SP. I would insist you upgrade it along with all security patches.
0
 
LVL 1

Author Comment

by:NicholasSmith
ID: 24146640
i'm in the process of updating service packs so will let you know once this is sorted. thanks
0
 
LVL 7

Expert Comment

by:Hemantgiri S. Goswami
ID: 24154642
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

617 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