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?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.