How to connect to the shared Database Server

From: RichardV (rvienotnews_at_nospam_free.fr)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 16:05:52 +0200

Hi,

We have several development workstations in a domain but the Database server
in located
on a PC which is not in this domain. There is no problem to remotly access
the SQL server
from one the workstation, using any Database Manager.
Visual studio tools can not, error is "cannot connect to the database at
'servername'.

We think it's an identification problem, looks like the Component Database
Manager
uses only the "Windows" authentication and not the SQL Server
"authentication".
Is this correct ?

If yes, is there a way to bypass this problem, allowing the developpers to
access
this "out of domain" SQL server ?

Thanks,

Richard.

Relevant Pages