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.
LVL 1
NicholasSmithAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
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
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
RiteshShahCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.