• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

Connecting SQL Server hosted on another domain via a VPN Connection

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
NicholasSmith
Asked:
NicholasSmith
  • 3
  • 2
1 Solution
 
RiteshShahCommented:
is your server allowed SQL Authentication? check by right clicking in server instance and property.

0
 
NicholasSmithAuthor Commented:
The server is set to allow both windows and sql authentication
0
 
RiteshShahCommented:
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
RiteshShahCommented:
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
 
NicholasSmithAuthor Commented:
i'm in the process of updating service packs so will let you know once this is sorted. thanks
0
 
Hemantgiri S. GoswamiModerator - MSDN ForumsCommented:
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now